Database Flashcards
Databases
Databases allow us to collect, store, retrieve, sort, graph, and manipulate data.
A database is an organized collection of various forms of data.
Relational Databases
RDS
Aurora
NoSQL Databases
DynamoDB
Document Databases
DocumentDB
In-Memory Database
ElastiCache
Graph Database
Neptune
Amazon Relational Database Service (RDS)
Supports popular database engines (MySQL, Aurora, PostgreSQL, Microsoft SQL Server, MariaDB, Oracle)
Offers high availability and fault tolerance using Multi-AZ deployment option
AWS manages the database with automatic software patching, automated backups, operating system maintenance, and more.
RDS is only for relational databases. Don’t forget the supported database engines: Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server
Amazon Aurora
Aurora is a relational database compatible with MySQL and PostgreSQL that was created by AWS.
5x faster than normal MySQL and 3x faster than normal PostgreSQL
Managed by RDS
Scales automatically while providing durability and high availability
Don’t forget Aurora only supports PostgreSQL and MySQL.
Amazon DynamoDB
DynamoDB is a fully managed NoSQL key-value and document database.
Fully managed and serverless.
Scales automatically to massive workloads with fast performance.
Going into the exam, don’t forget DynamoDB is a NoSQL database.
Amazon DocumentDB
DocumentDB is a fully managed document database that supports MongoDB.
Fully managed and serverless
Non-relational
Scales automatically to massive workloads with fast performance
Keep in mind that DocumentDB supports MongoDB.
Amazon ElastiCache
ElastiCache is a fully managed in-memory datastore compatible with Redis or Memcached.
Data can be lost.
Offers high performance and low latency.
In-memory datastore
Keep in mind that ElastiCache is an in-memory datastore
Amazon Neptune
Neptune is a fully managed graph database that supports highly connected datasets.
Graph database service
Supports highly connected datasets like social media networks
Fully managed and serverless
Fast and reliable