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

When should an engineering team choose a columnar database over a relational database?

Columnar databases (such as ClickHouse or Snowflake) store data column-by-column rather than row-by-row. They are optimized for analytical queries (OLAP) calculating aggregations over billions of rows across a few columns.

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.