JSON Relational Duality
Combine the simplicity of the JSON document model with the power of the relational model using JSON Relational Duality. This transformative data modeling capability in Oracle AI Database solves the age-old problem of object-relational mismatch, letting applications simultaneously treat the same underlying data as JSON documents or relational tables, as needed by the use case.
Beyond MongoDB: Achieving Simplicity and Cost Savings with Oracle AI Database
Get the ease of JSON and the power of relationalUnify the simplicity benefits of JSON with the efficiency and sophistication of relational, without any trade-offs.
Duality Views is database native and language independent, eliminating the limitations and inefficiencies of bolted-on ORMs.
Leave document databases far behindCombine JSON access with all the converged Oracle AI Database 26ai features, such as AI Vector Search, Graph, and Spatial.
JSON Relational Duality Views make it easy to evolve applications as they add new use cases, without requiring new copies of data.
Easily build RESTful and mobile applicationsLock-free concurrency control lets developers easily build massively concurrent applications.
Freely combine JSON APIs, REST, and standard SQL, depending on your use case.
JSON Relational Duality is a new data modeling capability that features updatable and consistent JSON document views over relational data. This allows data that is stored efficiently in relational tables to be accessed as simple JSON documents. JSON Relational Duality Views can be accessed with document APIs, such as MongoDB-compatible APIs, REST, and SQL. JSON Relational Duality Views is a transformative capability that decouples the access format from the storage format for database-resident data. This capability enables applications to treat data interchangeably as JSON documents or as relational tables depending on the use case. Unlike document databases, JSON Relational Duality Views allow the same underlying data to be consistently shared and updated from different document collections.
Key features of JSON Relational Duality
JSON and relational unification
Data can be read and written either as JSON documents or relational tables, providing full flexibility for developers.
Lock-free concurrency control
Duality Views utilize a lock-free or optimistic concurrency control mechanism that allows fully consistent database reads and writes without the need to hold locks across accesses.
Fine-grained access rules
Duality Views allow simple and fine-grained customization of data access and updatable rules for different application modules that share the same data.
Simple, GraphQL-based declarations
In addition to SQL, Duality Views can be defined using a simple and intuitive GraphQL-based syntax.
Automatic code generation
Duality Views can be described using standard JSON schema that enables automatic generation of REST endpoints, access templates, and application blueprints.
JSON to Duality Migrator
JSON to Duality Migrator analyzes collections of JSON documents and recommends the optimal set of normalized tables and Duality Views into which the documents from the collections can be imported.
Learn all about JSON Relational Duality - Review the capabilities on Oracle Help Center
See what top industry analysts are saying about JSON Relational Duality
-
![]()
“Definitely ends the long-running ‘relational vs. document’ debate with JSON Relational Duality delivering the best of both worlds.”– Marc Staimer Senior Analyst, Wikibon
-
![]()
“Oracle’s JSON Relational Duality is perhaps one of the most important innovations in information science in 20 years.”– Carl Olofson Research Vice President, Data Management Software, IDC
-
![]()
“Simplifies the development process with the ability to unify relational data and JSON documents.”– Ron Westfall Senior Analyst and Research Director, Futurum Group
Featured blog posts
JSON-to-Duality Migrator
Are you looking to move data from a document database such as MongoDB to a relational database, but are unfamiliar with relational concepts? Are you unsure how to model JSON documents as relational tables and how to create the logical model? Are you interested in transparent and automatic application migration from document databases to Oracle? If your response to any of the above questions is “yes,” you’ll want to check out this blog for answers and best practices.
To SQL or not to SQL: that is not the question
While native binary JSON storage, document APIs and SQL/JSON functionality represent strong progress, JSON Relational Duality takes things a step further. This new capability offers the best of both relational and JSON documents without the trade-offs of either model. In short, duality views store the JSON documents internally in a highly efficient normalized format, using relational and JSON constructs. At the same time, developers interact with JSON documents.
GoldenGate for MongoDB Migrations
Using Oracle GoldenGate for MongoDB Migrations, you can seamlessly migrate MongoDB databases from version 6.0 onwards to Oracle Autonomous AI JSON Database as well as Oracle JSON Collection tables in Oracle AI Autonomous Database or non-autonomous databases in the cloud or on-premises. Oracle provides a MongoDB API, so you will be able to use client applications, open-source tools and drivers the same way you did before.
Additional JSON Relational Duality resources
Documentation
Get Started
Migration Tools
Get started with JSON Relational Duality
Try it on freesql.com
Read the latest guidance and start coding.
Try Oracle Cloud Free Tier
Build, test, and deploy applications on Oracle Cloud Infrastructure Platform.
LiveLab
In this hands-on lab, you’ll explore native JSON, the MongoDB-compatible API, and Duality View
Contact Us
Interested in learning more? Contact one of our industry-leading experts.