Autonomous Database Features

Download Autonomous Database free container image

Features topics

All workloads and data

Optimized for all workloads and data types

Get native support for all modern data types, workloads, and analytics built into a single service, giving developers a platform with fewer moving pieces and less complexity. Take advantage of an environment that supports applications or analytics at any scale or criticality without requiring time-consuming integration of multiple services or multiple specialty databases.

  • All modern data formats are supported: relational, graph, geospatial, JSON, text, and more. There’s no need to use numerous specialty databases for different data types.
  • All modern workloads are supported: OLTP, IoT, temporal, ledger/blockchain, streaming, analytic, and more. There’s no need for different specialty databases to support different workloads.
  • All modern analytics are supported: generative AI, advanced SQL, machine learning, graph analytics, text/search analytics, geospatial analytics, and more—all including data lake access. There’s no need to move data to specialty databases for analytics.
  • All modern development styles and paradigms are supported: containers, events, REST, low code, microservices, CI/CD, and more. Simplify operations with a single database to support all your development needs.
  • Create a single, secure environment quickly and safely with seamless and identical security across all data types and workloads.

Fast deployment

Create an Autonomous Database and tour the service (3:14)

Newcomers to Oracle Autonomous Database can get up and running quickly with a minimal learning curve. Preexisting expertise in Oracle Database isn’t required to be productive with Autonomous Database.

  • Deploy a new Autonomous Database of any size in minutes.
  • IT staff don’t have to spend time on routine operations since Autonomous Database automatically takes care of them.
  • Analysts can build better descriptive and predictive analytics using their preferred tools. Autonomous Database includes built-in AI, machine learning, graph, spatial, and text analytics and integrates with other databases, clouds, and data lakes to eliminate data silos.
  • Developers have flexibility to use their tech stack, architecture, and approach of choice to build applications. There’s no need to use multiple specialty databases, and DevOps teams will find those applications easier to manage and perform operational reporting.

Easy cloud migration

Autonomous Database is a fully automated Oracle Database. It offers the easiest way to move Oracle Database workloads to the cloud.

  • There’s no need to learn new database skills and languages because Autonomous Database fully supports PL/SQL.
  • Analytics and apps from on-premises Oracle Database deployment are supported.
  • Analyze your database estate to identify the best candidates to move today.
  • Migrate your database to Oracle Cloud Infrastructure (OCI) without downtime using Oracle Zero Downtime Migration. Accelerate your migration with guidance from cloud engineers on planning, architecting, prototyping, and managing cloud migrations through Oracle Cloud Lift Services.

Multicloud support

Get the data access, performance, and usability of a single cloud but in a multicloud environment.

  • Get single cloud ease of access to data using Autonomous Database, which securely integrates with Amazon S3, Azure Blob Storage, and Google Cloud Storage.
  • Get single cloud performance for your application with a low latency, high bandwidth link between Oracle Cloud Infrastructure and Azure.
  • Get a single cloud UI using the Azure console to configure and operate enterprise-grade Oracle Database services residing in OCI. There’s no need to learn how to use a new console with Oracle Database Service for Microsoft Azure.
  • Coming soon: Run your workloads where you choose with fully managed Oracle database services running on OCI but inside Azure. Experience the highest level of Oracle Database performance, scale, and availability, as well as feature and pricing parity.

Analytics

Machine learning and AI

Regardless of your skill set and knowledge of machine learning and AI, Autonomous Database provides a single platform where you can take analytics to the data using tools and languages that fit your needs.

  • Simplify how you get answers from your data through natural language questions. Select AI uses large language models (LLMs) to make Autonomous Database speak “human,” enabling users to ask questions without knowledge of the underlying data structure.
  • Build and evaluate high-performing machine learning models without knowing how to code. AutoML provides UI-based access to machine learning for nonexperts.
  • Visually explore and discover hidden connections in data using the Graph Studio feature.
  • Add location intelligence to your analytics with interactive maps through Oracle Spatial Studio, a self-service, UI-driven web application.
  • Choose your language—Python, R, or SQL—along with third-party packages to develop machine learning models and run them in-database at scale.

Self-service analytics

