D1&B - Exploring Oracle Database 23c: JSON Duality Views and Operational Property Graphs

Take a deep dive into two key features of Oracle Database 23c.
First, we’ll look at JSON Relational Duality Views, which help to converge the benefits of both document and relational worlds. Developers now get the flexibility and data access benefits of the JSON document model, plus the storage efficiency and power of the relational model. We’ll use a feature of Oracle REST Data Service (ORDS) called AutoREST to enable REST calls on our tables that can quickly insert, update, and delete.

Secondly, we’ll get into Operational Property Graphs, which help you uncover the hidden connections within your data. We will use the example of detecting fraud within banking information. We’ll create a graph from two tables with banking data, then run graph pattern queries in SQL on it. You will find circular payment chains, multi-hop paths between accounts, and more. The GRAPH_TABLE function and MATCH clause of the new SQL:2023 standard enable you to write simple SQL queries to follow such connections in data.
After this session, you'll be ready to supercharge your application development and data analysis with Oracle Database 23c.