| Database |
type of data |
Workload |
Size |
Performance |
Operational overhead |
| RDS DBs |
Structured |
Relational / OLTP / simple OLAP |
Low TB range |
Mid-to-high throughput, low latency |
Moderate |
| Aurora MySQL |
Structured |
Relational / OLTP / simple OLAP |
Mid TB range |
High throughput, low latency |
Low-to-moderate |
| Aurora PostgreSQL |
Sturctured |
Relational /OLTP / simple OLAP |
Mid TB range |
High throughput, low latency |
Low-to-moderate |
| Redshift |
Sturctured / Semi-structure |
Relational /OLAP / DW |
PB range |
Mid-to-high latency |
Moderate |
| DynamoDB |
Semi-structure |
Non-relational / Key-value / OLTP / Document store |
High TB range |
Ultra-high throughput, low latency, ultra-low latency with DAX |
Low |
| ElatiCache |
Semi-structure / Unstructured |
Non-relational / In-memory caching / key-value |
Low TB range |
High throughput, ultra-low-latency |
Low |
| Neptune |
Graph data |
Highly connected graph datasets |
Mid TB range |
High throughput, low latency |
Low |
