Relational Database Services (RDS) and Dynamo DB

Question 1

Two main categories of databases?

Answer 1

1. Relational databases know as “SQL”

2. Non-relational databases known as “NoSQL”

Question 2

Amazon’s service for SQL databases?

Answer 2

Relational Database Service (RDS)

Question 3

Amazon’s service for NoSQL databases?

Answer 3

DynamoDB

Question 4

What is RDS?

Answer 4

Relational Database Service (RDS)
Simplified Definition:
RDS is a SQL database service that provides a wide range of SQL database options to selet from.

SQL Options Include:

1. Amazon Aurora
2. MySQL
3. MariaDB
4. PostgreSQL
5. Oracle (several Oracle options are available)
6. Microsoft SQL Servicer (several Microsoft options are available)

AWS Definition:
Amazon RDS is a web serivce that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, re-sizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching, and backups. It frees you to focus on your applications so you can give them the fast performance, high availability, security, and compatibility they need.

Question 5

What are the 6 RDS SQL database options?

Answer 5

1. Amazon Aurora
2. MySQL
3. MariaDB
4. PostgreSQL
5. Oracle (several Oracle options are available)
6. Microsoft SQL Servicer (several Microsoft options are available)

Question 6

What is DynamoDB?

Answer 6

Simplified Definition:
DynamoDB is a NoSQL database service. Unlike RDS, DynamoDB does NOT provide other NoSQL software options.

DynamoDB can replace (or is very similar to):

1. MongoDB
2. CassandraDB
3. Oracle NoSQL

AWS Definition:
Amazon DynamoDB is a fast and flexible NoSQL dabase service for all applications that need consistent, single-digit millisecond latency at any scale. It is a fully managed cloud databse and supports both document and key-value store models. Its flexible data model, reliable performance, and automatic scaling throughput capacity makes it a great fit for mobile, web, faming, ad tech, IoT, and many other applications.

Question 7

What are the differences between SQL and NoSQL?

Answer 7

1. Storage:
   - RDS (SQL) stores related data in tables (columns and rows)
   - DynamoDB (NoSQL) stores data in JSON-like, name-value documents. [Data is in between brackets in paragraph format]
2. Typical Use:
   - RDS (SQL) is typically used for very structured data, such as contact lists.
   - DynamoDB (NoSQL) is typically used for non-structured data such as catagloging documents. [movie data example]

Question 8

What are the key points/benefits of RDS?

Answer 8

1. For when you need a SQL database option.
2. Easy to set up, highly available, fault-tolerant, and scalable.
3. Used when data is clearly defined.
4. Common use cases include online stores and banking systems.

Question 9

What are the key points/benefits of DynamoDB?

Answer 9

1. For when you need a NoSQL database option.
2. Fast, highly scalable, and fully managed.
3. Used when data is fluid and can change.
4. Common use cases include social networks, web analytics.