Line-of-business teams can deploy their own analytics environment using an end-to-end data analytics ecosystem without relying on IT staff.

  • Load and transform data from more than 100 application, database, and data lake sources without IT help using the Transforms UI of Oracle Autonomous Database Data Studio.
  • Create complex analytic calculations with ease using the built-in data analysis UI in Data Studio—and share those calculations with your favorite tools, including Oracle Analytics Cloud, Tableau, Excel, and more.
  • Share data securely, quickly, and openly within and outside your organization.
  • Understand your data sources and track changes using the catalog UI in Data Studio.
  • Easily access your data from spreadsheets with add-ins for Excel and Google Sheets.
  • Empower your data scientists with built-in machine learning and graph algorithms, native Python and R support, and a built-in notebook UI.
  • Ask questions in natural language and get answers from your organization’s data in Autonomous Database using Select AI.

Prebuilt warehouses and connectors

Whether you’re using Oracle Fusion Applications or Oracle’s NetSuite, E-Business Suite, or PeopleSoft applications, take advantage of ready-to-use data models, pipelines, and analytics to put data to work quickly.

  • Use insights from data in Oracle Cloud’s ERP, HCM, SCM, and CX application suites. Oracle Fusion Analytics Warehouse includes prebuilt KPIs, machine learning, and simpler data management.
  • Gain actionable insights from your NetSuite data. Oracle NetSuite Analytics Warehouse delivers powerful data analysis that drives actionable insights. Without relying on IT, business professionals can load data as well as quickly build and run their own analyses.
  • Start getting new insights from your E-Business Suite data up to 70% faster than building analytics on your own. The E-Business Suite accelerator includes a prebuilt extract, transform, and load pipeline; data model; prebuilt KPIs; dashboards; and reports.

BI enablement

Business analysts and line-of-business teams can deliver business intelligence (BI) solutions using a wide variety of analytics and BI tools.

  • Create shared business models (dimensions, hierarchies, measures, and “KPIs”) using Analytic Views across tools and applications to enable fast, reliable business insights.
  • Use your favorite BI tools: Oracle Analytics Cloud, Tableau, Microsoft Power BI, Excel, and more. Each tool can share the same business model, simplifying analytics and ensuring consistent results.

Data lake analytics

Analyze all your data—both inside Autonomous Database and outside in data lakes or cloud storage using the same tools, processes, and access methods as the database.

  • Query and analyze data in
    • Any cloud object storage, including OCI Object Storage, Amazon S3, Azure Blob Storage, and Google Cloud Storage
    • Any data lake file type: Parquet, Avro, JSON, csv, XLSX, and more
    • Any major data lake table structure, such as Delta tables or Iceberg tables
  • Keep data secure using the native security policies of object storage combined with the advanced security of Autonomous Database.
  • Run SQL queries directly against your object store source and correlate them with data stored in Autonomous Database.
  • Instantly find and access enterprise data sets by leveraging OCI Data Catalog and AWS Glue metadata repositories.
  • Use Apache Spark to analyze data in Autonomous Database with high performance.

Application development

Natural language queries using generative AI

Autonomous Database speaks “human.”

  • Simply ask a question using natural language—it’s the simplest way to get answers about your business.
  • Easily build natural language capabilities into your applications using Autonomous Database Select AI.

Low-code AppDev

Line-of-business analysts and nonprofessional developers can quickly develop smaller departmental applications as well as sophisticated enterprise-scale applications.

  • Use Oracle APEX, an enterprise low-code application platform, to develop applications 20X faster and with 100X less code.
  • Integrate advanced analytics into your applications with minimum coding using UI-based tools. Use Data Studio data analysis to build multidimensional models, AutoML, Oracle Spatial Studio, and Graph Studio.

Cloud native AppDev

Build microservices faster using a tech stack you know and make them easier for DevOps to operate.

JSON-centric AppDev

Develop apps quickly using a JSON document store that’s MongoDB-compatible but faster, more secure, and less expensive.

  • Build JSON apps with high availability, dynamic scalability, and advanced security.
  • Develop new apps using familiar MongoDB-compatible drivers, tools, and frameworks or migrate current MongoDB apps—all using Oracle Database API for MongoDB.
  • Analyze your JSON data with scalable SQL, and access JSON from any relational tool or application.
  • Tackle the hardest problems facing JSON database developers with ease, including multi-document ACID compliance, cross-collection joins, in-database procedural logic, and more.
  • Enable analysts and data scientists to analyze data across the document store and relational store using SQL.

Cost reduction

Reduced TCO with automation

