Databases & Analytics Flashcards
What is AWS Aurora
Aurora is a relational database proprietary technology from AWS. It is “AWS cloud optimised” and claim 5x performance over MySQL on RDS.
3 RDS Deployment Options
- Read replicas
- Multi-AZ
- Multi-Region (Read Replicas)
What is ElastiCache?
The same way RDS is to managed Relational Databases… ElastiCache is to Redis or Memcache
What is a cache?
Caches are in-memory databases with high-performance, low latency
What is DynamoDB?
DynamoDB is a fully-manged, highly-available, NoSQL database
What type of data does DynamoDB hold?
DynamoDB is a key/value database
What is DynamoDB Accelerator (DAX)?
A fully managed in-memory cache for DynamoDB with a 10x performance improvement when accessing your DynamoDB tables
What are DynamoDB Global Tables?
They make a DynamoDB table accessible with low latency in multiple regions, using Active-Active replication (read/write in any region).
What is Redshift?
Redshift is based on PosgreSQL, but it’s not used for OLTP (Online Transaction Processing), it’s OLAP (Online Analytical Processing). It uses columnar storage of data, instead of row based.
What is EMR?
Elastic MapReduce - helps create Hadoop clusters to analyse and process vast amounts of data.
What is Athena?
Serverless query service to perform analytics against S3 objects using SQL.
What is Quicksight?
A serverless machine learning powered business intelligence service to create interactive dashboards
What is DocumentDB?
The AWS implementation of MongoDB, which is fully-managed, highly-available and automatically scalable
What is Neptune?
A fully managed graph database
What QLDB?
A “Quantum Ledger Database”, a fully-managed, non-decentralised blockchain
