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 62 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.00068998927 |
| 14 | MonetDB/X100: Hyper-Pipelining Query Execution | 2005 | CIDR | 0.00064031282 |
| 48 | Weaving Relations for Cache Performance | 2001 | VLDB | 0.00043805923 |
| 61 | Integrating Compression and Execution in Column-Oriented Database Systems | 2006 | SIGMOD | 0.000392237 |
| 389 | QPipe: A Simultaneously Pipelined Relational Query Engine | 2005 | SIGMOD | 0.00019269777 |
| 401 | A Case for Fractured Mirrors | 2002 | VLDB | 0.00019108281 |
| 634 | Performance Tradeoffs in Read-Optimized Databases | 2006 | VLDB | 0.00015373122 |
| 939 | Buffering Database Operations for Enhanced Instruction Cache Performance | 2004 | SIGMOD | 0.00012970078 |
| 2,732 | Efficient Execution of Joins in a Star Schema | 2002 | SIGMOD | 8.0822671e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 6,038 | Teaching an Old Elephant New Tricks | 2009 | CIDR |
| 2 | 1,200 | Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads | 2016 | SIGMOD |
| 3 | 5,827 | Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases | 2013 | VLDB |
| 4 | 1,632 | Positional Update Handling in Column Stores | 2010 | SIGMOD |
| 5 | 12 | C-Store: A Column-oriented DBMS | 2005 | VLDB |
| 6 | 61 | Integrating Compression and Execution in Column-Oriented Database Systems | 2006 | SIGMOD |
| 7 | 3,970 | The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates | 2014 | VLDB |
| 8 | 634 | Performance Tradeoffs in Read-Optimized Databases | 2006 | VLDB |
| 9 | 3,549 | Read-Optimized Databases, In Depth | 2008 | VLDB |
| 10 | 1,327 | Column-oriented Database Systems | 2009 | VLDB |