filmov
tv
SQL through the Oracle Database API for MongoDB - better together

Показать описание
Do you know about the MongoDB API and SQL? But do you consider this as silo language, an either-or? Think twice and embark on a technical journey with us to explore the synergy between MongoDB API and SQL with the Oracle Database API for MongoDB.
In this one-hour presentation, we'll delve into the intricacies of integrating Oracle's robust SQL capabilities in the MongoDB API with the recent addition of the $sql operator. Join us as we dissect this convergence's technical capabilities and practical benefits for developers.
Timeline
00:00 - 05:30 Introduction and recap of JSON support in Oracle Database
05:31 - 08:39 why run SQL commands thru a document store API?
08:40 - 12:30 $sql command : the basics
12:31 - 16:58 bind values in $sql
16:59 - 25:49 $sql integration with MongoDB (aggregation pipeline)
25:50 - 29:38 common Use case
29:39 - 47:55 Demo (access relational data, index creation, JSON processing with SQL, etc)
47:56 - 50:29 Availability of MongoDB API and $sql
50:30 - END Summary
In this one-hour presentation, we'll delve into the intricacies of integrating Oracle's robust SQL capabilities in the MongoDB API with the recent addition of the $sql operator. Join us as we dissect this convergence's technical capabilities and practical benefits for developers.
Timeline
00:00 - 05:30 Introduction and recap of JSON support in Oracle Database
05:31 - 08:39 why run SQL commands thru a document store API?
08:40 - 12:30 $sql command : the basics
12:31 - 16:58 bind values in $sql
16:59 - 25:49 $sql integration with MongoDB (aggregation pipeline)
25:50 - 29:38 common Use case
29:39 - 47:55 Demo (access relational data, index creation, JSON processing with SQL, etc)
47:56 - 50:29 Availability of MongoDB API and $sql
50:30 - END Summary