OCI offers various databases options, including the Autonomous Database, which is a cloud database that uses machine learning to automate database tuning, security, backup, updates, auto fault tolerant, and other routine management tasks performed by DBAs. It is easy to use, delivers fast query performance, and requires no database administration. The idea behind this is it automate services as much as possible and enable users to focus on higher level tasks. There are generally two kinds of deployment models:

  1. Serverless model: In this model, users can provision, configure, monitor, and manage only the autonomous database. It is ultra-simple and elastic, while Oracle handles Exadata infrastructure deployment and management. This model supports both ADW and ATP.
  2. Dedicated model: This model focuses on the exclusive use of Exadata hardware. Users get completely dedicated compute, storage, network, and database services. It is also supported for both workload models, ADW and ATP.

There are two types of workloads supported by this service, which provides self-driving, self-securing and self-repairing services:

  1. Autonomous Database Warehouse (ADW)
  2. Autonomous Transaction Processing (ATP)

Oracle Exadata Database Service is an automated Oracle Database service that allows organizations to run databases with the highest performance, availability, security, and cost-effectiveness. Exadata can reduce your data center footprint and accelerate time-to-market for mission-critical workloads. There are two types of Exadata services:

  1. Dedicated: This type applies to cloud-specific software tools that assist with administration tasks, such as backup, recovery, and patching.
  2. Cloud@Customer: This type combines cloud simplicity, agility, and elasticity with deployment inside the data center.

The Base Database enables users to maintain absolute control over their data. It provides two services:

  1. Single-node DB systems on either bare metal or virtual machines.  For one-node virtual machine DB systems, OCI provides a fast-provisioning option that allows users to create DB systems using Logical Volume Manager as the storage management layer. OCI also offers a bare metal DB system consisting of a single bare metal server running Oracle Linux with locally attached NVMe storage. If this single node fails, users can simply launch another system and restore the database from current backups.
  2. 2-node Real Application Cluster (RAC) DB systems on virtual machines. Users also have the option to provision a 2-node RAC DB system, which runs on OCI. In this case, when provisioning the 2-node RAC DB system, the system assigns each node to a different fault domain. Oracle workloads achieve their highest performance running on Exadata Cloud Service, typically referred to as DB systems.

NoSQL offers on-demand throughput and storage-based provisioning. It supports JSON, tables, and key-value types with single-digit millisecond latencies. It provides a long list of services, including being fully managed, elastic, high-performance, and data model flexibility. Users can achieve enterprise security and manage various kinds of access. It's offers low operating costs and is developer friendly. It has various use cases such as mobile applications, IoT, real-time big data, and online advertising.

MySQL has various features, including:

  1. It is fully managed, developed, and supported by the MySQL team working within Oracle.
  2. MySQL Database Service with Heatwave is the only service available that enables database admins and app developers to run both OLTP and OLAP workloads directly from their MySQL Database. This eliminates the need for complex, time-consuming, and expensive data movement and integration with a separate analytics database available in Oracle Cloud Infrastructure.
  3. Users can host MySQL databases in the cloud, making it easy to test, apply, and roll back patches.
  4. It provides elastic compute, allowing users to increase or decrease resources as required. It can also expand storage capacity when data grows and distribute workloads dynamically.
  5. It provides high availability, increases uptime, and has zero data loss.