OCI Foundations - Database

Introduction

Base Database Service:

• Create on VM with block storage
• Provisioning service

Exadata Database Service on dedicated infrastructure

• For Oracle databases
• Comanaged: customer manages DB, Oracle manages infrastructure

Autonomous Database on Shared and dedicated Exadata Infrastrure:

• Self manaaging and repairing
• Shared or dedicated infrastructure

Cloud@Customer:

• At customer datacentre
• Exadata Database Service or Autonomous Database on Exadata

Autonomus DB

Uses machine learning to implement tuning, backups, patching/upgrades

Shared or Dedicated use of Exadata hardware.

• Autonomous Transaction Processing
• Autonomous Data Warehouse

Autonomous JSON Database:

• Designed for noSQL applications
• APEX Service

MySQL Database Service

Host MySQL in the Cloud:

• Standalone, or
• High Availablty: 3 nodes providing auto failover to a secondary instance

MySQL with HeatWave

• Order of magnitude performance improvements
• Enables OLTP and OLAP from the same database
• Excludive to OCI