Oracle Autonomous AI JSON Database isOracle Autonomous AI Transaction Processing, but designed for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents. You can promote anAutonomous AI JSON Database service to anAutonomous AI Transaction Processing service.
SeeAbout Autonomous Transaction Processing for a full description of theAutonomous AI Transaction Processing service.Autonomous AI JSON Database provides all of the same features, with thisimportant limitation: you can store only up to 20 GB of data other than JSON document collections.Foot 1 There is no storage limit for JSON collections.
Development of NoSQL-style, document-centric applications is particularly flexible because the applications useschemaless data. This lets you quickly react to changing application requirements. There's no need to normalize the data into relational tables, and no impediment to changing data structure or organization at any time, in any way. A JSON document has internal structure, but no relation is imposed on separate JSON documents.
WithOracle Autonomous AI JSON Database your JSON document-centric applications typically useSimple Oracle Document Access (SODA), which is a set of NoSQL-style APIs for various application-development languages and for the representational state transfer (REST) architectural style. You can use any SODA API to access any SODA collection.
SODA document collections are backed by ordinary database tables and views. To use other kinds of data, subject to the 20 GB limit, you typically need some knowledge of Structured Query Language (SQL) and how that data is stored in the database.
WithOracle Autonomous AI JSON Database, a SODA collectioncan only contain JSON data. For example, you cannot have a collection of image documents or a collection that contains both JSON documents and image documents. This is a limitation relative toAutonomous AI Transaction Processing, where you can define such heterogeneous collections.
No matter what kind of data your applications use, whether JSON or something else, you can take advantage of all Oracle Database features. This is true regardless of the kind ofOracle Autonomous Database you use.
JSON data is stored natively in the database. In a SODA collection on anAutonomous AI Database JSON data is stored in Oracle's native binary format, OSON.
Footnote Legend
Footnote 1: You can subscribe to information event AJDNonJsonStorageExceeded, to be informed when the 20 GB limit is exceeded. SeeAbout Information Events on Autonomous Database inUsing Oracle Autonomous AI Database Serverless.