DBScholar

Back to papers

Integrating Compression and Execution in Column-Oriented Database Systems

Summary: Extends C-Store with a unified compression subsystem for columnar data, enabling compressed storage integrated with execution. Evaluates schemes beyond traditional row-store methods and shows the best choice depends on data characteristics and workload. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h3f0e951e926ff62d
Venue
SIGMOD
Year
2006
Pagerank
0.00039236924
Overall Rank
61 | 99.60%
DOI
10.1145/1142473.1142548

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{abadi_sigmod06,
        title = {{Integrating Compression and Execution in Column-Oriented Database Systems}},
        author = {Abadi, Daniel J. and Madden, Samuel R. and Ferreira, Miguel C.},
        series = {{SIGMOD} '06},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1142473.1142548},
        url = {https://dl.acm.org/doi/10.1145/1142473.1142548},
        year = {2006}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 128 citing papers.

Rank Citing Paper Year Venue Pagerank
233 Amazon Redshift and the Case for Simpler Data Warehouses 2015 SIGMOD 0.00023774958
252 Database Cracking 2007 CIDR 0.00023101361
277 FAST: Fast Architecture Sensitive Tree Search on Modern CPUs and GPUs 2010 SIGMOD 0.00022320139
331 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.0002076806
376 Scalable Semantic Web Data Management Using Vertical Partitioning 2007 VLDB 0.0001961765
557 Hexastore: Sextuple Indexing for Semantic Web Data Management 2008 VLDB 0.00016489266
634 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015367822
704 Main-Memory Scan Sharing For Multi-Core CPUs 2008 VLDB 0.00014653079
712 Cache locality is not enough: High-Performance Nearest Neighbor Search with Product Quantization Fast Scan 2016 VLDB 0.00014593534
762 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.00014134432
775 The Yin and Yang of Processing Data Warehousing Queries on GPU Devices 2013 VLDB 0.0001407924
873 BitWeaving: Fast Scans for Main Memory Data Processing 2013 SIGMOD 0.00013334067
907 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013157412
910 Dictionary-based Order-preserving String Compression for Main Memory Column Stores 2009 SIGMOD 0.00013122392
975 A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database 2009 SIGMOD 0.00012745575
1,034 A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses 2009 VLDB 0.00012389548
1,135 Dremel: A Decade of Interactive SQL Analysis at Web Scale 2020 VLDB 0.00011886308
1,210 Processing a Trillion Cells per Mouse Click 2012 VLDB 0.0001152237
1,282 Automatic Optimization for MapReduce Programs 2011 VLDB 0.00011208192
1,328 Column-oriented Database Systems 2009 VLDB 0.00010998855
1,423 Procella: Unifying serving and analytical data at YouTube 2019 VLDB 0.00010715412
1,458 Row-wise Parallel Predicate Evaluation 2008 VLDB 0.00010583148
1,693 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8522869e-05
1,765 SQL Server Column Store Indexes 2011 SIGMOD 9.6934008e-05
1,838 Cheetah: A High Performance, Custom Data Warehouse on Top of MapReduce 2010 VLDB 9.5305061e-05
1,984 How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans 2007 SIGMOD 9.2529061e-05
2,011 An Experimental Study of Bitmap Compression vs. Inverted List Compression 2017 SIGMOD 9.1924806e-05
2,139 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 8.9735524e-05
2,187 Database Compression on Graphics Processors 2010 VLDB 8.891124e-05
2,293 FDB: A Query Engine for Factorised Relational Databases 2012 VLDB 8.685044e-05
2,317 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.6492924e-05
2,344 Answering Aggregation Queries in a Secure System Model 2007 VLDB 8.6004109e-05
2,478 One Size Fits All? – Part 2: Benchmarking Results 2007 CIDR 8.4063622e-05
2,628 WideTable: An Accelerator for Analytical Data Processing 2014 VLDB 8.2027948e-05
2,709 An Integrated Approach to Recovery and High Availability in an Updatable, Distributed Data Warehouse 2006 VLDB 8.103163e-05
2,854 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 7.93571e-05
2,880 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9118308e-05
2,894 Rose: Compressed, log-structured replication 2008 VLDB 7.8968405e-05
2,903 Column-Oriented Storage Techniques for MapReduce 2011 VLDB 7.877293e-05
2,929 ALP: Adaptive Lossless floating-Point Compression 2023 SIGMOD 7.838721e-05
2,954 Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation 2018 SIGMOD 7.8119682e-05
3,003 ClickHouse - Lightning Fast Analytics for Everyone 2024 VLDB 7.7631056e-05
3,009 Llama: Leveraging Columnar Storage for Scalable Join Processing in the MapReduce Framework 2011 SIGMOD 7.7570485e-05
3,059 The Case for RodentStore, an Adaptive, Declarative Storage System 2009 CIDR 7.6939894e-05
3,083 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.6620866e-05
3,141 DeepSqueeze: Deep Semantic Compression for Tabular Data 2020 SIGMOD 7.5987721e-05
3,147 White-box Compression: Learning and Exploiting Compact Table Representations 2020 CIDR 7.5927972e-05
3,182 The FastLanes Compression Layout: Decoding >100 Billion Integers per Second with Scalar Code 2023 VLDB 7.5589507e-05
3,206 Columnar Storage and List-based Processing for Graph Database Management Systems 2021 VLDB 7.5365348e-05
3,293 Efficient Index Compression in DB2 LUW 2009 VLDB 7.4456263e-05
Previous Page 1 / 3 Next

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 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.0006897844
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00064013679
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.00051576613
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043795812
107 Improved Query Performance with Variant Indexes 1997 SIGMOD 0.00033459417
401 A Case for Fractured Mirrors 2002 VLDB 0.00019102313
898 Query Optimization In Compressed Database Systems 2001 SIGMOD 0.0001318387
980 Sybase IQ Multiplex – Designed For Analytics 2004 VLDB 0.00012717512
999 Data Compression Support in Databases 1994 VLDB 0.00012615754
1,896 Performance Measurements of Compressed Bitmap Indices 1999 VLDB 9.4103502e-05
1,932 Optimizing Queries On Compressed Bitmaps 2000 VLDB 9.349258e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,206 Columnar Storage and List-based Processing for Graph Database Management Systems 2021 VLDB
2 1,631 Positional Update Handling in Column Stores 2010 SIGMOD
3 5,827 Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases 2013 VLDB
4 5,856 Compression Aware Physical Database Design 2011 VLDB
5 6,736 CompressDB: Enabling Efficient Compressed Data Direct Processing for Various Databases 2022 SIGMOD
6 910 Dictionary-based Order-preserving String Compression for Main Memory Column Stores 2009 SIGMOD
7 898 Query Optimization In Compressed Database Systems 2001 SIGMOD
8 634 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB
9 12 C-Store: A Column-oriented DBMS 2005 VLDB
10 1,328 Column-oriented Database Systems 2009 VLDB