filmov
tv
Using Oracle Database as a MongoDB-compatible JSON document store

Показать описание
00:00 - 2:30 Introduction
02:30 - 06:05 Specialized Database or Converged Database?
06:06 - 08:55 Why store JSON in a database?
08:56 - 10:06 Automomous Database
10:07 - 13:14 SQL/JSON, JSON and Relational data models
13:15 - 17:53 Binary JSON Format, Performance, extended type system
17:54 - 23:24 Demo: schema-flexible JSON data in tables and SQL
23:25 - 32:00 JSON Collections, MongoDB Compatibility
32:01 - 34:35 Demo: MongoDB API, MongoDB Compass connecting to Oracle Database
34:36 - 36:06 Accessing external JSON data using MongoDB $external command
36:07 - 39:35 MongoDB and Oracle SQL working together
39:36 - 41:30 Reporting and Charts on JSON data
41:31 - end JSON Relational Duality: Make relational data accessible as JSON Documents
As multi-model databases like Oracle, Postgres, and MySQL gain traction for document storage, they're starting to outpace dedicated NoSQL solutions like MongoDB in both performance and versatility. Today, traditionally relational databases offer robust support for binary JSON encodings and SQL extensions for JSON and provide scalable, low-latency access to JSON documents. This session will explore how Oracle Database can seamlessly handle NoSQL workloads through its advanced JSON document storage capabilities. Specifically, we'll cover: * The trade-offs between document storage and the traditional relational model * Efficient JSON storage with OSON, Oracle's innovative binary encoding * Extensions to ISO standard SQL for JSON * Adoption of the MongoDB wire protocol, enabling MongoDB applications to run directly on the Oracle Database * A live demonstration of SQL/JSON, native collections, and more... The session will show how we combine the best of SQL and NoSQL in one database, providing our users with a seamless experience.
02:30 - 06:05 Specialized Database or Converged Database?
06:06 - 08:55 Why store JSON in a database?
08:56 - 10:06 Automomous Database
10:07 - 13:14 SQL/JSON, JSON and Relational data models
13:15 - 17:53 Binary JSON Format, Performance, extended type system
17:54 - 23:24 Demo: schema-flexible JSON data in tables and SQL
23:25 - 32:00 JSON Collections, MongoDB Compatibility
32:01 - 34:35 Demo: MongoDB API, MongoDB Compass connecting to Oracle Database
34:36 - 36:06 Accessing external JSON data using MongoDB $external command
36:07 - 39:35 MongoDB and Oracle SQL working together
39:36 - 41:30 Reporting and Charts on JSON data
41:31 - end JSON Relational Duality: Make relational data accessible as JSON Documents
As multi-model databases like Oracle, Postgres, and MySQL gain traction for document storage, they're starting to outpace dedicated NoSQL solutions like MongoDB in both performance and versatility. Today, traditionally relational databases offer robust support for binary JSON encodings and SQL extensions for JSON and provide scalable, low-latency access to JSON documents. This session will explore how Oracle Database can seamlessly handle NoSQL workloads through its advanced JSON document storage capabilities. Specifically, we'll cover: * The trade-offs between document storage and the traditional relational model * Efficient JSON storage with OSON, Oracle's innovative binary encoding * Extensions to ISO standard SQL for JSON * Adoption of the MongoDB wire protocol, enabling MongoDB applications to run directly on the Oracle Database * A live demonstration of SQL/JSON, native collections, and more... The session will show how we combine the best of SQL and NoSQL in one database, providing our users with a seamless experience.