liveBook · Manning

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.

How 2 Manning books explain it

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.

Read how ScyllaDB in Action explains wide-column store →

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

Related concepts

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.