09 - RDS 101 Flashcards
1
Q
What is a Relational Database?
A
- Relational Database (SQL) - consists of tables, made of rows and columns
- Amazon Aurora DB
- Non-Relational Databases (No SQL) - consists of collections (tables), documents (rows), key value pairs (fields)
- Amazon Dynamo DB (JSON / NoSQL)
2
Q
Relational Database Types
A
Relational Database Types
- SQL Server
- Oracle
- MySQL Server
- PostgresSQL
- Amazon Aurora
- Maria DB
3
Q
Non-Relational Databases
A
Non-Relational Databases
- Amazon Dynamo DB
4
Q
OLTP vs. OLAP
A
OLTP vs. OLAP
- Definitions:
- OLTP (Online Transaction Processing) (RDS)
- OLAP (Online Analytics Processing) (RedShift)
- Differences:
- Focuses on the type of queries run
- OLTP
- Example: Pull up a single row of data a single time (frequent)
- OLAP
- Example: Complex analysis of data that require multiple queries to complete
- Have a copy of production database imported into OLAP DB (infrequent)
5
Q
OLTP - OLAP
Database List
A
OLTP (Online Transaction Processing) (RDS)
- SQL
- MySQL
- MySQL Port: 3306 (required for exam - same as Aurura)
- PostgreSQL
- Oracle
- Aurora
- MariaDB
- MySQL
- NoSQL
- DynamoDB
OLAP - Online Analytics Processing
- RedShift
6
Q
Caching Solution Overview
A
ElastiCache
- Is In-Memory Cache - used to relieve database of load
- Is a web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud
- It has two open source in-memory caching engines
- Types of Caching Engines for Elasticache
- Memcached
- Object caching system
- Elasticache is protocol compliant with Memcached
- Redis
- Open source in memory key value store that supports data structures such as sorted sets and lists
- ElastiCache supports Master / Slave replication and multi-AZ
- Memcached
7
Q
Elasticache - in Memory Caching
A
Elasticache - in Memory Caching
- MemcaheD
- Redis
