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.000392237
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.00023783585
253 Database Cracking 2007 CIDR 0.00023042111
282 FAST: Fast Architecture Sensitive Tree Search on Modern CPUs and GPUs 2010 SIGMOD 0.00022264207
331 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.0002077683
376 Scalable Semantic Web Data Management Using Vertical Partitioning 2007 VLDB 0.00019626699
557 Hexastore: Sextuple Indexing for Semantic Web Data Management 2008 VLDB 0.00016497067
634 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015373122
705 Main-Memory Scan Sharing For Multi-Core CPUs 2008 VLDB 0.00014657491
713 Cache locality is not enough: High-Performance Nearest Neighbor Search with Product Quantization Fast Scan 2016 VLDB 0.00014571977
762 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.00014140446
771 The Yin and Yang of Processing Data Warehousing Queries on GPU Devices 2013 VLDB 0.00014085862
873 BitWeaving: Fast Scans for Main Memory Data Processing 2013 SIGMOD 0.00013338838
906 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013160654
910 Dictionary-based Order-preserving String Compression for Main Memory Column Stores 2009 SIGMOD 0.00013123912
976 A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database 2009 SIGMOD 0.00012749922
1,034 A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses 2009 VLDB 0.00012394538
1,135 Dremel: A Decade of Interactive SQL Analysis at Web Scale 2020 VLDB 0.00011891907
1,210 Processing a Trillion Cells per Mouse Click 2012 VLDB 0.00011527605
1,281 Automatic Optimization for MapReduce Programs 2011 VLDB 0.00011213384
1,327 Column-oriented Database Systems 2009 VLDB 0.00011003776
1,423 Procella: Unifying serving and analytical data at YouTube 2019 VLDB 0.00010719956
1,459 Row-wise Parallel Predicate Evaluation 2008 VLDB 0.00010585108
1,694 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8562172e-05
1,766 SQL Server Column Store Indexes 2011 SIGMOD 9.6955121e-05
1,837 Cheetah: A High Performance, Custom Data Warehouse on Top of MapReduce 2010 VLDB 9.5350058e-05
1,984 How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans 2007 SIGMOD 9.2557255e-05
2,137 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 8.9777553e-05
2,185 Database Compression on Graphics Processors 2010 VLDB 8.8948351e-05
2,201 An Experimental Study of Bitmap Compression vs. Inverted List Compression 2017 SIGMOD 8.8726671e-05
2,290 FDB: A Query Engine for Factorised Relational Databases 2012 VLDB 8.6889284e-05
2,314 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.6533171e-05
2,343 Answering Aggregation Queries in a Secure System Model 2007 VLDB 8.604484e-05
2,476 One Size Fits All? – Part 2: Benchmarking Results 2007 CIDR 8.409729e-05
2,628 WideTable: An Accelerator for Analytical Data Processing 2014 VLDB 8.2053454e-05
2,708 An Integrated Approach to Recovery and High Availability in an Updatable, Distributed Data Warehouse 2006 VLDB 8.1067346e-05
2,854 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 7.9394584e-05
2,882 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9116043e-05
2,894 Rose: Compressed, log-structured replication 2008 VLDB 7.9005767e-05
2,903 Column-Oriented Storage Techniques for MapReduce 2011 VLDB 7.8810111e-05
2,928 ALP: Adaptive Lossless floating-Point Compression 2023 SIGMOD 7.8424335e-05
2,952 Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation 2018 SIGMOD 7.8153507e-05
3,001 ClickHouse - Lightning Fast Analytics for Everyone 2024 VLDB 7.7667824e-05
3,007 Llama: Leveraging Columnar Storage for Scalable Join Processing in the MapReduce Framework 2011 SIGMOD 7.7607173e-05
3,056 The Case for RodentStore, an Adaptive, Declarative Storage System 2009 CIDR 7.6972474e-05
3,081 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.6653727e-05
3,140 DeepSqueeze: Deep Semantic Compression for Tabular Data 2020 SIGMOD 7.6023603e-05
3,146 White-box Compression: Learning and Exploiting Compact Table Representations 2020 CIDR 7.5963816e-05
3,181 The FastLanes Compression Layout: Decoding >100 Billion Integers per Second with Scalar Code 2023 VLDB 7.5625307e-05
3,204 Columnar Storage and List-based Processing for Graph Database Management Systems 2021 VLDB 7.5400217e-05
3,296 Efficient Index Compression in DB2 LUW 2009 VLDB 7.4473548e-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.00068998927
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00064031282
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.0005158963
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043805923
107 Improved Query Performance with Variant Indexes 1997 SIGMOD 0.00033460288
401 A Case for Fractured Mirrors 2002 VLDB 0.00019108281
900 Query Optimization In Compressed Database Systems 2001 SIGMOD 0.00013186558
980 Sybase IQ Multiplex – Designed For Analytics 2004 VLDB 0.00012720677
999 Data Compression Support in Databases 1994 VLDB 0.00012617745
1,896 Performance Measurements of Compressed Bitmap Indices 1999 VLDB 9.4099587e-05
1,930 Optimizing Queries On Compressed Bitmaps 2000 VLDB 9.351027e-05
Previous Page 1 / 1 Next

Semantically Similar Papers