《Column-Stores vs. Row-Stores How Different Are They Really?》 阅读笔记 | Andrewei's Blog

[andrewei1316]

https://andrewei1316.github.io/2020/11/20/column-stores-vs-row-stores/

摘要本文主要讨论在 OLAP 领域，面向列的存储和计算为什么会比面向行的存储和计算更快的问题。 在 OLAP 场景下，基准测试都会说面向列的存储和计算比面向行的存储和计算块一个数量级。而大家普遍理解面向列快的原因是 column-stores are more I/O efficient for read-only queries since they only have to read from