Databases on AWS
Database services
Relational Database
Relational databases store data with predefined schemas and relationships between them. These databases are designed to support ACID transactions, and maintain referential integrity and strong data consistency.
Amazon Aurora
MySQL and PostgreSQL-compatible relational database built for the cloud. Performance and availability of commercial-grade databases at 1/10th the cost
Amazon Relational Database Service (RDS)
Set up, operate, and scale a relational database in the cloud with just a few clicks
Amazon Redshift
The most popular and fastest cloud data warehouse
Key-value Database
Key-value databases are optimized for common access patterns, typically to store and retrieve large volumes of data. These databases deliver quick response times, even in extreme volumes of concurrent requests.
Amazon DynamoDB
Fast and flexible NoSQL database service for any scale
In-memory Database
In-memory databases are used for applications that require real-time access to data. By storing data directly in memory, these databases deliver microsecond latency to applications for whom millisecond latency is not enough.
Amazon ElastiCache for Memcached
Managed, Memcached-compatible, in-memory store. Sub-millisecond latency to power real-time applications
Amazon ElastiCache for Redis
Redis compatible in-memory data store built for the cloud. Power real-time applications with sub-millisecond latency
Document Database
A document database is designed to store semistructured data as JSON-like documents. These databases help developers build and update applications quickly.
Amazon DocumentDB (with MongoDB compatibility)
Fast, scalable, highly available MongoDB-compatible database service
Wide Column Database
A wide column store is a type of NoSQL database. It uses tables, rows, and columns, but unlike a relational database, the names and format of the columns can vary from row to row in the same table.
Amazon Keyspaces (for Apache Cassandra)
Managed Cassandra-compatible database
Graph Database
Graph databases are for applications that need to navigate and query millions of relationships between highly connected graph datasets with millisecond latency at large scale.
Amazon Neptune
Fast, reliable graph database built for the cloud
Time Series Database
Time-series databases efficiently collect, synthesize, and derive insights from data that changes over time and with queries spanning time intervals.
Amazon Timestream
Fast, scalable, fully managed time series database
Ledger Database
Ledger databases provide a centralized and trusted authority to maintain a scalable, immutable, and cryptographically verifiable record of transactions for every application.
Amazon Quantum Ledger Database (QLDB)
Fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log. Owned by a central trusted authorit
Database services
| Database Type | Use Cases | AWS Service |
|---|---|---|
| Relational | Traditional applications, ERP, CRM, e-commerce | Amazon Aurora | Amazon RDS | Amazon Redshift |
| Key-value | High-traffic web apps, e-commerce systems, gaming applications | Amazon DynamoDB |
| In-memory | Caching, session management, gaming leaderboards, geospatial applications | Amazon ElastiCache for Memcached | Amazon ElastiCache for Redis |
| Document | Content management, catalogs, user profiles | Amazon DocumentDB (with MongoDB compatibility) |
| Wide-column | High scale industrial apps for equipment maintenance, fleet management, and route optimization | Amazon Keyspaces (for Apache Cassandra) |
| Graph | Fraud detection, social networking, recommendation engines | Amazon Neptune |
| Time series | IoT applications, DevOps, industrial telemetry |
Amazon Timestream |
| Ledger | Systems of record, supply chain, registrations, banking transactions | Amazon Quantum Ledger Database |
Use cases
-
Internet scale applications
-
Real-time applications
-
Open source applications
-
Enterprise applications
-
Internet scale applications
-
Internet scale applications
Build globally distributed and internet-scale applications that handle millions of requests per second over hundreds of terabytes of data. These databases automatically scale up and down to accommodate your spiky workloads, and you only pay for the resources you use to optimize cost savings. No need to maintain servers, upgrades, or backups, and your applications have automated high availability.
AWS Database services
Use case resources
-
Real-time applications
-
Real-time applications
Real-Time applications such as caching, session stores, gaming leaderboards, ride-hailing, ad-targeting, and real-time analytics need microsecond latency and high throughput to support millions of requests per second. Developers have traditionally relied on specialized hardware, proprietary in-memory databases, and workarounds such as disk-based databases combined with data reduction techniques to manage data for real-time applications. AWS offers high performance in-memory database services that are purpose-built to power your real-time applications.
AWS Database services
Use case resources
-
Open source applications
-
Migrate to fully managed open source databases
Customers prefer open source databases for their low cost, community-backed development and support, and large ecosystems of tools and extensions. However, they can be difficult and time-consuming to manage in production. AWS database services make it easy to deploy open source databases in the cloud with performance, scalability, and availability.
AWS Database services
Use case resources
-
Enterprise applications
-
Enterprise applications
Enterprise applications are used to manage core business processes, such as sales, billing, customer service, human resources, and line-of-business processes, such as a reservation system at a hotel chain or a risk management system at an insurance company. These applications need databases that are fast, scalable, secure, available, and reliable. Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. It provides the security, availability, and reliability of commercial databases at 1/10th the cost. Amazon Aurora is fully managed so you no longer need to worry about database management tasks such as server provisioning, software patching, setup, configuration, or backups.
AWS Database services
Use case resources
Amazon Aurora allowed us to increase our database connections and greatly improve our scalability, response times, and CPU utilization. Our customers’ experience improved in a short time so we’re looking into Aurora for additional applications.
