Column-Stores vs. Row-Stores: How Different Are They Really?
Summary: Column-stores outperform row-stores on analytics; vertical partitioning cannot bridge the gap. The paper dissects executor-level factors, showing gains from vectorized execution, compression, and a new join algorithm, arguing that realizing column-store benefits requires changes to both storage and the query engine. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Daniel J. Abadi (Yale University)
- 2. Samuel R. Madden (Massachusetts Institute of Technology)
- 3. Nabil Hachem (AvantGarde Consulting LLC)
BibTeX Citation
@inproceedings{abadi_sigmod08,
title = {{Column-Stores vs. Row-Stores: How Different Are They Really?}},
author = {Abadi, Daniel J. and Madden, Samuel R. and Hachem, Nabil},
series = {{SIGMOD} '08},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1376616.1376712},
url = {https://dl.acm.org/doi/10.1145/1376616.1376712},
year = {2008}
}Incoming Citations (Sorted by Pagerank)
Showing 50 of 60 citing papers.
Outgoing Citations (Sorted by Pagerank)
Showing 9 of 9 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 12 | C-Store: A Column-oriented DBMS | 2005 | VLDB | 0.00069513174 |
| 14 | MonetDB/X100: Hyper-Pipelining Query Execution | 2005 | CIDR | 0.0006312782 |
| 49 | Weaving Relations for Cache Performance | 2001 | VLDB | 0.00043781096 |
| 60 | Integrating Compression and Execution in Column-Oriented Database Systems | 2006 | SIGMOD | 0.0003955489 |
| 383 | QPipe: A Simultaneously Pipelined Relational Query Engine | 2005 | SIGMOD | 0.00019520728 |
| 394 | A Case for Fractured Mirrors | 2002 | VLDB | 0.00019306179 |
| 630 | Performance Tradeoffs in Read-Optimized Databases | 2006 | VLDB | 0.00015591796 |
| 932 | Buffering Database Operations for Enhanced Instruction Cache Performance | 2004 | SIGMOD | 0.00013119305 |
| 2,736 | Efficient Execution of Joins in a Star Schema | 2002 | SIGMOD | 8.1891265e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,926 | Teaching an Old Elephant New Tricks | 2009 | CIDR |
| 2 | 1,199 | Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads | 2016 | SIGMOD |
| 3 | 5,715 | Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases | 2013 | VLDB |
| 4 | 1,629 | Positional Update Handling in Column Stores | 2010 | SIGMOD |
| 5 | 12 | C-Store: A Column-oriented DBMS | 2005 | VLDB |
| 6 | 60 | Integrating Compression and Execution in Column-Oriented Database Systems | 2006 | SIGMOD |
| 7 | 3,902 | The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates | 2014 | VLDB |
| 8 | 630 | Performance Tradeoffs in Read-Optimized Databases | 2006 | VLDB |
| 9 | 3,489 | Read-Optimized Databases, In Depth | 2008 | VLDB |
| 10 | 1,395 | Column-oriented Database Systems | 2009 | VLDB |