Revolutionizing Data Access Using GraphQL in the Oracle Database
summary
Oracle Database 23ai adds Duality Views that assemble normalized rows into updatable JSON documents and infer a GraphQL schema via get_graphql_schema in the DBMS_JSON_DUALITY package. Declarative GraphQL definitions use directives like @link, @generated, @nest/@unnest and translate to a single correlated-SQL query via a graphql_to_sql routine; the engine pushes filters, uses fast index lookups, and returns editable JSON (example: generated courseCount) and can also execute queries via a graphql table function.
AI-written summary · about
chapters (10)
- 0:00Introduction to session
- 1:43Object-relational mismatch problem
- 3:07JSON Relational Duality explained
- 6:19GraphQL as simplified query language
- 9:13Building GraphQL schema from database
- 11:22Creating Duality view with GraphQL
- 14:15Direct GraphQL queries in Oracle
- 15:17Federation with GraphQL to SQL
- 19:59Key takeaways and conclusion
- 20:42Q&A session
related talks
19mJSON Relational Duality Views in Database 23ai
50mGoing beyond ORMs
44mRevolutionizing objects, documents, and relational development
21mBringing GraphQL Natively To Relational Databases With AI
47mGoing beyond ORMs
44mWho is Jason, and what’s he doing in my database?
15mPlug-and-Play for JSON and MongoDB Developers
31mWhen property graphs join SQL