Databases on AWS

Question 1

What is a relational database?

Answer 1

A relational database organizes data into tables. Data in one table can be linked to data in other tables to create relationships—hence, the relational part of the name.

Question 2

What is a relational database management system

Answer 2

A relational database management system (RDBMS) lets you create, update, and administer a relational database. Here are some common examples of relational database management systems:

MySQL

PostgresQL

Oracle

SQL server

Amazon Aurora

Question 3

How do you communicate with RDMS?

Answer 3

SQL

Question 4

Benefits of Relational Database?

Answer 4

Joins

Reduced Redundancy

Accuracy

Question 5

Describe some supported Amazon RDS engines

Answer 5

Commercial: Oracle, SQL Server

Open Source: MySQL, PostgreSQL, MariaDB

Cloud Native: Amazon Auror

Question 6

What is Amazon Dynamo DB?

Answer 6

Amazon Dynamo DB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability.

Serverless database

Data is stored into items

Items stored into attributes. An item is a group of attributes, similar to a ‘row’

Question 7

Choosing the right DB

Answer 7

Relational (traditional app) - Amazon RDS, Aurora, Redshift

Key-value - High traffic web apps, e-commerce systems, gaming - Dynamo DB

In-memory - Caching, leaderboards - Elasticache

Document - Document DB

Wide column - Keyspace

Graph - Social networking - Neptune

Time series - Timestream

Ledger - System of record, banking - QLDB