There's a lot to talk about when it comes to JSON support in Oracle Database 12c. A big part of that story is Oracle REST Data Services. But there's more to it. Oracle 12c has a key set of API's:  Simple Oracle Document Access (SODA).   And it's important.

 

Here's the deal:

 

Oracle Database 12.1.0.2 supports storing, indexing and querying JSON documents in the database. But the picture is completed by document-centric API's for accessing JSON documents. 

 

http://www.oracle.com/ocom/groups/public/@otn/documents/digitalasset/2529779.png

 

 

 

Introducing Simple Oracle Document Access (SODA)

SODA, the set of APIs specifically designed to support schemaless application development.                                             

There are 2 SODA implementations:

 

      
  1. SODA for Java-- a programmatic document-store interface for Java Developers that uses JDBC to communicate with the database. SODA for Java consists of a set of simple classes that represent a database, a document collection and a document. Methods on these classes provide all the functionality required to manage and query collections and work with JSON documents stored in an Oracle Database.

  2.   
  3. SODA for REST-- a REST-based document store interface implemented as a Java servlet and delivered as part of Oracle REST Data Services (ORDS) 3.0. Applications based on SODA for REST use HTTP to communicate with the Java Servlet. The SODA for REST Servlet can also be run under the database's native HTTP Server. HTTP verbs such as PUT, POST, GET, and DELETE map to operations over JSON documents. Because SODA for REST can be invoked from any programming or scripting language that is capable of making HTTP calls, it can be used with all modern development environments and frameworks.

 

Want to see it in action?

Check out the oracle/json-in-db repository on Github. You'll find downloadable and installable demonstrations for the JSON capabilities of Oracle Database 12.1.0.2.0 and later.                                           

 

And get more details about Oracle as a Document Store from OTN.

 

Join the ORDS discussion space on the OTN Community Platform here.

 

 

 

Ciao for Now!
LKR