Oracle unveiled the beta of Oracle Database 23c. Thanks to the introduction of JSON Relational Duality, developers no longer have to choose between JSON and relational database formats.
The database model of an application is key to its performance and development process. Relational database formats like MySQL are the most popular by far, though non-relational formats like JSON have been gaining traction as of late.
The perfect database format doesn’t exist. The best option varies per application. Both JSON and relational have advantages and disadvantages. Choosing the right database format is key to professional application development. Although it’s technically possible to convert data to another format during or after the development process, any conversion comes at the expense of performance.
Thanks to a new feature in the beta of Oracle Database 23c, developers no longer have to choose. The introduction of JSON Relational Duality allows users to simultaneously leverage the benefits of relational databases and JSON.
JSON Relational Duality
“JSON Relational Duality addresses an age-old problem”, said Carl Olofson, analyst at IDC. “The feature allows developers to pick the best storage and access formats needed for each use case without having to worry about data structure, data mapping, data consistency, or performance tuning.”
“Oracle Database 23c definitively ends the long running ‘relational vs. document’ debate”, Wikibon analyst Marc Staimer added. “The feature delivers the best of both worlds. Data is stored as rows in relational format, while data can be accessed as JSON formats.”
Oracle Database 23c
JSON Relational Duality is one of the hundreds of updates included in Oracle Database 23c. The release focuses on development. Oracle codenamed the version ‘App Simple’, a nod to the fact that many of the new features simplify application development.
In addition to JSON Relational Duality, Oracle Database 23c introduces support for microservices, real-time machine learning and new data types. The release is generally available to beta registrees.