Best Practices in Designing JSON Document Model in Autonomous JSON Database
Slide Deck: http://bit.ly/ajd-slidedeck-210330
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
