No results found

Your search did not match any results.

We suggest you try the following to help find what you're looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Contact Us Sign in to Oracle Cloud

Autonomous Data Warehouse

Oracle Autonomous Data Warehouse is a cloud data warehouse service that eliminates all the complexities of operating a data warehouse, dw cloud, data warehouse center, securing data, and developing data-driven applications. It automates provisioning, configuring, securing, tuning, scaling, and backing up of the data warehouse. It includes tools for self-service data loading, data transformations, business models, automatic insights, and built-in converged database capabilities that enable simpler queries across multiple data types and machine learning analysis. It’s available in both the Oracle public cloud and customers' data centers with Oracle Cloud@Customer.

Oracle Autonomous Data Warehouse Innovations Data Warehouse Innovations

Watch EVP Andrew Mendelsohn, Oracle Database Server Technologies, to learn about Oracle's latest cloud data warehouse innovations.

Why Snowflake Melts When Compared to Autonomous Data Warehouse Why Snowflake Melts When Compared to Autonomous Data Warehouse

Detailed analysis by industry expert DSC illustrates why Oracle Autonomous Data Warehouse is a better pick for the majority of global organizations

Autonomous Data Warehouse compatible applications and tools Autonomous Data Warehouse compatible applications and tools

Learn about applications and tools that are compatible with Autonomous Data Warehouse.

5 reasons Why Oracle Autonomous Data Warehouse is better.

Why choose Autonomous Data Warehouse?

Autonomous warehouse management

Oracle Autonomous Data Warehouse eliminates nearly all manual administrative tasks. It automates common tasks like backup, configuration, and patching. Uniquely, it is also able to continuously automate performance tuning and autoscaling, with no downtime, human intervention or over-provisioning. This reduces administration effort by up to 90% and enables business teams to operate without help from IT.

The 2025 Imperative: Intelligent Automation Now

A complete solution with self-service data tools and analytics

Autonomous Data Warehouse is the only complete solution that uses a converged database providing built-in support for multimodel data and multiple workloads. It includes built-in self-service tools to improve the productivity of analysts, data scientists, and developers.

Autonomous for Business Success (PDF)

Available in Oracle public cloud or in customers’ data centers

Unlike other cloud data warehouse services, Autonomous Data Warehouse offers three deployment choices.

Comprehensive data and privacy protection

Autonomous Data Warehouse autonomously encrypts data at rest and in motion, protects regulated data, applies all security patches, and performs threat detection. In addition, customers can easily use Oracle Data Safe to conduct, user and privilege analysis, sensitive data discovery and protection, and activity auditing. Autonomous Data Warehouse makes it easy to keep data safe from outsiders and insiders.

IDC Research: The Security Benefits of a Fully Managed Database Service (PDF)

Autonomous Data Warehouse features

Simplified data warehouse management—with autonomous administration

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 will enable customers to run a high-performance, highly available, and secure data warehouse while reducing administrative costs.

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

Ensure consistent high performance

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

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
  • Database activity monitoring and blocking
  • Consolidated auditing and reporting
  • Data masking
  • Data redaction

Self-service data management tools

Data tools provide a simple, self-service environment for loading data and making it available to their extended team for collaboration. Business and data analysts can easily load and transform data with drag-n-drop capabilities, generate business models, quickly discover anomalies, outliers and hidden patterns, understand data dependencies, and the impact of changes.

Features
  • Data loading
  • Data Transformation
  • Business Model
  • Data Insights
  • Catalog

Machine learning for everyone

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.

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

Uncover hidden relationships in data

Autonomous Database 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:
  • Automated graph modeling
  • Automated install, upgrade, and provisioning
  • Autosave, backup, and checkpoint data restoration features
  • Advanced notebooks and visualization
  • Ability to schedule analysis
  • 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 model 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

Get started with Oracle Autonomous Data Warehouse for free.

See what top industry analysts are saying about Autonomous Data Warehouse

IDC finds Autonomous Data Warehouse customers obtain a
417% ROI in five years

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

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

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

Learn more (PDF)
Constellation Research

Constellation Research finds Oracle database has 32% more capacity than the largest AWS offering.

Learn more
View all Autonomous Database customer successes

An economical, efficient, and effortless customer experience

Learn how Oracle customers are using Oracle Autonomous Database to transform their businesses by redefining data warehousing through machine learning and automation

TaylorMade logo
OUTFRONT Media logo
Vodafone logo
CERN logo
Accenture logo
sky logo
AON
Zebra
Lyft logo

Lyft builds a single, global source of information for faster insights.

Find out what our customers are saying

Gartner logo

Reviews from your enterprise peers — verified by Gartner

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.

