Day 4: Autonomous Database
December 11, 2020
Oracle introduced a disruptive technology and revolutionized how data is managed with the introduction of the Autonomous Database (ADB). ADB comes in two flavors optimized to meet the customer's requirements for Online Transaction Processing (ATP) or Data Warehousing (ADW). The ADB technology heavily leverages machine learning and automation to attack complexity and eliminate human error & manual intervention, to provide higher reliability, scalability, manageability, security, and operational efficiencies.
Now with the machine learning capability, the Oracle Autonomous Database came out as one of the most important advancements in the database history starting with Oracle 18c release, current version is 21c database. A 2020 detailed database review, placed Oracle as the most innovative database, primarily because of Autonomous Database. Whether it’s in the Oracle Cloud or Cloud at Customer, Autonomous Database is one of the most revolutionary developments for Oracle.
Some of the main reasons to move to the Autonomous Database in Oracle Cloud include:
• Self-driving – You setup size, speed, and service levels of the database; Oracle manages the rest. Automates all database and infrastructure management and monitoring.
• Self-securing – Imagine a database that is patched before you even know that you need a patch (let alone apply it). Oracle ADB provide protection from both external attacks and malicious internal users.
• Self-repairing: Automated protection from all downtime, it backs itself up. Oracle eliminates human errors with automation.
• Self-tuning: It looks at indexes and ensures the proper execution plan is used while also creating or dropping indexes as needed, by using machine learning.
• Self-patching and upgrading: Security patches are automatically applied
Innovative Autonomous Features
Oracle has a very long history as the leader in data management and now as a pioneer in automation and machine learning. Within the last 30 plus years, Oracle has been automating the core capabilities of the database technology from memory to storage management. The following top 10 innovative features and capabilities of Autonomous Database include:
- Auto Provisioning: Deploys mission-critical databases including RAC on Exadata Infrastructure with fault-tolerant, highly available, seamless scale-out, protection from server failure and maintenance with rolling fashion management.
- Auto Configuration: Configures databases to optimize specific workloads with everything from memory, data formats, and storage structure to ensure performance. Just load the data and start using the database.
- Auto Indexing: Monitors database workloads and adds indexes to accelerate applications; including validation for effectiveness with machine learning for correction and adjustment.
- Auto Scaling: Scales compute resources based on application workload without downtime.
- Auto Data Protection: Protects sensitive data with user defined data classification and secures data for unusual database activities.
- Auto Security: Encrypts data for the entire database, backup, and during data transport across network with additional protection from phishing attacks, such as admin, internal, and OS privileges
- Auto Backup and Recovery: Backs up databases based on daily schedules and on-demand, including recover capability with point-in-time within the last 60 days.
- Auto Patching: Patches or upgrades with zero downtime for application
- Auto Resolution and Detection: Detects failures across hardware and software with machine learning such as fault and error pattern recognition. Eliminates any timeouts and deviation, such as redirecting unhealthy compute resources before fault occurred.
- Auto Optimization: Optimizes workloads with data formats, parallel processing, and database execution plans including baselines
Autonomous Databases are all auto-scale enabled by default, which means that they can scale up in compute resources as needed to optimize cost and provide performance on-demand. With auto scaling, the database can automatically scale up to three times the CPU and IO resources of the current number of OCPUs, without manual intervention. Customers will only pay for resources that are being used. All scaling operations occur while the applications continue to be available on-line to process business critical workloads.
Where do you start?
Creating an Autonomous Database