Oracle logo

Live Developer Lab

Live DevLab
July 8, 2021
9 a.m. PT | 12 p.m. ET

JSON and SODA with the Oracle Autonomous JSON Database

Schema-flexibility is a big reason why JSON makes a lot of sense for application development. In the initial phase especially, an application is quite dynamic, new fields are needed, interfaces get changed, etc. Maintaining a relational schema is hard if application changes often need a change in the underlying tables and existing data needs to be modified to fit into the new schema. JSON makes this much easier as new documents may look different than your old ones.

In this lab, you will explore:

  • How to start an Oracle Autonomous (JSON) Database
  • Fundamentals on the JSON data model and when to use it
  • How to store, query and process JSON document in collections using the SODA API
  • How to use SQL to query, generate and process JSON data
  • How to convert JSON data to the relational model (e.g., for analytics or reporting)
  • How to generate JSON data from relational sources (e.g., to serve a microservice)
  • How to update JSON data

Featured Speaker

Beda Hammerschmidt 

Beda Hammerschmidt

Beda is a software developer at Oracle Server Technologies with 15+ years of experience with JSON and XML. He also has experience coding JSON features in the Oracle Database. Beda is co-author of the SQL/JSON Standard (SQL 2016).