- Elevator Pitch -

JSON Relational Duality Views in 23c is the great developer enabler for working with Oracle Database relational data in either a document manner or relational manner, but storing the data only once.

Throughout the versions there have been other such "Dualities": Object views, XML type views, Analytic views and Property Graphs. This session gives a quick overview of these multiple ways of working with your relational data in a non-relational fashion.

- Description -

A marquee feature of Oracle Database version 23c is the JSON Relational Duality view - the great developer enabler that allows working with data in either document manner or relational manner, even though the data is not replicated, but only stored one place as relational tables.

But it is not the only Duality that is built into Oracle. Version 23c also introduces native Property Graph capabilities with the SQL/PGQ extension to SQL, allowing you to query relational data as if they were graphs. And in earlier versions the database introduced Analytic Views to let you query relational data as if they were a dimensional cube, XML Type views to work with relational data as if they were XML, and Object views to let you treat relational data in an object oriented manner.

These Dualities allow you to use all the time-proven features and security of the relational Oracle Database and at the same time utilize the powers of JSON, Graphs, Cubes, XML and OO - all without replicating data to other storage types.

This session will show you a quick overview of the possibilities these dualities bring to your development teams.

- Notes -

This will be a quick overview of the different "dualities" that exist in Oracle for working in non-relational ways with data stored as relational data. The most prominent being the JSON Relational Duality view in version 23c to work on the same relational tables either as JSON or relationally. But the version 23c built-in Property Graph is another duality - viewing and querying relational data as a graph. And the version 12.2 feature Analytic Views is a third duality - viewing relational data as a dimensional cube for slicing and dicing data. Plus the even older features of XML Type views and Object views.

The idea of this session is to provide a quick overview of the capabilities, not to dive deep into syntax.

Presented at:
- ODTUG Kscope 2024