Autonomous Databases
As you know already, Oracle has delivered a few decades of data management systems and innovation for on-premise, cloud, and hybrid type of deployment. The latest cloud version of the database is called the Autonomous Database (ADB). This system combines
- PDF / 1,795,948 Bytes
- 30 Pages / 504 x 720 pts Page_size
- 26 Downloads / 210 Views
Autonomous Databases As you know already, Oracle has delivered a few decades of data management systems and innovation for on-premise, cloud, and hybrid type of deployment. The latest cloud version of the database is called the Autonomous Database (ADB). This system combines concepts like self-driving, self-securing, and self-repairing by redefining the database management tasks using machine learning and automation. This dramatically reduces the needs of human labor, costs, and manual tuning and then reduces the risk and human errors. This way, your system is more stable, more efficient in terms of performance but also in terms of cost.
What Is Autonomous Database Oracle wanted to have an autonomous system that will take care of databases and the underlying infrastructure, as well as tuning and monitoring. Oracle came up with the Autonomous Database, a fully managed service that handles the operation like the creation of the database, the backup of the database, patching, upgrade, as well as the scaling of the database. Every DBA knows pretty well these activities as all of these tasks were manually done by them in the past. In fact, some of them like patching and upgrade were probably not done as they should have been done by lack of time and resources, which ended up with vulnerable systems. By self-driving, Oracle is providing the capabilities of provisioning, automate patching, and upgrade and is able to tune itself. Scaling capabilities also allows the database to scale up/down the resources to automatically adjust with the workload. By self-securing, Oracle is providing the capabilities of automatically applying security patches, protecting against know cyberattacks. Free of charge, the database is encrypted at rest and, in transit, can use Oracle Data Safe to mask sensitive data and also to alert suspicious data access.
© Adrian Png and Luc Demanche 2020 A. Png and L. Demanche, Getting Started with Oracle Cloud Free Tier, https://doi.org/10.1007/978-1-4842-6011-1_7
107
Chapter 7
Autonomous Databases
By self-repairing, Oracle is providing the capabilities of protecting against all sorts of issues, system failures, user errors, and so on. By using Autonomous Database, we know that important tasks like patching and upgrade have been taken care of automatically by Oracle. So, this eliminates the vulnerabilities of your system, with less administration efforts.
Difference Between ATP and ADW Autonomous Database comes in two different flavors, Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW) – two different configurations to meet specific requirements for online processing and data warehousing. To help you determine which would be the better fit for your needs between ATP and ADW, let’s start with differentiating two workloads, OLTP and Data Warehousing (DW). OLTP stands for Online Transactional Processing, and this type of application mainly deals with large numbers of transactions by a large number of users. You can imagine an application that executed hundreds of small tran
Data Loading...
