OCI Foundations - Database

From Smithnet Wiki
Revision as of 06:48, 22 July 2023 by NickPGSmith (talk | contribs) (Created page with "== 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 Exada...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

NoSQL

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