§ Section · Analytical (OLAP)

Analytical (OLAP) databases.

Column-oriented engines optimized for analytical queries over large datasets.

When you need to scan billions of rows to compute aggregates rather than read or update individual records, column stores dominate. They trade single-row update speed for orders-of-magnitude faster scans and aggressive compression.