Key Features of Autonomous Database

This section describes key features of Autonomous Database, an affordable, feature-rich service in the cloud.

Key Features

  • Managed: Oracle simplifies end-to-end management of the database:

    • Provisioning new databases

    • Growing or shrinking storage and compute resources

    • Patching and upgrades

    • Backup and recovery

  • Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

    • Size the Autonomous Database to the exact compute and storage required

    • Scale the Autonomous Database on demand: Independently scale compute or storage

    • Shut off idle compute to save money

  • Auto scaling: Allows your database to use more CPU and IO resources or to use additional storage automatically when the workload or storage demand requires additional resources:

    • Specify the number of OCPUs for Autonomous Database workloads.

    • OCPU auto scaling allows the database to use up to three times more CPU and IO resources, depending on workload requirements. OCPU auto scaling is enabled by default when you create an Autonomous Database.

    • Storage auto scaling allows the database to expand use up to three times the reserved base storage, depending on storage requirements. Storage auto scaling is disabled by default when you create an Autonomous Database.

    • You can manage scaling from the Oracle Cloud Infrastructure Console to enable or disable OCPU auto scaling or Storage auto scaling.
  • Autonomous Database supports:

    • Existing applications, running in the cloud or on-premise

    • Connectivity via SQL*Net, JDBC, ODBC

    • Third-party data-integration tools

    • Oracle cloud services: Oracle Analytics Cloud, Oracle GoldenGate Marketplace, Oracle Integration Cloud Service, and others

  • High-performance queries and concurrent workloads: Optimized query performance with preconfigured resource profiles for different types of users.

  • Oracle SQL: Autonomous Database is compatible with existing applications that support Oracle Database.

  • Built-in web-based data analysis tool: Web-based notebook tool for designing and sharing SQL based data-driven, interactive documents.

  • Database migration utility: Easily migrate from MySQL, Amazon AWS Redshift, PostgreSQL, SQL Server, and other databases.

Simple Cloud-based Data Loading

Autonomous Database provides:
  • Fast, scalable data-loading from Oracle Cloud Infrastructure Object Storage, Azure Blob Storage, Amazon S3, Amazon S3-Compatible, GitHub Repository, or on-premise data sources.

Oracle Database Actions

Database Actions is a web-based interface that uses Oracle REST Data Services to provide development, data tools, and administration and monitoring features for Autonomous Database, including the following:

  • Development Tools

    • SQL Navigator and Worksheet: view objects and enter and run SQL and PL/SQL statements, and create database objects

    • Data Modeler: provides an integrated version of Oracle SQL Developer Data Modeler with basic reporting features. You can create diagrams from existing schemas, retrieve data dictionary information, generate DDL statements, and export diagrams

    • Develop and Secure RESTful Web Services

    • Manage JSON Collections

  • Data Studio

    • Data Load: select data from your local computer, from tables in other databases, or from cloud storage and then add that data to new or existing tables or views

    • Catalog: displays information about entities and dependencies in your data

    • Data Insights: displays information about patterns and anomalies in your data

    • Data Transforms: transform data for analysis and other applications

    • Dana Analysis: analyze your data

  • Administration and Monitoring

    • Manage users

    • Monitor databases

Autonomous Data Guard

Autonomous Database provides Autonomous Data Guard to enable a standby (peer) database to provide data protection and disaster recovery for your Autonomous Database instance.When you enable Autonomous Data Guard the system creates a standby database that continuously gets updated with the changes from the primary database. You can enable Autonomous Data Guard with a standby in the current region, a local standby, or with a standby in a different region, a cross-region standby. You can also enable Autonomous Data Guard with both a local standby and a cross-region standby.

SQL Developer Autonomous Database Support

Using Autonomous Database with SQL Developer you can do the following:

  • Connect to Autonomous Database

  • Create tables, indexes, and materialized views in Autonomous Database

  • Load data into Autonomous Database

  • Copy tables to Autonomous Database

  • Transfer a schema to Autonomous Database

Business Intelligence Tools Support

Autonomous Database is compatible with a number of business intelligence and data visualization tools from Oracle and from trusted third parties.

  • Oracle Analytics Cloud

  • Oracle Analytics Desktop

  • Third-party Business Intelligence tools