What is 'Columnar Compression'?

What is 'Columnar Compression'?

Approach: Explain why vertical data is easier to compress.

Techniques used in columnar databases to reduce storage by exploiting the fact that values in a column are often similar (e.g., storing a sequence of identical values once with a count).

Follow-up: Why is this harder to do with row-based storage?

Key concepts: run-length encoding, dictionary encoding.