Who is Jason, and what’s he doing in my database?
summary
Claim: a single modern RDBMS can replace many specialist stores by supporting JSON columns, a document API, and a new Duality views layer that exposes relational data as JSON with automatic CRUD and optimistic locking via ETags. Demonstrations use Oracle 21/23c features (OSON binary JSON, JSON_TABLE, JSON operators), MongoDB compatibility and SODA REST, in‑DB JavaScript, JSON Schema validation, and indexes. Example apps: movie catalog and student schedules show reduced duplication and working updates; interoperability with existing MongoDB client code proves the approach.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 2:07Microservices complexity
- 8:09Relational databases today
- 12:23JSON in tables
- 18:47Document API limits
- 23:25Student schedule example
- 26:58Duality views
- 33:18Relational evolution benefits
- 35:05Q&A
related talks
15mPlug-and-Play for JSON and MongoDB Developers
29mRetire your tables. It's all JSON now.
44mRevolutionizing objects, documents, and relational development
47mDealing with JSON in the Relational World
51mDealing with JSON in the relational world
47mGoing beyond ORMs
50mGoing beyond ORMs
19mJSON Relational Duality Views in Database 23ai