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
Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Header container

March 10

18:00 UTC   Start Times Around the World

JSON and the moon landing: what to keep in mind when modeling JSON data
JSON has gained a lot of popularity as a backend data model in recent years. But since JSON is a hierarchical data model certain use cases are hard to map to JSON. This session focusses on JSON design and modeling questions. Learn about the differences of the relational and JSON data models, how to avoid mistakes when modeling JSON and how to combine JSON with relational features.

Video Highlights:

3:50 - LiveSQL location
4:25 - First example
6:00 - Entity Relationship Model
8:20 - Create tables
12:05 - Insert data
13:30 - Insert fails
15:00 - Update
15:15 - Schema changes
17:55 - Hierachical data models
18:15 - IBM IMS
21:30 - Pure JSON Data model
22:50 - LiveSQL example
25:30 - Update multiple JSON documents
26:15 - Update course name function
28:30 - Find all teachers for a given student
30:50 - Schema flexability
32:00 - JSON model summary
33:30 - The relational data model is born (Larry Elison creates the Oracle Database)
34:20 - JSON combined with Relational model
36:45 - LiveSQL example
39:00 - Blob vs Clob question
41:05 - Use JSON_MergePatch to update object
42:35 - Query student with no courses
43:00 - Query teachers for a student
45:10 - Use Query to generate new JSON object
46:05 - Constraints
47:00 - Virtual column
49:45 - Validate course IDs in an array
51:05 - Evolution of data management
52:10 - Conclusion
53:35 - SODA
54:10 - Questions
59:55 - Link to LiveSQL presentation - https://livesql.oracle.com/apex/livesql/file/content_JNHZUR2NBJPE5K3MLVTUHS2N0.h tml

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

Experts

Your Experts
Beda Hammerschmidt
Beda Hammerschmidt, Consulting Member of Technical Staff    
Beda is the brains and fingers behind XML and JSON support in Oracle Database.
Blaine Carter
Blaine Carter, Developer Advocate for Open Source    
Blaine started programming in 1995. For most of his career, he used Oracle software to build applications, including Oracle Forms and Oracle Reports, Java, and a whole lot of SQL and PL/SQL. Now he applies his exploratory eye and tinkering inclinations to the intersection of open source software and Oracle Database.