Database Families

Relational databases store data in structured tables with rows and columns, enforce ACID transactions, and use SQL for querying. With decades of maturity, battle-tested tooling, and strong consistency guarantees, they remain the default choice for most application workloads.

Key-value stores provide O(1) lookups by mapping unique keys to values, offering the simplest and fastest data access pattern. Redis excels as an in-memory data structure server, while DynamoDB provides a fully managed, serverless key-value store with single-digit-millisecond latency at any scale.

Document stores persist data as schema-flexible JSON-like documents, enabling natural mapping between application objects and database records. MongoDB, the leading document database, combines flexible schemas with rich querying, aggregation pipelines, and horizontal scaling via sharding.

Wide-column stores organize data by partition key and clustering columns, enabling fast writes and efficient range scans over massive datasets. Cassandra, Bigtable, and HBase dominate time-series, event logging, and IoT workloads where write throughput and horizontal scalability matter most.

Search engines like Elasticsearch and OpenSearch use inverted indexes to provide full-text search, relevance scoring, faceted filtering, and near-real-time analytics over large document collections. Built on Apache Lucene, they power search experiences from code search to log analysis.

Vector databases store high-dimensional embeddings and perform approximate nearest neighbor (ANN) search to find semantically similar items. They power AI-driven features like semantic search, recommendation engines, and retrieval-augmented generation (RAG) by finding items that are close in meaning, not just matching on keywords.

NewSQL databases provide the SQL interface and ACID transactions of relational databases with the horizontal scalability of NoSQL systems. Using distributed consensus protocols like Raft and Paxos, they achieve serializable isolation across distributed nodes, bridging the gap between consistency and scale.

Object storage provides a flat namespace of buckets and keys for storing unstructured data (images, videos, backups, logs) at virtually unlimited scale. Amazon S3 and Google Cloud Storage offer 11 nines of durability, storage tiering for cost optimization, and event-driven integrations that make them the backbone of modern data architectures.