Columnar Database

Motivation

A database that stores values by column to improve analytical scans, compression, and aggregation.

Where it fits

Columnar Database belongs to the data track and the Data Platforms layer.

Mental model

Treat it as a practical tool for deciding how information, systems, or organizations should be structured.

Key ideas

• Understand the problem it solves and the constraints it introduces.
• Connect it to neighboring concepts rather than treating it as an isolated definition.
• Evaluate the trade-offs that appear at larger scale.

Common mistakes

• Using the term without defining the operational context.
• Optimizing for one metric while ignoring cost, reliability, or usability.
• Assuming a pattern is universally appropriate.