Jump to content

OCI Foundations - Database

From Smithnet Wiki

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

NoSQL

Retrieved from "https://www.smithnet.org.uk/wiki/index.php?title=OCI_Foundations_-_Database&oldid=416"