Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.

Announcing Oracle DatabaseWorld: Multicloud AI Edition

Join us at the free virtual event on June 17, to discover how you can advance your AI and multicloud strategies with Oracle’s latest innovations in database and cloud technologies.

Why choose Autonomous Data Warehouse?

Autonomous Data Warehouse features

A modern data platform for business insights

Oracle Autonomous Data Warehouse plays a central role as both an analytic engine and optimized data store for the data lakehouse. Users can access the lakehouse through Autonomous Data Warehouse’s powerful and open SQL processing engine. Gain insights by running analytics with built-in AI, machine learning, graph, spatial, and more. Analyze data across multiple clouds and data stores using built-in connectors or analyze data using highly efficient Apache Spark and Python connectivity.


Simplified data warehouse management—with built-in automation

Autonomous management capabilities, such as provisioning, configuring, securing, tuning, and scaling, eliminate nearly all the manual and complex tasks that can introduce human error. Autonomous management enables customers to run a high-performance, highly available, and secure data warehouse while running thousands of databases with no administration.

Features
  • Auto-backups
  • Auto-patching
  • Auto-repairing
  • Auto-scaling
  • Auto-securing
  • Auto-tuning

Ensure consistently high performance

Autonomous Data Warehouse continuously monitors all aspects of system performance. It adjusts autonomously to ensure consistent high performance even as workloads, query types, and the number of users vary over time.

Features
  • Auto-scaling
  • Auto-tuning
  • Auto-indexing
  • Hybrid Columnar Compression
  • Columnar processing
  • Smart Scan
  • Automatic optimizer statistics gathering

Reduce risk with database security

Secure Autonomous Data Warehouse with a unified database security control center that identifies sensitive data and masks it, issues alerts on risky users and configurations, audits critical database activities, and discovers suspicious attempts to access data.

Features
  • Transparent data encryption
  • Encryption key management
  • Privileged user and multifactor access control
  • Data classification and discovery
  • Data masking
  • Data redaction
  • Database activity monitoring and blocking
  • Consolidated auditing and reporting

Data Studio

Data Studio is built into Autonomous Data Warehouse, offering users simple and intuitive self-service data management tools for loading, transforming, analyzing, and sharing data with internal and external stakeholders. Its built-in catalog enables users to discover data assets in databases, object stores, and data lakes.

Business and data analysts can easily integrate data from more than 100 application, cloud service, and database sources with drag-and-drop workflow capabilities. Data Studio also lets users generate business models, quickly discover anomalies and hidden patterns, understand critical data dependencies, and access all organizational data located in databases and data stores.

Features
  • Data loading
  • Data transformation
  • Data analysis
  • Data insights
  • Catalog
  • Data sharing

Machine learning and AI

Build and deploy machine learning models in Oracle Autonomous Data Warehouse using scalable and optimized in-database algorithms. Oracle Machine Learning accelerates the creation of machine learning models for data scientists by eliminating the need to move data to dedicated machine learning systems. Let your users ask any questions in their natural language and have Autonomous Database Select AI answer them.

Features
  • Automatic data preparation
  • AutoML automates model development
  • Easy model deployment through REST and SQL interfaces
  • High performance, scalability, and security
  • In-database algorithms
  • Oracle Machine Learning services
  • Oracle Machine Learning AutoML User Interface
  • Oracle Machine Learning Notebooks
  • Oracle Machine Learning for Python
  • Oracle Machine Learning for SQL

Uncover hidden relationships in data

Autonomous Data Warehouse includes graph database features to represent and manage complex data relationships. The graph analytics enable data scientists and developers to apply pattern recognition, classification, and statistical analysis for deeper context.

Graph Studio key features
  • Ability to schedule analysis
  • Advanced notebooks and visualization
  • Automated graph modeling
  • Automated install, upgrade, and provisioning
  • Autosave, backup, and checkpoint data restoration features
  • Sample notebooks and workflows for different use cases

Making sense of location

The spatial features in Autonomous Data Warehouse address all forms of applications, spatial workloads, and datasets, including the most demanding, large-scale location intelligence and geospatial applications.

Features
  • Data modeling and comprehensive analytics for 2D spatial data
  • High performance, parallel spatial processing
  • Standards-based SQL and Java APIs
  • Native JSON and REST support
  • Location tracking server
  • Contact tracing built-in functions
  • Self-service Spatial Studio

Improve the availability of data warehousing and analytics workloads

Autonomous Data Warehouse provides more than 99.995% availability1 with built-in Oracle Real Application Clusters, parallel infrastructure, automated disaster recovery, and backups.

Features
  • Automatic storage management
  • Maximum availability architecture
  • Oracle Active Data Guard
  • Oracle Autonomous Health Framework
  • Oracle Real Application Clusters
  • Oracle Data Safe

