About Autonomous Database Workload Types

Autonomous Database supports different workload types, including: Data Warehouse, Transaction Processing, JSON Database, and APEX Service. Each of these workload types provides performance improvements and additional features that support operations for the specified workload.

Topics

About Autonomous Data Warehouse

Autonomous Data Warehouse is designed as a "load and go" service: you start the service, define tables, load data, and then run queries.

Autonomous Data Warehouse is designed to support all standard SQL and business intelligence (BI) tools, and provides all of the performance of the market-leading Oracle Database in an environment that is tuned and optimized for data warehouse workloads.

To get started you create an Autonomous Database with the workload type Data Warehouse and specify the number of OCPUs and the storage capacity in TB's for the Autonomous Data Warehouse.

You can use Autonomous Data Warehouse with Oracle Analytics Cloud or Oracle Analytics Desktop to easily create visualizations and projects that reveal trends in your company’s data and help you answer questions and discover important insights about your business.

The following figure shows the Autonomous Data Warehouse architecture.

About Autonomous Transaction Processing

Autonomous Transaction Processing is designed to support all standard business applications and deliver scalable query performance.

Autonomous Transaction Processing provides all of the performance of the market-leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, IoT, and JSON document store.

To get started you create an Autonomous Database with the workload type Transaction Processing and specify the number of OCPUs and the storage capacity in TB's for the database.

You can use Autonomous Transaction Processing with Oracle Analytics Cloud or Oracle Analytics Desktop to easily create visualizations and projects that reveal trends in your company’s operational data and help you answer questions and discover important insights about your business.

The following figure shows the Autonomous Transaction Processing architecture.

About Autonomous JSON Database

Oracle Autonomous JSON Database is Oracle Autonomous Transaction Processing, but designed for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents. You can promote an Autonomous JSON Database service to an Autonomous Transaction Processing service.

Oracle Autonomous JSON Database provides all of the same features as Autonomous Transaction Processing, with this important limitation: you can store only up to 20 GB of data other than JSON document collections. There is no storage limit for JSON collections.

Development of NoSQL-style, document-centric applications is particularly flexible because the applications use schemaless 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.

With Oracle Autonomous JSON Database your JSON document-centric applications typically use Simple 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.

With Oracle Autonomous JSON Database, a SODA collection can 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 to Autonomous 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 of Oracle Autonomous Database you use.

JSON data is stored natively in the database. In a SODA collection on an Autonomous Database JSON data is stored in Oracle's native binary format, OSON.

About Oracle APEX Application Development

Oracle APEX Application Development (APEX Service) is a low cost, Oracle Cloud service offering convenient access to the Oracle Application Express platform for rapidly building and deploying low-code applications. APEX Service is designed to support all standard business applications and deliver scalable query performance.

See Oracle APEX Application Development for more information.