DBScholar

Back to papers

Performance Tradeoffs in Read-Optimized Databases

Summary: Dissects row/column tradeoffs via one query engine supporting both layouts, quantifying disk, cache, and CPU effects. Shows columns often win—up to 10×—and derives a hardware/workload model predicting the superior organization. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hfb07b60af47f45c8
Venue
VLDB
Year
2006
Pagerank
0.00015334073
Overall Rank
635 | 95.75%
DOI
10.1016/j.vldb.2006.07.006

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{harizopoulos_vldb06,
        title = {{Performance Tradeoffs in Read-Optimized Databases}},
        author = {Harizopoulos, Stavros and Liang, Velen and Abadi, Daniel J. and Madden, Samuel},
        journal = {PVLDB},
        series = {{VLDB} '06},
        pages = {487--498},
        doi = {10.1016/j.vldb.2006.07.006},
        url = {https://doi.org/10.1016/j.vldb.2006.07.006},
        year = {2006}
}

Incoming Citations (Sorted by Pagerank)

Showing 31 of 31 citing papers.

Rank Citing Paper Year Venue Pagerank
218 SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units 2009 VLDB 0.00024342426
332 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020739447
498 Building Efficient Query Engines in a High-Level Language 2014 VLDB 0.00017323427
707 Main-Memory Scan Sharing For Multi-Core CPUs 2008 VLDB 0.00014613324
768 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.00014096379
887 Analyzing the Energy Efficiency of a Database Server 2010 SIGMOD 0.00013214226
912 Dictionary-based Order-preserving String Compression for Main Memory Column Stores 2009 SIGMOD 0.00013092547
946 Enhancements to SQL Server Column Stores 2013 SIGMOD 0.00012911968
1,188 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011580449
1,337 Column-oriented Database Systems 2009 VLDB 0.00010968302
1,383 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010826996
1,470 The Performance of MapReduce: An In-depth Study 2010 VLDB 0.00010532106
1,485 Query Processing Techniques for Solid State Drives 2009 SIGMOD 0.00010498393
1,696 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8272691e-05
1,773 SQL Server Column Store Indexes 2011 SIGMOD 9.6751471e-05
1,937 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 9.3333463e-05
1,990 How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans 2007 SIGMOD 9.2272838e-05
2,104 Database Compression on Graphics Processors 2010 VLDB 9.0262021e-05
2,474 AnalyticDB: Real-time OLAP Database System at Alibaba Cloud 2019 VLDB 8.3955114e-05
2,477 One Size Fits All? – Part 2: Benchmarking Results 2007 CIDR 8.392837e-05
2,674 Energy Efficiency: The New Holy Grail of Data Management Systems Research 2009 CIDR 8.1274189e-05
3,505 How to Build a Non-Volatile Memory Database Management System 2017 SIGMOD 7.2290072e-05
3,547 Read-Optimized Databases, In Depth 2008 VLDB 7.1905227e-05
4,594 To Share or Not to Share? 2007 VLDB 6.4994689e-05
5,125 Online Deduplication for Databases 2017 SIGMOD 6.2497801e-05
5,839 Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases 2013 VLDB 5.957817e-05
5,876 Towards Energy-Efficient Database Cluster Design 2012 VLDB 5.945182e-05
6,977 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.6135617e-05
9,139 RadixZip: Linear Time Compression of Token Streams 2007 VLDB 5.2082006e-05
10,039 Selective Late Materialization in Modern Analytical Databases 2025 VLDB 5.0786422e-05
12,567 How Achaeans Would Construct Columns in Troy 2013 CIDR 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 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.00068985264
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00063972112
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.0005146739
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043770511
61 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.00039323387
111 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00032621499
114 A Decomposition Storage Model 1985 SIGMOD 0.00031854546
196 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025581936
390 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00019232929
403 A Case for Fractured Mirrors 2002 VLDB 0.00019067656
943 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.0001293608
1,191 Data Compression in Oracle 2003 VLDB 0.00011557261
2,928 Database Architectures for New Hardware 2004 VLDB 7.8316168e-05
6,008 Clotho: Decoupling Memory Page Layout from Storage Organization 2004 VLDB 5.8989032e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,986 The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates 2014 VLDB
2 1,340 Fast Updates on Read-Optimized Databases Using Multi-Core CPUs 2012 VLDB
3 27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB
4 1,637 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 5,839 Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases 2013 VLDB
8 1,337 Column-oriented Database Systems 2009 VLDB
9 332 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD
10 3,547 Read-Optimized Databases, In Depth 2008 VLDB