1 Get Started Using Autonomous JSON Database

Oracle Autonomous JSON Database simplifies the task of developing applications that use JavaScript Object Notation (JSON) data. The following features, in particular, support the development of high-performing, high-security applications:

  • Automatic database administration. Routine database administration tasks such as patching and taking backups are performed automatically, so you can concentrate on developing your application.

  • Automatic performance tuning. You spend less time defining and tuning your database. See Autonomous Database – Oracle Database Features.

  • Preconfigured high performance. When you connect to the database with an Oracle client using connection pools you take advantage of high performance features configured on the database side of your connection. See Code for High Performance.

  • Predefined, workload-specific database services. Client applications can connect to the database using a connection service that best matches the type of database operations they need. (For most applications that use JSON documents you use the typical connection service for transaction processing, tp.) See Database Service Names for Autonomous Transaction Processing and Autonomous JSON Database in Using Oracle Autonomous Database Serverless.

  • Long-Term Backups. You can create a long-term backup as a one-time backup or as scheduled long-term backup. You can create a new database by cloning from a long-term backup. You cannot use a long-term backup to recover or restore the same database where the long-term backup was created. See Long-Term Backups on Autonomous Database in Using Oracle Autonomous Database Serverless

Autonomous JSON Database is specialized for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents using Simple Oracle Document Access (SODA) APIs. You can also use Oracle Application Express (APEX) for low-code development of dashboards over your JSON data.

But just as for Autonomous Transaction Processing, JSON data stored in a JSON database is also fully accessible using Structured Query Language (SQL), for analytics and interfacing with relational tools. You can promote an Autonomous JSON Database anytime to an Autonomous Transaction Processing database, which lets you store more non-JSON data.