10-06 Other Database Services

Last updated Aug 17, 2023 Edit Source

#aws-service
Redshift is a petabyte-size data-warehouse.

• Data-warehouses are for Online Analytical Processing (OLAP).
• Data-warehouses can be expensive because they are keeping data “hot”
  • Meaning that we can run a very complex query and a large amount of data and get that data back very fast

#aws-service
ElastiCache is a managed database of the in-memory and caching open-source databases

• Redis or Memcached

Purpose

When you need to improve the performance of an application by adding a caching layer in-front of a web-server or database

#aws-service
Neptune is a managed graph database.

• Database is represented as interconnected nodes

Purpose

When you need to understand the connections between data

Example

Mapping Fraud Rings or Social Media Relationships

#aws-service
Amazon Timestreams is a fully managed time series database.

• Think of devices that send lots of data that are time-sensitive such as IoT devices.
• When you need to measure how things change over time.

#aws-service
Amazon Quantum Ledger Database is a fully managed ledger database that provides transparent, immutable and cryptographically variable transaction logs.

Purpose

When you need to record history of financial activities that can be trusted.

#aws-service
Database Migration Service (DMS) is a database migration service. You can migrate from:

• on-premise database to AWS
• from two databases in different or same AWS accounts using different SQL engines
• from an SQL to NoSQL databases