Chapter 5, Problem 19MML

Explanation of Solution

List of AWS database offering:

The below are the list of AWS database offerings:

• Amazon Aurora
  • It is a type of relational database used for transactional applications.
• Amazon RDS
  • It is a type of relational database used for transactional applications.
• Amazon Dynamo DB
  • It is a type of non-relational database used for internet scaling applications.
  • It is server less NoSQL database.
• Amazon Redshift
  • It is a data warehouse used for data analytics.
• Amazon ElastiCache
  • It is a type of in-memory data store used in caching the data and process real-time workloads.
• Amazon Neptune
  • A Highly connected data can be build using the Graph database.

Difference among the Amazon’s RDS, DynamoDB, ElastiCache and Redshift services:

Amazon’s RDS	Amazon’s DynamoDB	Amazon’s ElastiCache	Amazon’s Redshift
It is a managed Relational database.	It is NoSQL database.	It is an in-memory data store.	It is a data warehouse.
Provides service with easy setup. It is easy to operate and could be scaled in the cloud.	It is fast and flexible that provides a NoSQL database service for the application in a consistent and single millisecond latency at required scale.	It could be deployed, operated and scaled effortlessly operated in an open source compatible in memory data store.	It is simple, fast and cost effective fully managed data warehouse to manage the data using the SQL and existing Business Intelligence tools.
It is used in OLTP (Online Transaction Processing) systems.	It can be used in the system that requires millisecond read latency at required scale.	It can be used in the system that requires sub- millisecond response time.	It is used for the OLAP(OnLine Analytical Processing) systems.
It supports read replicas across regions and gets backup at Amazon S3.	It uses streams to replicate the data to a table and to another table and does not require any backup.	Replicas are provided based on the read scaling and gets backup automatically.	Data gets replicated automatically and gets backup in Amazon S3...