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.
Oracle Autonomous Data Warehouse
Oracle Autonomous Data Warehouse is a cloud data warehouse service that eliminates all the complexities of operating a data warehouse, 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.
Watch EVP Andrew Mendelsohn, Oracle Database Server Technologies, to learn about Oracle's latest cloud data warehouse innovations.
Detailed analysis by industry expert DSC illustrates why Oracle Autonomous Data Warehouse is a better pick for the majority of global organizations
Learn about applications and tools that are compatible with Autonomous Data Warehouse.
Get started with Oracle Autonomous Data Warehouse for free.
Why choose Oracle Autonomous Data Warehouse?
Autonomous warehouse management
Oracle Autonomous Data Warehouse eliminates nearly all manual labor, human error, and required expertise. Beyond provisioning, and configuration, backup, it automates patching and updates without any downtime or administrative action. Autonomous Data Warehouse uniquely automates performance tuning to ensure consistent high performance even as workloads change, or the number of concurrent users increases. To meet business demands, Autonomous Data Warehouse autoscales automatically with no downtime, adding only the needed resources and ensuring that customers do not pay for over-provisioned instances with a rigid T-shirt size model. In addition, it can also automatically recover from failure, reducing the need for human intervention. All this ensures that business teams can improve agility and operate data marts independently from IT, while DBAs can focus on using data to generate business value instead of performing high-cost manual tasks.
Unior Group, based in Zreče, Slovenia, manage 85 million records with no database administrators. (1:23)Watch the Autonomous Database video (1:00)
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 multi-model data and multiple workloads. It includes built-in self-service tools to improve the productivity of analysts, data scientists and developers. Analysts can load and transform data by dragging and dropping rather than scripting, quickly build new business models and automatically identify data for further analysis. Both expert and citizen data scientists can build machine learning models using Python, SQL or AutoML and deploy them in the database or use REST endpoints. Developers can build data-driven applications with converged data, and use both spatial and graph analytics to deliver better results.
Analyst report: Oracle's Autonomous Data Warehouse Enhancements: Democratizing Simplicity (PDF)Maxim’s Caterers, based in Hong Kong, analyzes 600,000 daily transactions and social media data using ad-hoc queries and what-if analysis to improve business efficiency and competitiveness.
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.
Shared infrastructure (public cloud):
With the shared infrastructure deployment option, customers get the benefits of automated operations, performance, scale, and the advanced security of Autonomous Data Warehouse running in Oracle public cloud, but for a lower cost.Dedicated infrastructure (public cloud):
The dedicated infrastructure deployment option provisions customer databases on dedicated Exadata infrastructure in Oracle public cloud. Dedicated infrastructure provides isolation from other users and gives the same performance and predictability as on-premises deployments. Additionally, customers have the ability to control autonomous operational policies, such as the timing of upgrades and patches.Cloud@Customer infrastructure (customer’s data center):
Autonomous Data Warehouse on Exadata Cloud@Customer combines all the benefits of having Exadata Database Machines in customer data centers with the added simplicity of autonomous cloud management. The service enables self-service agility, removes the challenge of lifting and shifting data warehouses to the public cloud, and allows customers to meet organizational requirements for strict data sovereignty and security, since Cloud@Customer runs in the customer’s data center.
Comprehensive data and privacy protection
Autonomous Data Warehouse makes it easy to keep data safe from outsiders and insiders. It autonomously encrypts data at rest and in motion (including backups and network connections), protects regulated data, applies all security patches, enables auditing, and performs threat detection. In addition, customers can easily use Oracle Data Safe to conduct ongoing security assessments, user and privilege analysis, sensitive data discovery, sensitive data protection, and activity auditing. Autonomous Data Warehouse protects the organization and all data against data breaches, malware injections, DDoS attacks, malicious insiders, advanced persistent threats, insecure APIs, account hijacking, and more.
DX Marketing, based in Savannah, Georgia, relies on Autonomous Data Warehouse to protect more than 260 million licensed records of US consumers and their associated private information. (1:54)IDC Research: The Security Benefits of a Fully Managed Database Service (PDF)
Autonomous Data Warehouse
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
Graph databases make it easier to manage, represent, and interact with complex relationships in data. The graph model enables data scientists and developers to apply pattern recognition, classification, and statistical analysis, all of which allow for more efficient analysis at scale against massive amounts of data.
Oracle Autonomous Database already has graph capabilities for analyzing and visualizing graph models, but will soon add Graph Studio for a complete, managed platform for graph analytics.
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
See what top industry analysts are saying about us
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.
Learn more (PDF)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
Use cases for Autonomous Data Warehouse
-
Build a departmental data warehouse
Deploy a self-service departmental data warehouse to consolidate data from multiple spreadsheets and other flat-file data sources into a trusted, maintainable, and high-quality dashboards.
-
Build a departmental data warehouse for enterprise applications
Consolidate data from multiple enterprise systems, spreadsheets, and 3rd party data sources into an integrated and analytical data store.
-
Extend an enterprise data warehouse
Simplify your enterprise data warehouse to support multimodel, converged data with autonomous capabilities.
-
Build an enterprise data warehouse with integrated data lake
Combine the abilities of a data lake and a data warehouse to manage any data type for business analysis and machine learning.
Oracle Autonomous Data Warehouse: New innovations for data analysts, citizen data scientists, and LOB developers
George Lumpkin, Vice President, Product Management for Autonomous Data WarehouseAfter 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 postFeatured blogs
- March 17, 2021 Introducing Autonomous Data Tools
- March 17, 2021 Introducing Graph Studio with Oracle Autonomous Database
- March 16, 2021 Introducing Oracle Machine Learning Services
- May 11, 2020 Many single-purpose databases versus a converged database
Resources
Autonomous Data Warehouse pricing
Autonomous Data Warehouse documentation
Product documentation and help center to deploy Autonomous Data Warehouse service for shared and dedicated infrastructure.
Additional information
- Autonomous Data Warehouse tutorials
Learn how to use Autonomous Data Warehouse with hands-on workshops to explain key capabilities. - 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. - Training Plans
Our training plans provide a wide variety of labs and workshops, enabling you to learn cutting-edge skills Oracle Cloud, live. - Oracle Autonomous Data Warehouse demo (3:44)
Newsletters
Information, tips, tricks, and sample code for an autonomous, cloud-driven world.
Additional information
Get started
Try Oracle Cloud Free Tier
Build, test, and deploy applications on Oracle Cloud for free.
Contact us
Interested in learning more? Contact one of our industry-leading experts.