1.5 Oracle Database: Converged, Multitenant, Backed By SQL
If you use JSON-relational duality views then your application can take advantage of the benefits of a converged database.
These benefits include the following:
-
Native (binary) support of JavaScript Object Notation (JSON) data. This includes updating, indexing, declarative querying, generating, and views
-
Advanced security, including auditing and fine-grained access control using roles and grants
-
Fully ACID (atomicity, consistency, isolation, durability) transactions across multiple documents and tables
-
Standardized, straightforward JOINs with all sorts of data (including JSON)
-
State-of-the-art analytics, machine-learning, and reporting
Oracle Database is a converged, multimodel database. It acts like different kinds of databases rolled into one, providing synergy across very different features, supporting different workloads and data models.
Oracle Database is polyglot. You can seamlessly join and manipulate together data of all kinds, including JSON data, using multiple application languages.
Oracle Database is multitenant. You can have both consolidation and isolation, for different teams and purposes. You get a single, common approach for security, upgrades, patching, and maintenance. (If you use an Autonomous Oracle Database, such as Autonomous JSON Database, then Oracle takes care of all such database administration responsibilities. An autonomous database is self-managing, self-securing, self-repairing, and serverless. And there's Always Free access to an autonomous database.)
The standard, declarative language SQL underlies processing on Oracle Database. You might develop your application using a popular application-development language together with an API such as Oracle Database API for MongoDB or Oracle REST Data Services (ORDS), but the power of SQL is behind it all, and that lets your app play well with everything else on Oracle Database.
Parent topic: Overview of JSON-Relational Duality Views