Automation reduces human labor costs and elastic scaling reduces licensing costs, with big benefits for total cost of operating enterprise applications. An IDC study of Autonomous Data Warehouse customers shows

  • There’s an average five-year ROI of 417%, with breakeven on the investment occurring in an average of five months.
  • Reducing management and licensing costs and user productivity lost to downtime enables organizations to lower their total cost of operations by an average of 63%.
  • A flexible licensing model enables customers to cut their licensing costs by an average of 45%.
  • The time needed to deploy a new database drops by an average of 84% and the staff time required falls by 85%.

Elastic, pay-per-use pricing

Spend less on licensing and cloud consumption and avoid overprovisioning by deploying on an elastic cloud database.

  • Ensure usage and billing are aligned with actual application needs and consumption with elastic autoscaling. Compute and storage scale up and down independently in response to transient changes in workload, up to 3X base-provisioned resources, and with no downtime.
  • Increase base-provisioned resources at any time in response to longer-term compute and storage needs.
  • Access your data lake data up to 20X faster with the same pricing as object storage by storing all your data in Autonomous Database.
  • Consolidate database instances into elastic resource pools that scale up and down without downtime, potentially providing compute cost savings of up to 87% versus paying for each instance individually.

Management, security, and compliance

Automated database administration

Database administrators can move from manual administrative tasks to higher-value IT projects by taking advantage of automated management .

  • Reduce time spent on DBA-related tasks by an average of 68% and save up to 63% in operational costs.
  • Rely on automation for all database management tasks: provisioning, monitoring, backups, auditing, alerting, disaster recovery, and more.
  • Deliver better service levels with proactive database health monitoring and built-in fault tolerance. Patches and updates are applied automatically without downtime or human intervention.
  • Improve application performance without manually investigating the workloads and data distribution. Automatic partitioning and automatic indexing tune the database for your workloads.

Data security

Autonomous Database helps keep all your data secure from unauthorized access by insiders, outsiders, and cyberattacks, including ransomware and malware.

  • Frequent, automatic patching without downtime means that Autonomous Database is always up-to-date on security patches.
  • Create a secure environment that will remain secure over time as conditions change. Use the included Oracle Data Safe to understand data sensitivity, evaluate data risks, mask sensitive data, implement and monitor security controls, assess user security, and monitor user activity.
  • Protect against bad actors or malware with transparent data encryption. All data is always encrypted at rest, in motion, and when backed up.
  • Prevent unauthorized users from accessing sensitive data, prevent unauthorized database changes, and address industry, regulatory, or corporate security standards with the included Oracle Database Vault.
  • All users will see only appropriate data with advanced role-based access control, including redaction, masking, and filtering.

Compliance

Reduce the risks associated with operating enterprise applications.

  • Frequent, automatic patching without downtime means that Autonomous Database is always up-to-date on security patches.
  • Backups are fully automated, with optional long-term backups available for 10 years.
  • Auditing is always enabled.
  • Autonomous Database meets certified regulatory compliance standards, including Federal Risk and Authorization Management Program (FedRAMP) High, the Health Insurance Portability and Accountability Act (HIPAA), the Payment Card Industry Data Security Standard (PCI DSS), System and Organization Controls (SOC) 1, and SOC 2.

Mission-critical application support

High availability and business continuity

IT organizations can keep mission-critical applications running with less human involvement.

  • Take advantage of 99.995% availability for Autonomous Database with Oracle Autonomous Data Guard (including planned and unplanned downtime). Maximize protection with multiple standby databases across multiple regions.
  • Keep apps running with Application Continuity, which transparently recovers in-flight database transactions during outages.
  • Avoid planned downtime with automated updates, backups, and patching that require no downtime and no human intervention.
  • For less-critical apps, the default availability is 99.95%, and a lower-cost disaster recovery is available.

Mission-critical app deployments

Run and extend Oracle apps, such as PeopleSoft, JD Edwards, and Siebel, or your custom or ISV apps for improved performance, availability, and security.

  • Migrating apps is easy. Autonomous Database runs the same Oracle Database you’re accustomed to running on-premises.
  • Accelerate performance—Autonomous Database is preconfigured with optimized storage, automatic indexing, and data caching.
  • Rely on a proven, industry-leading platform for all types of transaction processing, including OLTP transactions, lightweight transactions, augmented transactions, and stream event processing.
  • Industry-proven transparent scalability and availability are provided.
  • The workload is monitored, and indexes are automatically created and maintained.
  • Protect data without downtime. Your database deployment is secure by default and automatically kept up-to-date with the latest database and security patches.