JSON Relational Duality: Data Modeling with Hackolade

JSON Relational Duality is a marquee feature of Oracle Database 23ai. It combines the benefits of JSON (all information in one document, simple access without joins, schema-flexibility) with the benefits of the relational model (no data duplication, referential integrity, use-case flexibility). One major aspect of JSON Relational Duality is its ability for proper data modeling. In this session we explain the concepts of JSON Relational Duality and why it is capable of solving complex and changing requirements, often found in enterprises where data is long lives and applications change over time.
We also showcase how the Hackolade Studio tool is best used to not only visually plan application collections but also generate JSON Relational Duality views with GUIs.