Developer's nirvana with Autonomous Database: JSON-Relational Duality in Oracle Database 23ai

Join the Oracle Autonomous Database PM team in this Learning Lounge session, where you will learn about an exciting new capability in Oracle Database 23ai called JSON-Relational Duality, which combines the simplicity of the JSON document model with the power of the relational model in JSON Relational Duality views. You will be able to ask any questions in the open Q&A. Register for our bi-weekly sessions and watch recordings at https://oracle.com/goto/adb-learning-lounge Slides for this session at: https://oracle.com/a/otn/docs/adbll/adbll_developers_nirvana_JSON_Relational_duality.pdf === Links about Autonomous Database === Our new Get Started Page is the right place to start: https://www.oracle.com/autonomous-database/get-started/ Join our Group on LinkedIn: https://www.linkedin.com/groups/13819289/ Follow us on BlueSky: https://bsky.app/profile/autonomousdb.bsky.social Follow us on "X": https://twitter.com/AutonomousDW Ask questions in: - Stack Overflow: https://stackoverflow.com/questions/tagged/oracle-autonomous-db - Join our External Slack workspace and search for the 'oracle-autonomous-database' channel: https://join.slack.com/t/oracledevs/shared_invite/zt-327lxqzeo-7cfyrWzWAY7curI7MCVF1w == Outline == Overview of the JSON-Relational capability and features JSON-Relational Duality View restrictions and limitations New Flex columns Outliers and minFrequency special calculations JSON Collections Views and the MongoDB API LIVE Demo == Video highlights == 00:31 Agenda 01:40 Important links on Autonomous Database 02:45 New features of JSON (Duality) for DBAs and Developers 03:34 DB-Engines Points Change from Jan 2024 to Nov 2024 06:20 What's new and enhanced in Oracle Database 23.6 and 23.7 for JSON? 08:55 New JSON features 10:46 Live Demo: Oracle SQL Developer connected to Autonomous Database 13:56 Live Demo: MongoDB Compass connected to Autonomous Database 14:53 JSON Data Type and JSON Replication 15:13 Live Demo: Oracle SQL Developer connected to Autonomous Database 16:47 JSON Search Index Path Subsetting 17:06 JSON Type Modifier Enhancements: Limit Clause 18:21 Hidden and Generated Fields in JSON-Relational Duality Views 19:32 GoldenGate Replication of JSON-Relational Duality Views 20:32 Duality View support in SQL Developer Extension for VS Code 20:52 Mongo-to-Duality Migrator: flex columns, outliers and minFrequency 21:35 Live Demo: Oracle SQL Developer connected to Autonomous Database 24:55 Flex Columns and JSON-Relational Duality Views 26:26 Live Demo: Oracle SQL Developer connected to Autonomous Database 26:36 Outliers and minFrequency 27:08 Live Demo: Oracle SQL Developer connected to Autonomous Database 30:49 Live Demo: Mongo-to-Duality Migrator 36:09 Oracle JSON Autonomous Database 36:52 Autonomous JSON Database benchmarks 38:54 JSON Collections and the MongoDB API 39:45 Live Demo: JSON Collections 42:26 JSON Collections Views and the MongoDB API 43:36 Oracle API for MongoDB 43:55 MongoDB API Aggregation Pipeline in Oracle Database 23ai 44:33 Live Demo: MongoSH 47:10 Where to get more information 47:46 Q&A 49:10 Important links on Autonomous Database 55:41 Final Thoughts