Please enable JavaScript.
Coggle requires JavaScript to display documents.
🌐 7.AWS Databases - Coggle Diagram
🌐 7.AWS Databases
🚀 Amazon Aurora
- AWS-Optimized DB: Supports PostgreSQL & MySQL.
- Performance: 5x faster than MySQL, 3x faster than Postgres.
- Storage Scaling: Grows automatically up to 128 TB.
- Cost: 20% more expensive than RDS but more efficient.
- Aurora Serverless: Auto-scales, pay-per-second.
-
-
📈 RDS Deployment Options
- Read Replicas: Scale reads (up to 15).
- Multi-AZ: Automatic failover to standby.
- Multi-Region: Disaster recovery, global performance.
-
🔍 Amazon Athena
- Serverless SQL: Query S3 directly.
- Formats Supported: CSV, JSON, ORC, Parquet.
-
📒 Amazon QLDB
- Ledger DB: Immutable, cryptographically verifiable.
- Use Case: Financial transaction logs.
-
-
-
🗄️ Types of Databases
- Relational Databases (SQL)
- Structure: Tables, rows, columns (like Excel).
-
-
- Schema-less: Flexible data models (JSON, key-value, document).
- Scalable: Distributed clusters.
- High Performance: Optimized for specific use cases.
- Examples: DynamoDB, ElastiCache, DocumentDB.
-
⚡ Amazon ElastiCache
- In-Memory Cache: Supports Redis & Memcached.
- Benefits: High-speed, reduces database load.
-
📉 Amazon QuickSight
- BI Tool: Dashboards and reporting.
- Data Sources: RDS, Redshift, Athena, S3.
🗃️ Amazon DocumentDB
- MongoDB-Compatible: Fully managed JSON document DB.
- Auto-Scaling: Increments of 10GB.
🧩 Amazon Neptune
- Graph Database: Optimized for highly connected datasets (social networks, fraud detection).
- Replication: Across 3 AZs.
⏳ Amazon Timestream
- Time-Series DB: Serverless, scalable.
- Purpose: IoT and operational data analytics.
🔄 AWS Glue (ETL)
- Extract, Transform, Load: Prepare data for analytics.
- Serverless: No infrastructure management.
-