Column Store
ELI5 — The Vibe Check
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 together. This sounds weird until you need to calculate the average age of 10 million users. Then it's pure magic because it only reads the age column.
Real Talk
A column store (columnar database) organizes data by columns rather than rows. This layout dramatically improves analytical query performance by minimizing I/O for queries that access only a subset of columns. It also enables superior compression ratios since similar data types are stored contiguously.
When You'll Hear This
"Column stores are built for analytics, not for updating individual records." / "Our reporting queries run 50x faster after migrating to a column store."
Related Terms
Columnar Storage
Columnar storage saves data column by column instead of row by row. All the ages together, all the names together, all the emails together.
Data Warehouse
A data warehouse is where all your company's data goes to be analyzed.
OLAP
OLAP is all about analyzing huge amounts of data to answer business questions. 'What were total sales by region last quarter?' That's an OLAP query.
Wide Column Store
A wide column store is like a spreadsheet where every row can have completely different columns, and there can be billions of them.