LearnViz CompSci
Home / Learn / Databases / Column-Family Stores

Advanced Topic 42 of 51 Databases

Column-Family Stores

Wide-column stores optimized for large writes.

How it works

Column-family or wide-column stores, such as Cassandra, HBase and Bigtable, organize data into rows identified by a key, with columns grouped into families, and rows can have different columns. Data is partitioned by row key across nodes, and within a partition it is sorted by clustering columns, making range scans within a partition efficient. They are built on LSM trees for high write throughput and scale linearly across many machines.

Step-by-step walkthrough

  1. Rows are identified by a row key.
  2. Columns are grouped into families stored together.
  3. Each row can have different columns.
  4. Cells carry timestamps for versions.
  5. Writes are append-only and fast, so it suits huge write volumes, as in Cassandra.

Where it is used

Time-series data, messaging, sensor logs, activity feeds and very large write-heavy workloads use wide-column stores.

Common pitfall

Tables must be designed around specific queries, and ad hoc queries or joins are not supported. Poor partition keys create hot or huge partitions. Deletes leave tombstones that affect reads. Consistency is tunable and eventual by default, so understand quorum settings. Denormalize and duplicate data per query pattern.

Where it fits in the course

Column-Family Stores is topic 42 of 51 in Databases, rated Advanced. It follows Key-Value Stores. The next topic is Graph Databases.

Practice and explore

How to study this topic

  1. Read the explanation above and restate the definition in your own words.
  2. Open the interactive lesson and answer its mini quiz.
  3. Read the common pitfall, then write a short example that avoids it.
  4. Check your understanding in the Databases quiz, and revisit the topic if you miss a question.

Frequently asked questions

What is Column-Family Stores?
Wide-column stores optimized for large writes. It belongs to Databases and is an advanced-level topic.
Where do people use Column-Family Stores?
Time-series data, messaging, sensor logs, activity feeds and very large write-heavy workloads use wide-column stores.
What is the most common mistake with Column-Family Stores?
Tables must be designed around specific queries, and ad hoc queries or joins are not supported.
What should I learn before this topic?
Start with Key-Value Stores, the topic just before it in Databases.
How can I practice it?
Answer the mini quiz in the interactive lesson, then take the Databases quiz.
Is Column-Family Stores hard to learn?
It is an Advanced topic. Expect to read the explanation more than once and to connect it with earlier topics. Working through a small example by hand helps most.
How long does it take to learn Column-Family Stores?
Most learners can read the explanation and finish the interactive lesson in under an hour. Fluency comes from applying the idea, so plan a few short practice sessions with the quiz.
Which topics are related to Column-Family Stores?
Key-Value Stores, Graph Databases, Document Stores are closely connected. The full list is in the related topics section of this page.
What should I study after Column-Family Stores?
Continue with Graph Databases, the next topic in Databases.

Related topics