Use cases for Autonomous Data Warehouse

Improving analytics for the line of business

Deploy a self-service departmental data warehouse to consolidate multiple enterprise systems, spreadsheets, and third-party data sources into a trusted, maintainable, and integrated dashboard. Integrated self-service data tools allow users to load and transform data with drag and drop, generate business models, quickly discover anomalies, and build machine learning (ML) models.

See the reference architecture

Discover Oracle Departmental Data Warehouse

Improving analytics for the line of business
Answer complex questions using all data

Simplify and modernize an enterprise data warehouse

Answer more complex questions using all data. Simplify your enterprise data warehouse to support multimodal, converged data with autonomous capabilities.

See the reference architecture

Discover your enterprise data warehouse solution

Augment decision-making with machine learning

Build and deploy machine learning models in Oracle Autonomous Data Warehouse using scalable and optimized in-database algorithms.

See the reference architecture

Discover your machine learning solution

Augment decision making with machine learning

Autonomous Data Warehouse pricing

Autonomous Data Warehouse on Shared Infrastructure

Product
Comparison Price (/vCPU) *
Unit price
Unit
Oracle Autonomous Data Warehouse


OCPU per hour
Oracle Autonomous Database – Exadata Storage


Terabytes Storage Capacity per month

Autonomous Data Warehouse on Dedicated Infrastructure

Product
Comparison Price (/vCPU) *
Unit price
Unit
Oracle Autonomous Data Warehouse - Dedicated


OCPU per hour
Oracle Cloud Infrastructure - Database Exadata Infrastructure - Quarter Rack - X8M


Hosted environment per hour
Oracle Cloud Infrastructure - Database Exadata Infrastructure - Quarter Rack - X8


Hosted environment per hour
Oracle Cloud Infrastructure - Database Exadata Infrastructure - Half Rack - X8


Hosted environment per hour
Oracle Cloud Infrastructure - Database Exadata Infrastructure - Full Rack - X8


Hosted environment per hour
Oracle Cloud Infrastructure - Oracle Database Exadata Infrastructure - Quarter Rack - X7


Hosted environment per hour
Oracle Cloud Infrastructure - Database Exadata Infrastructure - Half Rack - X7


Hosted environment per hour
Oracle Cloud Infrastructure - Database Exadata Infrastructure - Full Rack - X7


Hosted environment per hour

  • For Autonomous Data Warehouse on Dedicated Infrastructure:
  • – Minimum term for subscription to Database Exadata Infrastructure is 48 hours
  • – Minimum OCPU purchase is 1 OCPU per database node and up to the maximum number of OCPUs per rack

Autonomous Data Warehouse Bring Your Own License (BYOL)

Product
Comparison Price (/vCPU) *
Unit price
Unit
Oracle Autonomous Data Warehouse


OCPU per hour
Oracle Autonomous Data Warehouse - Dedicated


OCPU per hour

  • If you run Oracle Database Enterprise Edition and the required options listed below, then your BYOL requirements are as follows:
  • – For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance:
  • – For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service.
  • – For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1 OCPU of the BYOL Cloud Service.
  • – For 17 OCPUs or more of a single Oracle Autonomous Data Warehouse:
  • – For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.
  • – For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.

Common cloud industry practice is to define compute instances based on the number of virtual CPUs (vCPUs) they include. Each vCPU provides the capacity for one thread of execution. A vCPU does not provide a whole physical compute core, it’s part of a core. In contrast, Oracle’s x86 compute shapes use OCPUs which equate to physical CPU cores, each of which provides for two threads. To make it easier for customers to compare across cloud service providers, Oracle presents vCPU pricing on our web pages while billing is based on the number of OCPU time they consume. The per-hour OCPU rate customers are billed at is twice the vCPU price on the web pages since they receive two vCPUs of compute power instead of one.

March 17, 2021

Oracle Autonomous Data Warehouse: New innovations for data analysts, citizen data scientists, and LOB developers

George Lumpkin, Vice President, Product Management for Autonomous Data Warehouse

After the introduction of Autonomous Data Warehouse, organizations of all sizes recognized how simple it could be to provision a data warehouse. Since Autonomous Data Warehouse requires no operational administration (and thus does not require a database administrator), a cloud data warehouse is within the reach of many more organizations than before.

Read the complete post

Resources

Documentation

Autonomous Data Warehouse documentation

Product documentation and help center to deploy Autonomous Data Warehouse service for shared and dedicated infrastructure.

Additional information

Cloud Learning
related content

Newsletters

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

Get started with Autonomous Data Warehouse


Try Oracle Autonomous Database

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


Contact us

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

1 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.