Oracle Developers | JSON Collections in Oracle Database 23ai @oracledevs | Uploaded August 2024 | Updated October 2024, 21 hours ago.
Oracle Database release 23.5 is out and it has a brand-new JSON feature: JSON collection tables!
These are tables, which not only store JSON data but also simplify key management. They're fully interoperable with SQL but also with document store APIs like the MongoDB API.
JSON collection tables drastically simplify working with JSON documents in multiple workloads. They're also compatible with JSON relational duality views, enabling users to store JSON without any schema (for example, while an application is being developed) and later move to JSON relational duality views without having to change queries or other database operations.
As usual, this session will be packed with concepts as well as fun demos!

Overview::
00:00 - 03:19 Intro and overview
03:20 - 06:56 Why do developers like to work with JSON documents?
06:57 - 11:19 What are JSON document collections?
11:20 - 16:00 JSON collection tables in Oracle Database 23ai
16:01 - 29:21 Demo: Collection Tables, MongoDB API and SQL interoperability
29:22 - 31:17 SODA collections can be JSON collection Tables
31:18 - 38:20 Introduction to JSON Relational Duality
38:21 - 46:00 Demo: Migrating documents to JSON Relational Duality
46:01 - 51:34 Demo: Oracle Big Data Adapter for JSON
51:35 - 54:40 Schema flexibility in JSON Relational Duality
54:41 - 1:01:26 Recap