Going beyond ORMs
summary
Demonstration of JSON Duality Views shows Oracle maps existing relational tables into writable JSON or GraphQL views so clients can send JSON payloads directly and the database translates them into INSERT/UPDATE/DELETE on underlying tables. Demo uses Oracle Database 23c (23.4), Docker/testcontainers, Micronaut (examples applicable to Spring Boot and Quarkus) and Liquibase; an inserted JSON becomes a relational row. Views are virtual (not materialized), database handles query/transform work to avoid app-level migrations, and Oracle claims this scales to large datasets.
AI-written summary · about
chapters (10)
- 0:00Introduction and welcome
- 1:48Current state of relational data
- 8:55Pros and cons of JSON documents
- 13:10Combining relational and JSON
- 14:16JSON Relational Duality View
- 24:16Demo setup and prerequisites
- 28:28Micronaut application overview
- 36:19Live demo with database
- 43:17Encouragement and resources
- 44:45Q&A session
related talks
40mGoing beyond ORMs
47mGoing beyond ORMs
19mJSON Relational Duality Views in Database 23ai
15mPlug-and-Play for JSON and MongoDB Developers
44mRevolutionizing objects, documents, and relational development
23mRevolutionizing Data Access Using GraphQL in the Oracle Database
44mWho is Jason, and what’s he doing in my database?
29mRetire your tables. It's all JSON now.