Oracle Database 18c 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 18c.
Oracle Database 18c stores, manages, and indexes JSON documents. Application developers can access these JSON documents via document-store API's. Oracle Database 18c 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.
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.
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.
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.
Users of Oracle Database 18c 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.