JSON Relational Duality Views in Database 23ai
summary
Oracle Database 23ai implements JSON Relational Duality Views that store data as normalized rows while exposing hierarchical JSON documents for access and updates. A view definition uses a GraphQL-like view syntax (create view … mapping columns and nested objects, with unnest and update clauses) to produce Jill’s schedule as a single JSON document. Documents can be read via SQL and MongoDB APIs and written back; the engine applies changes to underlying rows and enforces optimistic concurrency control, improving mixed-workload performance and removing external ORM code.
AI-written summary · about
chapters (10)
- 0:00JSON relational duality views intro
- 0:28Relational DB strengths/weaknesses
- 3:52Document DB strengths/weaknesses
- 7:15Combining relational and JSON
- 12:01JSON duality explained
- 13:31Creating duality views in 23ai
- 14:58Duality views for JSON access
- 16:23Concurrency control in duality views
- 16:44Key benefits of duality views
- 18:52Resources and closing
related talks
50mGoing beyond ORMs
47mGoing beyond ORMs
44mRevolutionizing objects, documents, and relational development
23mRevolutionizing Data Access Using GraphQL in the Oracle Database
15mPlug-and-Play for JSON and MongoDB Developers
44mWho is Jason, and what’s he doing in my database?
47mDealing with JSON in the Relational World
29mRetire your tables. It's all JSON now.