Comparing DB Options

Question 1

When should you use Database on EC2?

Answer 1

When you need:
Ultimate control over the database
Prefer a DB not supported in RDS

Question 2

When should you consider RDS?

Answer 2

When you need:
A traditional relational database for OLTP
Your data is well formed and structured

Question 3

When should you consider DynamoDB?

Answer 3

When you need:
A data store for name/value pair data
a store for unpredictable data structure
In-memory performance with persistence

Question 4

When should you consider Redshift?

Answer 4

When you need:
Storage for massive amounts of data
Processing for primarily OLAP workloads

Question 5

When should you consider Neptune?

Answer 5

When relationships between objects is a major portion of data value. This is where graph DBs excel.

Question 6

When should you consider using Elasticache?

Answer 6

When you need:
Fast temporary storage for small amounts of data
Processing for highly volatile data

Question 7

Which database approaches would be best for storing and analyzing the complex interpersonal relationships of people in organized crime?

Answer 7

Graph databases such as:
Neptune
Database on EC2, such as SAP HANA or Neo4j