Columnar Storage

Difficulty: Advanced

Question

Why is columnar storage better for analytics?

Answer

It allows reading only the columns needed for a query, resulting in much less I/O and better compression for repetitive data values.

Concepts covered

OLAP, Big Data, Compression