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
Best database to alleviate database load for data that is accessed often
Elasticache
Best database to process large sets of user profiles and social interactions
Amazon Neptune
Best database for NoSQL fast enough to handle millions of requests per second
Amazon DynamoDB
