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. SODA is supported across a number of platforms and languages including REST, Java, Node.js, Python, PL/SQL, and OCI.

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 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.