Plug-and-Play for JSON and MongoDB Developers
summary
Oracle Database 23ai shows JSON Relational Duality Views that let relational tables expose unlimited JSON shapes while keeping single-source consistency; demo uses MongoDB Compass and collection tables to import movies, edits a speaker name once and the change immediately appears across all JSON views, and an attempt to write a read-only field returns an Oracle error. Claims include full MongoDB compatibility, fine-grained update controls, CRUD for both models, versioned views to decouple app and schema changes, and replication paths to caches or NoSQL stores.
AI-written summary · about
chapters (6)
- 0:00JSON in Oracle Database
- 2:21Relational versus document
- 4:48The challenges of JSON
- 7:20JSON relational duality
- 10:53Duality view demonstration
- 13:46Conclusion and resources
related talks
44mWho is Jason, and what’s he doing in my database?
50mGoing beyond ORMs
47mGoing beyond ORMs
47mDealing with JSON in the Relational World
19mJSON Relational Duality Views in Database 23ai
44mRevolutionizing objects, documents, and relational development
51mDealing with JSON in the relational world
29mRetire your tables. It's all JSON now.