Oracle Autonomous Data Warehouse

Automated data warehouse management

Autonomous Data Warehouse intelligently automates provisioning, configuring, securing, tuning, and scaling a data warehouse. This eliminates 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.

Unior Group, based in Zreče, Slovenia, manage 85 million records with no database administrators. (1:23)

Watch the Autonomous Database video (1:00)

A complete solution with built-in analytics

Autonomous Data Warehouse is the only complete solution that uses a converged database providing built-in support for multimodel data and multiple workloads such as analytical SQL, machine learning, graph, and spatial. It requires no integration with other services, making it easy to load any data, run complex queries across multiple data types, build sophisticated analytical models, visualize information, deliver dashboards and develop data-driven applications.

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.

Consistent high performance for any number of concurrent users

Autonomous Data Warehouse uses continuous query optimization, table indexing, data summaries, and auto-tuning to ensure consistent high performance even as data volume and number of users grows. Autonomous scaling can temporarily increase compute and I/O by a factor of three to maintain performance. Unlike other cloud services which require downtime to scale, Autonomous Data Warehouse scales while the service continues to run.

Vodafone Fiji saw a 6X improvement for the processing of 600 million records per day. (1:27)

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)

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.