Going beyond ORMs
summary
Shows that JSON Relational Duality Views let a single Oracle database store relational rows while exposing and accepting JSON documents (defined via GraphQL or JSON mappings), so no dual storage or app-level mapping is required. Demo creates a student_schedule view, inserts a JSON payload and the database materializes relational rows, supports nested/unnest mappings, optimistic concurrency, and works with Spring/Quarkus/Micronaut. Available in Oracle 23c with Docker images and testcontainers support.
AI-written summary · about
chapters (17)
- 0:00Welcome
- 1:10Why ORMs and databases
- 3:18Relational vs document models
- 6:35ORM and JSON challenges
- 12:31NoSQL revolution limits
- 14:20Introducing duality views
- 17:29Duality views with GraphQL
- 20:20Querying and updating data
- 23:54Duality views vs ORMs
- 24:35Getting started Oracle DB
- 27:05Testcontainers for testing
- 28:09Demo setup overview
- 31:18Querying duality views
- 35:21Updating data via duality views
- 37:29Duality views security
- 38:35Try new tech
- 39:16Resources and closing
