Developed in the 70s, SQL and the relational model became the standard way to store data. But with the rise of NoSQL databases, many developers want to store JSON documents in the database and are keen to take advantage of the schema flexibility it brings. To support this, Oracle Database has a wealth of functionality to help you use JSON.

But is this really the best way to store your data?

This session is a showdown between relational and JSON approaches in Oracle Database. It highlights the strengths and weaknesses of each method, giving you guidelines to help you choose the best storage for your needs.

This session is a battle between two data models. Pick your sides and watch the fight!

This talk is for developers & DBAs who design and create database tables.

Highlights include:

01:00 - Introducing the problem: creating an online class scheduling app
03:00 - What is JSON
04:00 - Benefit of storing JSON: simpler data access code
05:00 - Problems of storing JSON
07:00 - JSON is a hierarchical data model - like IMS
10:15 - Using relational tables to store the data
12:45 - Flex columns in the relational model
14:25 - Fight!
15:45 - A hybrid model using Oracle's Converged Database
17:00 - Generating JSON from relational tables using SQL
20:30 - Extracting values from JSON documents using SQL
23:00 - Demo using always free Autonomous JSON Database
39:45 - Free tier vs AJD vs ATP services
41:40 - Recap
44:00 - Q&A