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 Database 23ai 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.

Oracle JSON Relational Duality overview (44:02)
Announcing Oracle Database 23ai: Bring AI to your data

Larry Ellison and Juan Loaiza discuss the GenAI strategy behind Oracle Database 23ai.

Why JSON Relational Duality?

Get the ease of JSON and the power of relational

Unify the simplicity benefits of JSON with the efficiency and sophistication of relational, without any trade-offs.

Ultraflexible data access

Freely combine JSON APIs, REST, and standard SQL, depending on your use case.

Simple application evolution

JSON Relational Duality Views make it easy to evolve applications as they add new use cases, without requiring new copies of data.

Makes object-relational mapping (ORM) obsolete

Duality Views is database native and language independent, eliminating the limitations and inefficiencies of bolted-on ORMs.

Easily build RESTful and mobile applications

Lock-free concurrency control lets developers easily build massively concurrent applications.

Leave document databases far behind

Combine JSON access with all the converged Oracle Database 23ai features, such as AI Vector Search, Graph, and Spatial.

What is JSON Relational Duality

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.

See what top industry analysts are saying about JSON Relational Duality

  • “Oracle Database 23ai 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
  • “The ability to selectively treat data as JSON or relational while maintaining the power of SQL is fantastic.”

    – Graeme Rocher
    Co-founder and Director, Micronaut Foundation
  • “Oracle Database 23ai simplifies the development process with the ability to unify relational data and JSON documents.”

    – Ron Westfall
    Senior Analyst and Research Director, Futurum Group
May 2024

JSON Relational Duality in Database 23ai Is Now Available

Ranjan Priyadarshi, Senior Director, Product Management, Oracle

Oracle Database 23ai JSON Relational Duality revolutionizes AppDev by unifying the benefits of relational and document data models within a single database.

Read the complete post

Get started

Download Oracle Database 23ai

Try JSON Relational Duality today in Database 23ai or Database23ai Free

Contact sales

Interested in learning more about Oracle Cloud Infrastructure? Let one of our experts help.

Try Oracle Cloud Free Tier

Build, test, and deploy applications on Oracle Cloud Infrastructure Platform.