Key-Value, Wide-Column, Graph, and Time-Series Stores

NoSQL is a broad family, not one data model. Key-value stores optimize lookup by key; wide-column stores distribute large sparse datasets across partition keys; graph databases represent relationships and traversals; time-series stores optimize timestamped measurements and retention/downsampling.

Each model has a preferred query shape. A key-value store is excellent for sessionId → session, but poor for arbitrary joins unless extra structures are maintained. A graph store can simplify multi-hop relationship queries, while a relational schema may remain better for conventional transactional records.

Before selecting a specialized database, define partition keys, query patterns, retention, consistency, operational expertise, and migration cost. Specialized stores can deliver substantial benefits, but they increase the number of systems to secure, monitor, back up, and recover.

Key Takeaways
  • Choose a database for dominant access patterns.
  • NoSQL does not mean schema-free or automatically scalable.
  • Every additional datastore adds operational and recovery responsibilities.
Knowledge Check

What is a common responsibility of a cache-aside application?