Wide-column store
A wide-column store is a nonrelational database that organizes data into rows with flexible sets of columns, often grouped into column families, and commonly supports distributed storage.
ScyllaDB in Action
A wide-column database stores rows with flexible sets of columns and distributes data across nodes.
- How it is used
- Explains how ScyllaDB and Cassandra model distributed application data with flexible rows and primary-key-driven access.
- How deep it goes
- Defines storage differences, distributed trade-offs, and optional-column writes, but stops short of a complete schema-design procedure.
- Examples
- Uses an authors table, partial INSERT, primary-key UPDATE, SELECT output, and a columnar-storage comparison.
- What you can do after
- Evaluate flexible-row storage and distinguish absent columns from explicitly stored null values.
Grokking Software Architecture
A wide-column database stores data in rows with flexible groups of columns, often distributed across many machines.
- How it is used
- Handles high-throughput writes for workloads that must record very large event volumes.
- How deep it goes
- Characterizes its write-throughput role and target workloads, but gives no storage-layout or operational detail.
- Examples
- Uses IoT networks, activity tracking, and massive-scale applications as write-heavy examples.
- What you can do after
- Evaluate wide-column stores for workloads that need to ingest millions of events per second.
Read how Grokking Software Architecture explains wide-column store →
What to know first
- NoSQL databaseA NoSQL database is a database system organized primarily around nonrelational data models rather than the traditional relational table model.
- SQLSQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
Related concepts
- ScyllaDBincludes · ScyllaDB is a distributed wide-column database compatible with Cassandra’s data model and protocol, designed for high scalability and availability.
- NoSQL databasekind of · A NoSQL database is a database system organized primarily around nonrelational data models rather than the traditional relational table model.
Questions about wide-column store
What is wide-column store?
A wide-column store is a nonrelational database that organizes data into rows with flexible sets of columns, often grouped into column families, and commonly supports distributed storage.
Which Manning books explain wide-column store?
ScyllaDB in Action and Grokking Software Architecture.
What should I know before learning wide-column store?
Manning books that teach wide-column store usually introduce NoSQL database and SQL first.
What is the difference between wide-column store and column-oriented database?
A wide-column store is a nonrelational database that organizes data into rows with flexible sets of columns, often grouped into column families, and commonly supports distributed storage. A column-oriented database stores and processes tabular data primarily by column rather than by row.
What kinds of wide-column store are there?
Kinds of wide-column store include ScyllaDB.
What is wide-column store a kind of?
Wide-column store is a kind of NoSQL database. A NoSQL database is a database system organized primarily around nonrelational data models rather than the traditional relational table model.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.

