Oracle Autonomous Database

• An autonomous database is a cloud database that uses ML to automate database optimization, security, backup, updates, and other routine administrative tasks traditionally performed by database administrators. Unlike traditional databases, autonomous databases perform all of these tasks but do not require human intervention.
• user can define backup buckets and staging buckets (storage), to store his own backup pieces and staging files for recovery points if needed.
• oracle autonomous database can be monitored and managed by APIs and UI tools such as Enterprise Manager Cloud Control, SQL developer, Oracle machine learning web-based tool (OML)
• After provisioning, you can scale the number of CPU cores or the storage capacity of the database at any time without impacting availability or performance

• It is a self-driving, self-securing, self-repairing database service.

Autonomous Database Workload types

An autonomous database consists of two key elements that align with workload types.
Autonomous Datawarehouse(ADW):

• This is like the oracle Datawarehouse database type on-premise
• It is built for decision support and data warehouse workloads.
• Offers fast queries over large volumes of data and can perform query scans on millions of rows
• It is scalable to business needs
• It can be deployed in a matter of seconds.

Autonomous Transaction Processing(ATP)

• It is like OLTP and Built for transactional workloads which enable time-based transactional processes such as real-time analytics, personalization, and fraud detection.
• It allows for simple application development and deployment.
• It is scalable to business needs
• It can be deployed in a matter of seconds.

Autonomous JSON Database

• It is Built for JSON-centric application development.
• It is just like Oracle Autonomous Transaction Processing but specialized in developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents
• it is currently available on shared Exadata infrastructure.

Oracle APEX Application Development (APEX Service)

• This database is optimized for application developers who require a transaction processing database for use with Oracle APEX.
• It enables the development and deployment of low-code applications such as databases.

Deployment Options for Autonomous Databases:

There are two options for deploying an autonomous database.
Serverless

• With this option, you simply select what type of database you want (Data Warehouse or Transaction Processing), and which region in the Oracle Cloud your database should be deployed
• You also select the computing and storage resources and then Oracle automatically takes care of everything for you.
• Here Oracle deploys and manages the Exadata infrastructure
• You can also configure the network access so that the database uses a private endpoint within one of your tenancy’s virtual cloud networks (VCNs).and then your database is only accessible via the IP address of the associated private endpoint.

Dedicated

• With this option, you get your own exclusive Exadata infrastructure
• Dedicated Exadata infrastructure offers multitenant database architecture, allowing you to create and manage multiple Autonomous Databases within a single database system
• You can customize the software update/patching policy etc.
• Both workload types (transaction processing and warehouse) can be provisioned on dedicated Exadata infrastructure

Benefits of an Autonomous Database

• Maximum database uptime, performance, and security―including automatic patches and fixes
• Elimination of manual, error management tasks through automation
• Reduced costs and improved productivity by automating routine tasks
• Reducing the number of DBAs needed to manage its databases
• Machine learning helps in many ways
  • It automatically and continuously patches, tunes, back up, and upgrades the system without manual intervention all while the system is running
  • Using pattern recognition, hardware failures are automatically predicted without long timeouts. IOs are immediately redirected around unhealthy devices to avoid database hangs. Continuous monitoring for each database automatically generates service requests for any deviation.

Related Articles

oracle cloud infrastructure: Oracle Infrastructure as a Service is called Oracle Cloud Infrastructure (OCI). It offers storage, compute, database, networking, and edge services
iaas paas saas : Cloud Computing Basics: iaas paas saas
oci block storage : OCI Block storage is the NVMe SSD based storage that you can attach to any compute instance that was launched. Check out about backup,cloning