Revolutionizing objects, documents, and relational development
summary
Oracle introduces Document Relational Duality as a core feature of Database 23c that stores data as rows and exposes declarative JSON duality views so apps get single-round-trip JSON documents mapped to normalized tables, and PUTs translate back into row updates. It ships SODA and MongoDB-compatible drivers, a serverless Autonomous JSON DB, JSON Schema discovery and SQL parallelism, plus a new value-based ETAG concurrency (lock-free optimistic control) that rejects conflicting PUTs for safe offline and cached writes.
AI-written summary · about
chapters (10)
- 0:00The object relational mismatch
- 4:59Json and document databases
- 8:11Limitations of json storage
- 12:21The case for a new approach
- 17:43Introducing duality views
- 23:15Duality view mechanics
- 26:05Benefits of duality views
- 28:55Optimistic concurrency control
- 34:33JSON schema and SQL domains
- 37:45Conclusion and summary
related talks
44mWho is Jason, and what’s he doing in my database?
19mJSON Relational Duality Views in Database 23ai
15mPlug-and-Play for JSON and MongoDB Developers
47mGoing beyond ORMs
50mGoing beyond ORMs
23mRevolutionizing Data Access Using GraphQL in the Oracle Database
29mRetire your tables. It's all JSON now.
29mDatabase: What's new, what's next