Databases Flashcards
Relational Databases
- Amazon Aurora
- Amazon RDS
- Amazon Redshift
Use case for relational databases
- Traditional applications
- CRM
- Enterprise Resource Planning
- E-Commerce
A mySQL and PostgresSQL compatible database built for the cloud
Amazon Aurora
Easily set up, use, and scale multiple database engines
Amazon RDS
A cloud data warehouse
Amazon Redshift
Use case for Key-Value Databases
- High traffic web applications, E-Commerce, and gaming
Key-Value Databases
- Amazon DynamoDB
Fast and flexible NoSQL database for any scale
Amazon DynamoDB
Use case for In-Memory Databases
- Caching
- Session management
- Gaming leaderboards
- Geospatial applications
In-Memory Databases
- Amazon ElastiCache
Managed, in-memory data store service for Redis, and Memcached
Amazon ElastiCache
Use case for Document Database
- Content management
- Catalogues
- User profiles
Document Database
- Amazon DocumentDB
MongoDB compatible fast, scalable, highly available document database
Amazon DocumentDB
Amazon RDS
- Easy to set up
- Fully managed
- Scalable
- Automated backups
- Automatic host replacement
- Cost effective
DynamoDB
- NoSQL (not typically SQL, potentially “sql-like”)
- Key-value document database
- Single-digit millisecond performance
- Fully managed
- multiple regions
- Built in security, backup, and restore
- Can handle > 20 million requests per second
- works with serverless
- works great for mobile app data
Amazon Relational Database Services (RDS)
is a service that makes it easy to launch and manage relational databases.
- Supports popular database engines
- Offers high availability and fault tolerance using Multi-AZ deployment
- AWS managed DB
- Read replicas across regions for performance and durability
Amazon Aurora
Relational database compatible with MySQL and PostgreSQL
Amazon DynamoDB
is a fully managed NoSQL key-value and document database.
- fully managed and serverless
- non-relational
- scales automatically to workload
Amazon DocumentDB
is a fully managed document database that supports MongoDB.
- non-relational
-
Amazon Elasticache
is a fully managed in-memory datastore compatible with Redis or Memcached
- data can be lost
- high performance and low latency
Amazon Neptune
is a fully managed graph database that supports highly connected datasets.
- supports highly connected datasets like social media networks
Best database to migrate an on-premises oracle database to the cloud
Amazon RDS
Best database to migrate an on-premises postgreSQL database to the cloud
Amazon RDS, Amazon Aurora
