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

Self-Driving:

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

Self-Repairing:

• Detects and corrects issues including hardware, software, and human errors, helping to maintain high availability and protect against data loss

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
• In-memory cache
• Enables OLTP and OLAP from the same database; no need for a separate OLAP database
• Exclusive to OCI

NoSQL Database

• Fully Managed
• Elastic
• High Performance
• Data model flexibility
• Access Control
• Low cost
• Developer freindly APIs
• Always available
• Hybrid cloud/on-premise

Uses cases: many where high volumes of data are involved