Skip to Main Content

JSON in Oracle Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

September 14, 2021

17:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Retire your tables - it's all JSON now (is it?) with Chris Saxon
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

Your Experts

    Beda Hammerschmidt

    Beda Hammerschmidt   

    Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
    Chris Saxon

    Chris Saxon   

    Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.