Type of database | Managed relational (SQL) | NoSQL |
Features | Multiple DB engines | Single-digit millisecond performance |
Storage Size | Varies by engine | Virtually any size |
Number of tables | Depends on engine | 256 |
Performance | Depends on storage type | Single-digit millisecond read/write performance |
Availability & Durability | Multi-AZ, automatic host replacement | Multi-AZ, automatic scale capacity |
Backups | Point-in-time recovery | Continuous backups, on-demand backups and restore |
Scalability | Auto-scaling, read replicas | Horizontal scaling, instant accommodation of workloads |
Security | Virtual network, firewall, SSL | Encryption at rest using KMS |
Encryption | Encryption using KMS | Encryption at rest using KMS |
Maintenance | Automatic software patching, backups, host replacement | Automatic software patching, backups |
Cost | Based on instance type, storage, data transfer | Based on provisioned throughput and storage |
Use cases | Transactional systems, BI, content management, e-commerce, gaming | High-scale, low-latency, IoT, gaming, ad-tech, e-commerce, mobile and web apps, real-time data processing and analytics |