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.
About Oracle Autonomous Data Warehouse Autonomous Database is designed as a "load and go" service: you start the service, define tables, load data, and then run queries.
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.
About Oracle APEX Application Development Oracle APEX Application Development (APEX Service) is a low cost, Oracle Cloud service offering convenient access to the Oracle APEX platform for rapidly building and deploying low-code applications. APEX Service is designed to support all standard business applications and deliver scalable query performance.
Autonomous Database is
designed as a "load and go" service: you start the service, define tables, load data, and
then run queries.
Autonomous Database 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 workload type
Data Warehouse and specify the number of ECPUs (OCPUs if your database uses
OCPUs) and the storage capacity in TB's for the Autonomous Database.
You
can use Autonomous Database 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 Database architecture with
related components for analytics and data warehousing.
Autonomous Database is
designed to support all standard business applications and deliver scalable query
performance.
Autonomous Database 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 ECPUs (OCPUs if your database uses
OCPUs) and the storage capacity in TB's for the database.
You can use Autonomous Database 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 Database architecture with related components for transaction
processing and mixed workloads.
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.
Oracle APEX Application
Development (APEX Service) is a low cost, Oracle Cloud service offering convenient access to the Oracle APEX platform for rapidly building and deploying low-code applications. APEX Service is designed to support all standard business applications and deliver scalable
query performance.