Skip to Main Content
Think Relational, Stay JSON: Oracle’s Duality View Revolution

About This Workshop

Youtube Video

About This Workshop
Consider these three issues: (1) Are you looking to move data from a document database such as MongoDB to a relational database, but you are unfamiliar with relational concepts? (2) Are you unsure how to model JSON documents as relational tables and how to create the logical model? (3) Are you interested in transparent and automatic application migration from document databases to Oracle? If the answer to at least one of the above questions is “Yes”, then this HOL is just for you! We will show you how to leverage your JSON documents to automatically derive possible relational schemas as the underlying foundation for your documents without losing schema flexibility and best practices for doing so.

Workshop Info

1 hour
  • Lab 1:  Introduction to JSON Collections
  • Lab 2: Introduction to Duality Views
  • Lab 3: Introduction to the JSON to Duality Migrator
  • Lab 4: Schema Design using the JSON to Duality Migrator
  • Autonomous Database 23ai
  • Familiarity with document databases is desirable, but not required
  • Some understanding of database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like