Best Practices in Designing JSON Document Model in Autonomous JSON Database

Best Practices in Designing JSON Document Model in Autonomous JSON Database

This webinar compares JSON with the relational model tables. It explains conceptual differences, benefits and limitations of each data model. With Oracle as a relational database with native support for JSON, it is possible to combine the benefits of both models. This is shown in a demo using the Autonomous Database.

0:40 Agenda
3:00 Sample Application to be built
4:05 Java classes for business objects
4:40 Tables to store business object
6:50 JSON collection instead of tables
7:25 Insertion into tables
8:05 Insertion into JSON collection
8:30 Linking versus embedding
9:25 Querying tables
10:00 Querying collection
10:35 Application change: new field
11:35 Application change: cardinality
13:30 Only JSON in the future?
13:40 Data repetition with embedding
16:10 Limits of embedding
21:00 JSON or relational?
21:10 Combine benefits of JSON and relational with Oracle
23:25 JSON Workshop and SQL Developer Web
23:55 create a new JSON collection
24:10 insert a new JSON document
25:05 query JSON data using QBEs
27:40 SQL access to JSON data
29:50 create a unique index
33:50 REST access to JSON collections
38:10 Check constraint over JSON data
40:25 Querying JSON data with SQL
41:25 unnest JSON Arrays with JSON_Table
42:55 Pivot JSON data
48:10 Multi-value index
50:20 cross collection referential integrity
52:40 JSON generation from relational data
54:25 Performance of Autonomous JSON database
55:50 Updates using JSON_Transform

#JSON #AutonomousDatabase