DBScholar

Back to papers

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)

Paper ID
4108
Venue
SIGMOD
Year
2008
Pagerank
0.00020656723
Overall Rank
345 | 97.64%
DOI
10.1145/1376616.1376712

Incoming Non-self Citations Over Time

Authors

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 10 of 60 citing papers.

Rank Citing Paper Year Venue Pagerank
10,081 Rethink Query Optimization in HTAP Databases 2023 SIGMOD 5.158939e-05
10,325 Perseus: Achieving Strong Consistency and High Data Freshness for Scalable Geo-distributed HTAP 2026 SIGMOD 5.093636e-05
10,464 Improving LZ4 for Effective Compression and Efficient Query 2026 SIGMOD 5.093636e-05
10,509 FlatStor: An Efficient Embedded-Index Based Columnar Data Layout for Multimodal Data Workloads 2026 VLDB 5.093636e-05
10,553 AQD: Online Adaptive Query Dispatcher for HTAP Databases 2026 VLDB 5.093636e-05
10,824 Efficient Concurrent Updates to Persistent Randomized Binary Search Trees 2025 VLDB 5.093636e-05
10,889 Concurrency Control as a Service 2025 VLDB 5.093636e-05
11,356 Zed: Leveraging Data Types to Process Eclectic Data 2023 CIDR 5.093636e-05
11,413 SH2O: Efficient Data Access for Work-Sharing Databases 2023 SIGMOD 5.093636e-05
12,227 How Achaeans Would Construct Columns in Troy 2013 CIDR 5.093636e-05
Previous Page 2 / 2 Next

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