OCI Foundations - Database

From Smithnet Wiki
Jump to navigation Jump to search

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
  • 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

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