Databases on AWS (original) (raw)

Relational 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.

Traditional applications, enterprise resource planning (ERP), customer relationship management (CRM), ecommerce, generative AI use cases (such as chatbots with Retrieval Augmented Generation, similarity search, recommendation systems, and more)

Key-value 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.

High-traffic web applications, ecommerce systems, gaming applications, generative AI use cases (such as similarity search using DynamoDB zero-ETL integration with Amazon OpenSearch Service)

In-memory 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.

Caching, session management, gaming leaderboards, geospatial applications, generative AI use cases (such as chatbots with Retrieval Augmented Generation, semantic caching, recommendation systems, fraud detection, and more)

Document A document database is designed to store semistructured data as JSON-like documents. These databases help developers build and update applications quickly.

Content management, catalogs, user profiles, generative AI use cases (such as chatbots with Retrieval Augmented Generation, similarity search, recommendation systems, and more)

Graph 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.

Fraud detection, social networking, recommendation engines, generative AI use cases (such as GraphRAG, enhanced fraud detection, discovery of new answers, and more)

Wide column 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.

High-scale industrial apps for equipment maintenance, fleet management, and route optimization

Time series Time-series databases efficiently collect, synthesize, and derive insights from data that changes over time and with queries spanning time intervals.

Internet of Things (IoT) applications, DevOps, industrial telemetry