Uploaded July 2026 | Updated September 2026, 2 weeks ago
Modern applications often need to expose the same business data through different API styles while keeping the underlying data model consistent. In this session, you'll learn how Oracle Database JSON Relational Duality Views, Oracle REST Data Services (ORDS), and Oracle APEX work together to expose the same relational data through both REST and GraphQL without duplicating business logic or maintaining multiple data models.
By the end of this session, you'll be able to:
Understand when JSON Relational Duality Views are appropriate.
Expose the same data model through REST and GraphQL using ORDS.
Consume both API styles from Oracle APEX.
Understand how JSON documents can be used for transactional CRUD operations while preserving relational integrity.
Apply a "single source of truth" approach to simplify API architectures and reduce duplicated models.
0:12 - 5:02 - Introduction, Announcements, and Updates - Karina Pastor
5:03 - 8:29 - Oracle ACE Program: Overview and Benefits - Marcelo Batalha
8:30 - 9:50 - Overview of the Session Topic: REST and GraphQL with Oracle APEX and Duality Views - Marcelo Batalha
9:51 - 12:57 - Exposing Data Through APIs: Challenges of API Consumption and How Different Consumers Have Different Needs - Marcelo Batalha
12:58 - 19:57 - REST APIs and GraphQL (ORDS): Comparison; Challenges of Fixed Responses; Overfetching and Underfetching; Architectural Problems in Exposing Business Data Through APIs - Marcelo Batalha
20:00 - 22:23 - JSON Relational Duality Views: Their Significance; Creating a Duality View from Relational Tables and How It Works - Marcelo Batalha
22:24 - 32:43 - Demonstration: REST API Calls and Responses Using Oracle APEX - Marcelo Batalha
32:44 - 35:52 - Demonstration: GraphQL API Calls and Responses Using Oracle APEX - Marcelo Batalha
35:53 - 42:10 - Demonstration: JSON CRUD Operations with Duality Views, Including Creating, Updating, and Deleting Records - Marcelo Batalha
42:11 - 46:33 - Summary of the Main Architectural Messages and Benefits of Using Duality Views - Marcelo Batalha
46:34 - 47:09 - Q&A - Marcelo Batalha
47:20 - 47:38 - Closing Remarks - Karina Pastor
Please share your questions about Oracle APEX on the Community Forum: apex.oracle.com/forum
Modern applications often need to expose the same business data through different API styles while keeping the underlying data model consistent. In this session, you'll learn how Oracle Database JSON Relational Duality Views, Oracle REST Data Services (ORDS), and Oracle APEX work together to expose the same relational data through both REST and GraphQL without duplicating business logic or maintaining multiple data models.
By the end of this session, you'll be able to:
Understand when JSON Relational Duality Views are appropriate.
Expose the same data model through REST and GraphQL using ORDS.
Consume both API styles from Oracle APEX.
Understand how JSON documents can be used for transactional CRUD operations while preserving relational integrity.
Apply a "single source of truth" approach to simplify API architectures and reduce duplicated models.
0:12 - 5:02 - Introduction, Announcements, and Updates - Karina Pastor
5:03 - 8:29 - Oracle ACE Program: Overview and Benefits - Marcelo Batalha
8:30 - 9:50 - Overview of the Session Topic: REST and GraphQL with Oracle APEX and Duality Views - Marcelo Batalha
9:51 - 12:57 - Exposing Data Through APIs: Challenges of API Consumption and How Different Consumers Have Different Needs - Marcelo Batalha
12:58 - 19:57 - REST APIs and GraphQL (ORDS): Comparison; Challenges of Fixed Responses; Overfetching and Underfetching; Architectural Problems in Exposing Business Data Through APIs - Marcelo Batalha
20:00 - 22:23 - JSON Relational Duality Views: Their Significance; Creating a Duality View from Relational Tables and How It Works - Marcelo Batalha
22:24 - 32:43 - Demonstration: REST API Calls and Responses Using Oracle APEX - Marcelo Batalha
32:44 - 35:52 - Demonstration: GraphQL API Calls and Responses Using Oracle APEX - Marcelo Batalha
35:53 - 42:10 - Demonstration: JSON CRUD Operations with Duality Views, Including Creating, Updating, and Deleting Records - Marcelo Batalha
42:11 - 46:33 - Summary of the Main Architectural Messages and Benefits of Using Duality Views - Marcelo Batalha
46:34 - 47:09 - Q&A - Marcelo Batalha
47:20 - 47:38 - Closing Remarks - Karina Pastor
Please share your questions about Oracle APEX on the Community Forum: apex.oracle.com/forum
