Oracle as a
Document Store


Oracle Database 12c fully supports schemaless application development using the JSON data model. This allows for a hybrid development approach: all of the schema flexibility and speedy application development of NoSQL document stores, combined with all of the enterprise-ready features in Oracle Database 12c.

Architecture Overview

Oracle Database 12c stores, manages, and indexes JSON documents. Application developers can access these JSON documents via document-store API's. Oracle Database 12c provides sophisticated SQL querying and reporting over JSON documents, so application developers can easily join JSON documents together as well as integrate JSON and relational data.

Simple Oracle Document Access (SODA)

Oracle Database provides a family of SODA API's designed to support schemaless application development. Using these API's, developers can work with JSON documents managed by the Oracle Database without needing to use SQL. There are two implementations of SODA: (1) SODA for Java, which consists of a set of simple classes that represent a database, a collection, and a document, and (2) SODA for REST, which can be invoked from any programming or scripting language capable of making HTTP calls.

SQL Access to JSON Documents

Oracle database provides a comprehensive implemention of SQL, for both analytics and batch processing. JSON held in the Oracle Database can be directly accessed via SQL, without the need to convert it into an intermediary form. JSON collections can be joined to other JSON collections or to relational tables using standard SQL queries.

ACID Transactions over JSON Documents

JSON documents held in the Oracle Database can leverage ACID transactions between documents. This provides consistent results when documents are accessed by long running processes. Users updating JSON documents do not block users reading the same or related documents.

Fully Integrated into Oracle's Database Platform

Users of Oracle Database 12c no longer need to choose between ease of development and enterprise data management features. By using the Oracle Database as a Document Store with JSON, Oracle delivers a complete platform for document store applications, including but not limited to: secure data processing through encryption, access control, and auditing; horizontal scalability with Real Application Clusters; consolidation with Oracle Multitenant; and high availability functionality that means JSON stored within the Oracle Database benefits from unparalleled levels of uptime.

Related Technologies