DigiNews

Tech Watch by Johan Denoyer

← Back to articles

Rows vs Columns: How different are they, really?

Quality: 8/10 Relevance: 9/10

Summary

The article uses a bike rides CSV example to explain the difference between row stores and column stores, and why storage layout matters for different workloads. It covers OLTP vs OLAP, cache locality, and how vectorized execution and lightweight encodings improve analytical queries. It also references Spiral’s Vortex and discusses the tradeoffs between analytics-focused and transactional databases.

🚀 Service construit par Johan Denoyer