Database Flashcards
RDS
Relational database service.
A service that makes it easy to launch and manage relational databases.
Amazon Aurora
A relational databse compatible with MySQL and PostgreSQL that was created by AWS>
Scales automatically providing durability and high availablitiy
Amazon DynamoDB
Fully managed NOSQL key-value and document.
Scales automatically to massive workloads with fast performance
Amazon DocumentDB
a fully managed document database that supports MongoDB
Amazon Elasticache
A fully managed in-memory datastore compatible with Redis or Memcached
Data can be lost
Offers high performance and low latency
Amazon Neptune
a fully managed graph database that supports highly connected data sets.
Supports highly connected datasets like social media networks.
DMS
Database migration Service.
Helps migrate databases to or within AWS
SMS
Server migration Service.
Allows you to migrate on-premises servers to AWS
Snowcone
Smallest of data transfer service.
8Terabytes of usable storage
Offline shipping
Online with data-sync
Snowball
Petabyte-scale data transport solution
Cheaper than internet transfer
Transfer data in and out
Snowball edge
Same as snowball plus supports EC2 and Lambda
Snowmobile
Multi-petabyte or exabyte scale.
Data loaded to S3
Securely transported
Largest member of transport family
DataSync
Allows online data transfer from on-premises to AWS storage services like S3 or EFS.
Replicate data cross-region or cross-account.
Copy data over direct connect or the internet.
Amazon Redshift
Scalable data warehouse solution.
- Data consolidation - consolidate multiple data sources for reporting.
- relational databases - run the database that doesn’t require realtime transaction processing ( insert, update, and delete)
Analytics
The act of querying or processing your data
Athena
A query service for Amazon S3.
Pay Per query
Helps query historical data stored in S3
Glue
Prepares your data for analytics
ETL (Extract, transform, and load) service.
Prepare and load data
Helps understand your data
Kinesis
Allow you to analyze data and video streams in real time.
EMR
Elastic mapreduce (EMR) Helps process large amounts of data. Process big data Analyze data use hadoop Works with big data frameworks.