Cloud Database Services Cheat Sheet

Updated 2026-05-25

Next Topic: Cloud Deployment Archetypes Cheat Sheet

Cloud database services represent fully managed or serverless database platforms provided by cloud vendors like AWS, Azure, and Google Cloud, eliminating the operational burden of provisioning, patching, and scaling infrastructure. These services enable organizations to focus on application development rather than database administration, offering built-in features like automated backups, high availability, and global distribution. In 2026, the landscape has expanded beyond traditional relational and NoSQL models to include purpose-built vector databases for AI workloads, distributed NewSQL systems offering global ACID transactions, and HTAP databases unifying transactional and analytical processing in a single cluster. A key design consideration: managed services abstract complexity but may limit low-level control—choosing the right service requires balancing flexibility, cost, and operational simplicity for your specific workload characteristics.

What This Cheat Sheet Covers

This topic spans 13 focused tables and 113 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Database Service ModelsTable 2: Major Cloud Database EnginesTable 3: High Availability ConfigurationsTable 4: Scaling StrategiesTable 5: Backup and Recovery StrategiesTable 6: Performance OptimizationTable 7: Security and Access ControlTable 8: Multi-Region DeploymentTable 9: Database Migration StrategiesTable 10: Monitoring and ObservabilityTable 11: Storage and Cost OptimizationTable 12: Consistency Models and Trade-offsTable 13: Vector Database and AI Search Services

Table 1: Database Service Models

Choosing the right database model is the single most consequential architectural decision in a cloud system. Matching your data structure and access patterns to the right model—relational, document, key-value, vector, or time-series—determines throughput, consistency, and cost at every scale.

Type	Example	Description
Relational (SQL)	`AWS RDS PostgreSQL` `Azure SQL Database`	• Fully managed SQL databases with ACID guarantees, schema enforcement, and support for complex joins • best for transactional systems, structured data, and applications requiring strong consistency.
NoSQL Document	`MongoDB Atlas` `DynamoDB` `Cosmos DB`	• Schema-flexible document stores optimized for hierarchical data and rapid development • ideal for content management, user profiles, and applications with evolving data models.
NoSQL Key-Value	`DynamoDB` `Azure Cosmos DB`	• Ultra-fast lookups by primary key with single-digit millisecond latency • designed for session stores, caching layers, and high-throughput read/write operations at massive scale.
In-Memory	`Amazon MemoryDB` `ElastiCache Serverless` `Azure Managed Redis`	• Entire dataset stored in RAM for microsecond reads and single-digit millisecond writes • durable in-memory databases (MemoryDB) add multi-AZ transaction logs; pure caches (ElastiCache) are for ephemeral acceleration.
Vector	`pgvector` `Pinecone` `OpenSearch k-NN`	• Store high-dimensional embeddings alongside structured data for semantic similarity search • essential for RAG pipelines, semantic search, and recommendation systems in AI applications; supported natively via pgvector in most cloud PostgreSQL services.
Columnar/Analytical	`BigQuery` `Snowflake` `Redshift`	• Column-oriented storage for analytical queries across billions of rows • designed for data warehousing, business intelligence, and OLAP workloads with aggregations over large datasets.

Table 1: Database Service Models

Type	Example	Description
Relational (SQL)	`AWS RDS PostgreSQL` `Azure SQL Database`	• Fully managed SQL databases with ACID guarantees, schema enforcement, and support for complex joins • best for transactional systems, structured data, and applications requiring strong consistency.
NoSQL Document	`MongoDB Atlas` `DynamoDB` `Cosmos DB`	• Schema-flexible document stores optimized for hierarchical data and rapid development • ideal for content management, user profiles, and applications with evolving data models.
NoSQL Key-Value	`DynamoDB` `Azure Cosmos DB`	• Ultra-fast lookups by primary key with single-digit millisecond latency • designed for session stores, caching layers, and high-throughput read/write operations at massive scale.
In-Memory	`Amazon MemoryDB` `ElastiCache Serverless` `Azure Managed Redis`	• Entire dataset stored in RAM for microsecond reads and single-digit millisecond writes • durable in-memory databases (MemoryDB) add multi-AZ transaction logs; pure caches (ElastiCache) are for ephemeral acceleration.
Vector	`pgvector` `Pinecone` `OpenSearch k-NN`	• Store high-dimensional embeddings alongside structured data for semantic similarity search • essential for RAG pipelines, semantic search, and recommendation systems in AI applications; supported natively via pgvector in most cloud PostgreSQL services.
Columnar/Analytical	`BigQuery` `Snowflake` `Redshift`	• Column-oriented storage for analytical queries across billions of rows • designed for data warehousing, business intelligence, and OLAP workloads with aggregations over large datasets.