By Laura Ramsey-Oracle on Aug 14, 2014
Yes, We did. Here's why:
JSON data has often been stored in NoSQL databases such as Oracle NoSQL Database and Oracle Berkeley DB. These allow for storage and retrieval of data that is not based on any schema, but they do not offer the rigorous consistency models of relational databases. You can get around this by using a relational database in parallel with a NoSQL database, but applications using JSON data stored in the NoSQL database must then ensure data integrity themselves.
So for these reasons (and maybe a few more) Oracle Database 12c supports JSON natively with relational database features, including transactions, indexing, declarative querying, and views. Oracle Database queries are declarative, so you can join JSON data with relational data. And you can project JSON data relationally, making it available for relational processes and tools. You can also query, from within the database, JSON data that is stored outside the database, in an external table.
And, it's good to know you can access JSON data stored in the database the same way you access other database data, including using OCI, .NET, and JDBC.
Get more information about JSON support in Oracle Database 12c. You can start with the XML DB Developer's Guide (I DID!).
Ciao for Now!