Retire your tables. It's all JSON now.
summary
Claim: JSON is great for flexible app schemas but not a drop-in replacement for relational analytics, so hybrid storage wins. Demo uses Autonomous Database 21c with the new JSON data type and the SODA (Simple Oracle Document Access) API to create collections, insert student/course JSON, and run query-by-example and SQL nested queries. The example builds a school dataset, shows JSON-to-table projection and table-to-JSON generation, and the combined approach performs and preserves referential querying.
AI-written summary · about
chapters (10)
- 0:00Intro
- 1:00Why JSON
- 1:56Application example
- 4:58Inline vs Relational
- 6:32Schema Flexibility
- 9:34Use Cases
- 11:18Data Repetition
- 14:01What now
- 14:40Demo
- 20:06JSON API
related talks
44mWho is Jason, and what’s he doing in my database?
47mDealing with JSON in the Relational World
51mDealing with JSON in the relational world
15mPlug-and-Play for JSON and MongoDB Developers
44mRevolutionizing objects, documents, and relational development
47mGoing beyond ORMs
50mGoing beyond ORMs
42mHow to Store JSON in a Database Without Attracting the DBA's Attention