How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans

Summary: Code-generated, schema-tuned compression scans to reduce CPU-bound table scans; evaluates formats and introduces two optimizations: tuple-length quantization and a field-length lookup table. Empirical results reveal compression–speed trade-offs and ILP-based techniques to increase parallelism on multi-issue processors. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3868
Venue: SIGMOD
Year: 2007
Pagerank: 0.00010130401
Overall Rank: 1,908 | 86.75%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031314629
307	SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units	2009	VLDB	0.00028226342
2,414	Towards a One Size Fits All Database Architecture	2011	CIDR	8.8572378e-05
2,442	Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries	2008	VLDB	8.8067249e-05
2,562	Rose: Compressed, log-structured replication	2008	VLDB	8.5373135e-05
3,686	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB	6.839208e-05
3,761	Read-Optimized Databases, In Depth	2008	VLDB	6.7777865e-05
5,124	Accelerating Generalized Linear Models with MLWeaving: A One-Size-Fits-All System for Any-Precision Learning	2019	VLDB	5.6747536e-05
6,095	Data Warehouse Technology by Infobright	2009	SIGMOD	5.2087143e-05
7,864	Operational Analytics Data Management Systems	2016	VLDB	4.6284093e-05
8,658	RadixZip: Linear Time Compression of Token Streams	2007	VLDB	4.4682399e-05
8,782	AWARE: Workload-aware, Redundancy-exploiting Linear Algebra	2023	SIGMOD	4.4478585e-05
11,926	Purity: Building Fast, Highly-Available Enterprise Flash Storage from Commodity Components	2015	SIGMOD	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
20	C-Store: A Column-oriented DBMS	2005	VLDB	0.00086163998
35	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00076209479
132	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00043697853
708	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00017753572
894	Data Compression Support in Databases	1994	VLDB	0.00015516667
1,098	Query Optimization In Compressed Database Systems	2001	SIGMOD	0.00014070252
1,109	Sybase IQ Multiplex – Designed For Analytics	2004	VLDB	0.00013927106
1,337	Query Processing in Main Memory Database Management Systems	1986	SIGMOD	0.00012515176
1,415	Data Compression in Oracle	2003	VLDB	0.00012102269
2,137	How to Wring a Table Dry: Entropy Compression of Relations and Querying of Compressed Relations	2006	VLDB	9.463768e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011944621
1,267	BitWeaving: Fast Scans for Main Memory Data Processing	2013	SIGMOD	0.00012917585
2,890	Database Compression on Graphics Processors	2010	VLDB	7.9586083e-05
5,541	A Padded Encoding Scheme to Accelerate Scans by Leveraging Skew	2015	SIGMOD	5.4501856e-05
708	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00017753572
5,677	Joins on Encoded and Partitioned Data	2014	VLDB	5.376511e-05
6,160	Compression Aware Physical Database Design	2011	VLDB	5.1750659e-05
307	SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units	2009	VLDB	0.00028226342
1,098	Query Optimization In Compressed Database Systems	2001	SIGMOD	0.00014070252
132	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00043697853