Wide Column Store
ELI5 — The Vibe Check
A wide column store is like a spreadsheet where every row can have completely different columns, and there can be billions of them. Row 1 might have 3 columns, row 2 might have 300. It's designed for massive scale where you need to look up data by a key super fast.
Real Talk
A wide column store organizes data into rows and dynamic column families, where each row can have a different set of columns. Data is stored sorted by row key and column key for efficient range scans. Examples include Cassandra and HBase. They excel at high-throughput reads and writes across petabyte-scale datasets.
When You'll Hear This
"Wide column stores work great for sparse data where most fields are empty." / "Cassandra's wide column model lets us add new fields without migrations."
Related Terms
Cassandra
Cassandra is like a massive library system spread across every city in the world.
Column Store
Instead of storing all of a row's data together (name, age, email), a column store keeps all the names together, all the ages together, and all the emails...
Distributed Database
A distributed database spreads your data across multiple computers that work together like a hive mind. If one server dies, the others pick up the slack.
Key-Value Store
A key-value store is the simplest database possible. You give it a name (key) and some data (value), and it remembers it.