Get more timely analytics with accelerators for E-Business Suite, Fusion, and NetSuite

Oracle application accelerators for Oracle’s E-Business Suite, Fusion Applications, and NetSuite provide enhanced analytical capabilities with self-service data discovery, built-in ETL, and KPI metrics. Users can do more with comprehensive data integration and ready-to-use data models.

Features
  • Oracle application accelerators offer prebuilt ETL, enabling users to quickly create data warehouses from Oracle E-Business Suite data.
  • Oracle Fusion Analytics Warehouse and Oracle NetSuite Analytics Warehouse are built on Autonomous Database and provide an end-to-end cloud data warehouse and analytical solution.
  • For custom-built data warehouses, Autonomous Data Warehouse provides comprehensive data transformation flows that connect to Oracle and third-party applications.

Autonomous Data Warehouse at OCI, AWS, Azure, and Google Cloud

Accelerate innovation by gaining the power and flexibility of Autonomous Data Warehouse in any leading cloud. Combine the best of the cloud with your data in Autonomous Data Warehouse to quickly build and modernize applications.

Features

  • The highest level of Oracle Database performance, scale, and availability using Oracle Exadata infrastructure
  • Pricing and feature parity with OCI, including Oracle Real Application Clusters
  • The ability to leverage each hyperscaler's native cloud services for AI, security, and data integration when building solutions using Autonomous Data Warehouse
  • Choice of business intelligence tools for immediate insights
  • The simplicity, security, and low latency of a single operating environment within OCI, AWS, Azure, and Google Cloud, including federated identity and access management for database services
  • Simplified monitoring and troubleshooting with Oracle Database service logs, metrics, and events available directly in OCI, AWS, Azure, and Google Cloud
  • The ability to purchase Oracle Database services through AWS, Azure, and Google Cloud Marketplace with your current cloud commitments and/or use current Oracle Database licenses and unlimited license agreements

Watch how to maximize collaboration with Oracle Autonomous Database data sharing.

See what top industry analysts are saying about Autonomous Data Warehouse

IDC finds Autonomous Database customers obtain a 417% ROI in five years.

Read the IDC report (PDF)

Wikibon finds Oracle Autonomous Database is 50% lower cost than AWS.

Read the Wikibon report (PDF)

Omdia Universe ranks Oracle as a "Leader" as a “uniquely self-governed data and analytics platform capable of consistently handling a wide array of workloads across hybrid cloud/on-premises deployments.”

Read the Omdia Universe report (PDF)

Get started with Oracle Autonomous Data Warehouse for free

An economical, efficient, and effortless customer experience

See more customer successes
Learn how Oracle customers are using Oracle Autonomous Data Warehouse to modernize their businesses through data lakes, machine learning, and automation.

Find out what our customers are saying

Gartner logo

Reviews from your enterprise peers—verified by Gartner.2

TrustRadius logo

Top-rated software and services based on in-depth reviews from verified users.

G2 logo

Business software and services based on user ratings and social data.

JANUARY 30, 2025

Autonomous Database Sample Code Repo for Multicloud and AI

Marty Gubar, Director of Product Management, Oracle

Introducing the new Autonomous Database code samples repository on GitHub, making it the perfect complement to LiveLabs. Although the repository does not contain end-to-end solutions, it offers key code examples that you can use to develop solutions.

Read the complete post

Oracle Autonomous Data Warehouse resources

Documentation

Autonomous Data Warehouse documentation

Explore Oracle Help Center for product documentation and other resources to deploy Autonomous Data Warehouse.

  • Free step-by-step workshop
    Learn how to create a modern data warehouse, set up a data lake, or experiment with machine learning using a hands-on workshop with step-by-step instructions.
related content

Newsletters

Information, tips, tricks, and sample code for an autonomous, cloud-driven world.

The Oracle Playbook series

We've compiled the secrets to our people, process, and systems strategy. And we want to share them with you.

Get started with Autonomous Database

Try Oracle Autonomous Database

Oracle Cloud offers a Free Tier with a 30-day free trial and always-free services.

Download Autonomous Database

Get Autonomous Database Free Container Image to develop your apps without the cloud.

Follow us @OracleDatabase

Get the latest Oracle Database news, events, and community resources.

Contact us

Interested in learning more? Contact one of our industry-leading experts.

1. The service level agreement (SLA) for 99.995% availability assumes the use of Oracle Autonomous Data Guard. The SLA is 99.95% availability when Autonomous Data Guard isn’t enabled.

2. The Gartner Peer Insights logo is a trademark and service mark of Gartner Inc. and/or its affiliates and is used herein with permission. All rights reserved. Gartner Peer Insights reviews constitute the subjective opinions of individual end-user reviews, ratings, and data applied against a documented methodology; they neither represent the views of, nor constitute an endorsement by, Gartner or its affiliates.