Database_
#aws #database
Types
- RDBMS: RDS, Aurora, greate for joins
- NoSQL: DynamoDB, ElasticCache, Neptune (graphs), DocumentDB (MongoDB), Keyspace (Cassandra)
- Object Store: S3 / Glacier (backup/archives)
- Data warehouse (SQL Analytic /BI): Redshift, Athena, EMR
- Search: OpenSearch (JSON)
- Graph: Neptune
- Ledger: Amazon Quantum Ledger database
- Timeseries: Amazon Timestream
Use cases
RDS: Store relational datasets, SQL queries, transactions Aurora: Same like RDS, but less maintenance, flexibility, more performance, more features. ElasticCache: Key/value store, frequent read, cache result, data session, no sql. DynamoDB: Rapid evolve schema, serverless (small doc, max 400kb), distributes serverless cache S3: Static file, web hosting, key store for big files DocumentDB: noSQL mongoDB Nepture: Graph database, recommendation engine, social networking, billion relationship, knowledge graphs Wikipedia Keyspace (Apache Cassandra): IoT device info, time-series data QLDB: book for recording financial transactions, history of all the changes over time, immutable like blockchain, no decentralization component, in accordance with financial regulation rules. Timestream: IOT apps, real time analytic, operational applications