Migrate Oracle Database to AWS

Introduction

This white paper provides a brief background on databases, database offerings from Amazon Web Services (AWS). It then highlights Oracle Database offerings in AWS and their fundamental differences. This document also covers on how to select the destination database from AWS offerings and focusing mainly on Oracle. In the later part, this document focus on the migration techniques that can be employed to migrate Oracle databases to Amazon Web Services.

Background

Database is a persistent Data Store. A data store is simply a collection of data items. A data item can be very basic or a complex structure like table. Application processes interact with these data stores to perform read/write operations on the data items. As multiple application processes interact with the data store at the same time, consistency models play a critical role in this.

Databases typically fall under two consistency models — ACID and BASE.

ACID abbreviates to Atomic, Consistent, Isolate and Durable. All relational databases are typically classified as ACID models. BASE abbreviates to Basic Availability, Soft-State and Eventual Consistency. All NoSQL databases are typically classified as BASE models. The major difference between these two models is the consistency and availability.

AWS — Database offerings

Amazon Web Services has a large collection of databases than any other public cloud…