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
3853
Venue
SIGMOD
Year
2006
Pagerank
0.0003955489
Overall Rank
60 | 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 127 citing papers.

Rank Citing Paper Year Venue Pagerank
3,489 Read-Optimized Databases, In Depth 2008 VLDB 7.3670717e-05
3,552 Rethinking Data-Intensive Science Using Scalable Analytics Systems 2015 SIGMOD 7.3188008e-05
3,592 The FastLanes Compression Layout: Decoding >100 Billion Integers per Second with Scalar Code 2023 VLDB 7.2774889e-05
3,598 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 7.2718988e-05
3,653 ClickHouse - Lightning Fast Analytics for Everyone 2024 VLDB 7.2241143e-05
3,877 An Empirical Evaluation of Columnar Storage Formats 2024 VLDB 7.0532293e-05
4,036 Don’t Hold My Data Hostage – A Case For Client Protocol Redesign 2017 VLDB 6.9436548e-05
4,065 LeCo: Lightweight Compression via Learning Serial Correlations 2024 SIGMOD 6.930275e-05
4,120 Big Metadata: When Metadata is Big Data 2021 VLDB 6.8896959e-05
4,144 Tile-based Lightweight Integer Compression in GPU 2022 SIGMOD 6.8744592e-05
4,231 Pinot: Realtime OLAP for 530 Million Users 2018 SIGMOD 6.8177976e-05
4,483 Accelerating Raw Data Analysis with the ACCORDA Software and Hardware Architecture 2019 VLDB 6.6724044e-05
4,637 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.592197e-05
5,021 Online Deduplication for Databases 2017 SIGMOD 6.3982122e-05
5,037 A Deep Dive into Common Open Formats for Analytical DBMSs 2023 VLDB 6.3914026e-05
5,122 A Padded Encoding Scheme to Accelerate Scans by Leveraging Skew 2015 SIGMOD 6.3573169e-05
5,285 Order-Preserving Key Compression for In-Memory Search Trees 2020 SIGMOD 6.2821588e-05
5,357 Joins on Encoded and Partitioned Data 2014 VLDB 6.2497031e-05
5,383 Compressed Representations of Conjunctive Query Results 2018 PODS 6.2374576e-05
5,512 BinDex: A Two-Layered Index for Fast and Robust Scans 2020 SIGMOD 6.1913331e-05
5,589 An Experimental Evaluation of Large Scale GBDT Systems 2019 VLDB 6.1559057e-05
5,622 Good to the Last Bit: Data-Driven Encoding with CodecDB 2021 SIGMOD 6.1461066e-05
5,755 Compression Aware Physical Database Design 2011 VLDB 6.0974171e-05
5,805 Diva: Making MVCC Systems HTAP-Friendly 2022 SIGMOD 6.0822211e-05
5,812 MCJoin: A Memory-Constrained Join for Column-Store Main-Memory Databases. 2012 SIGMOD 6.0782357e-05
6,047 Column Stores For Wide and Sparse Data 2007 CIDR 5.9952702e-05
6,190 Progressive Compressed Records: Taking a Byte out of Deep Learning Data 2021 VLDB 5.9476635e-05
6,336 Heracles: An Efficient Storage Model and Data Flushing for Performance Monitoring Timeseries 2021 VLDB 5.9088937e-05
6,480 Proteus: Autonomous Adaptive Storage for Mixed Workloads 2022 SIGMOD 5.8669819e-05
6,485 Tuple-oriented Compression for Large-scale Mini-batch Stochastic Gradient Descent 2019 SIGMOD 5.8657457e-05
6,665 MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model 2020 VLDB 5.8089595e-05
6,687 Making In-Memory Learned Indexes Efficient on Disk 2024 SIGMOD 5.8022308e-05
6,918 Leveraging Compression in the Tableau Data Engine 2014 SIGMOD 5.7392935e-05
7,072 Two Birds With One Stone: Designing a Hybrid Cloud Storage Engine for HTAP 2024 VLDB 5.7107965e-05
7,139 Selection Pushdown in Column Stores using Bit Manipulation Instructions 2023 SIGMOD 5.6932481e-05
7,285 Bullion: A Column Store for Machine Learning 2025 CIDR 5.6559604e-05
7,392 Hyper: A High-Performance and Memory-Efficient Learned Index via Hybrid Construction 2024 SIGMOD 5.6265456e-05
7,458 AHEAD: Adaptable Data Hardening for On-the-Fly Hardware Error Detection during Database Query Processing 2018 SIGMOD 5.6121707e-05
8,000 PIDS: Attribute Decomposition for Improved Compression and Query Performance in Columnar Storage 2020 VLDB 5.5092344e-05
8,176 Cohort Query Processing 2017 VLDB 5.4736785e-05
8,249 Femur: A Flexible Framework for Fast and Secure Querying from Public Key-Value Store 2025 SIGMOD 5.4574671e-05
8,318 Optimizing Declarative Graph Queries at Large Scale 2019 SIGMOD 5.4548766e-05
8,410 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.4309397e-05
8,436 Adaptive Compression for Fast Scans on String Columns 2021 SIGMOD 5.4253644e-05
8,583 Query Log Compression for Workload Analytics 2019 VLDB 5.4079618e-05
8,783 Tiresias: Enabling Predictive Autonomous Storage and Indexing 2022 VLDB 5.3740362e-05
8,794 AWARE: Workload-aware, Redundancy-exploiting Linear Algebra 2023 SIGMOD 5.370464e-05
8,952 RadixZip: Linear Time Compression of Token Streams 2007 VLDB 5.3458888e-05
9,038 The FastLanes File Format 2025 VLDB 5.3270943e-05
9,159 Hybrid Row-Column Partitioning in Teradata 2016 VLDB 5.3114559e-05
Previous Page 2 / 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.00069513174
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.0006312782
29 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.00052093615
49 Weaving Relations for Cache Performance 2001 VLDB 0.00043781096
104 Improved Query Performance with Variant Indexes 1997 SIGMOD 0.00033932213
394 A Case for Fractured Mirrors 2002 VLDB 0.00019306179
921 Query Optimization In Compressed Database Systems 2001 SIGMOD 0.00013209503
970 Sybase IQ Multiplex – Designed For Analytics 2004 VLDB 0.00012882125
1,017 Data Compression Support in Databases 1994 VLDB 0.00012641552
1,867 Performance Measurements of Compressed Bitmap Indices 1999 VLDB 9.5903618e-05
1,894 Optimizing Queries On Compressed Bitmaps 2000 VLDB 9.5268052e-05
Previous Page 1 / 1 Next

Semantically Similar Papers