---
answer: direct
beat: system-design
source: 1 article · updated: November 15, 2026
---

What is the primary difference between wide-column stores and relational databases?

Wide-column stores (such as Apache Cassandra or ScyllaDB) use log-structured merge trees and partition keys to deliver virtually unbounded horizontal write scalability, sacrificing multi-row ACID transactions and flexible join queries.

Answered in

Database Types Guide: Storage Models, Access Patterns, and Polyglot Persistence

A practical guide to modern database types: relational, columnar, key-value, document, time-series, graph, and vector engines matching storage to workloads.

Crashtech Editorial November 15, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design & Architecture beat.