#9 DataBase

#9 DataBase

1. Relational DB

   • RDS - Relational Database Service
     • SQL Managed
     • Suited for OLTP workloads
     • Deployments
       • Multi-AZ
         • High Availability
       • Replicas
         • Scalability
       • Multi-Region
         • Disaster Recovery
   • Aurora
     • AWS Service not open source
     • Supports
       • PostgreSQL
         • 3x faster than RDS
       • MySQL
         • 5x faster than RDS
     • AWS Cloud Optimized
   • RedShift
     • Analytical Processing
     • Columnar
     • Pay as you go
     • NOT used for OLTP
     • DataWarehouse
   • Athena
     • Serverless
     • SQL Capability
     • Used for query in S3
     • pay for every run

2. NoSQL

   • DynamoDB
     • Hightly Available - 3 AZs
     • Serverless
     • Scales millions requests per second
     • Low latency
     • DAX (Cache)
   • EMR - Elastic Map Reduce
     • Hadoop
     • BigData on Cloud
   • DocumentDB
     • Aurora version for MongoDB

3. Others

   • ElastiCache
     • Cache
   • QuickSight
     • Serverless Dashboard
     • Graphs
   • Neptune
     • Graph Database
       • Complex graphs for fraud detection
   • QLDB
     • Ledger Financial
     • Central Database
   • DMS
     • Data Migration
   • Glue
     • ETL - Extract Transform Load
     • Prepare Data for Analytics
   • Managed BlockChain
     • Decentralized
     • Blockchain
     • Hyperledger Fabric and Ethereum