A Padded Encoding Scheme to Accelerate Scans by Leveraging Skew
Summary: Padded encoding assigns shorter codes to frequent values, preserves code order, and pads to fixed-length blocks so predicates run on compressed codes in vertical bit-parallel scans. By exploiting data and predicate skew, it enables early pruning and reduces memory access, with an O(n^3) algorithm to compute the optimal encoding for n distinct values. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Yinan Li (University of Wisconsin)
- 2. Craig Chasseur (University of Wisconsin)
- 3. Jignesh M. Patel (University of Wisconsin)
BibTeX Citation
@inproceedings{li_sigmod15,
title = {{A Padded Encoding Scheme to Accelerate Scans by Leveraging Skew}},
author = {Li, Yinan and Chasseur, Craig and Patel, Jignesh M.},
series = {{SIGMOD} '15},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/2723372.2737787},
url = {https://dl.acm.org/doi/10.1145/2723372.2737787},
year = {2015}
}Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 906 | Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation | 2016 | SIGMOD | 0.00013160654 |
| 2,952 | Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation | 2018 | SIGMOD | 7.8153507e-05 |
| 3,599 | Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? | 2017 | SIGMOD | 7.1773938e-05 |
| 4,153 | LeCo: Lightweight Compression via Learning Serial Correlations | 2024 | SIGMOD | 6.776246e-05 |
| 4,573 | Accelerating Raw Data Analysis with the ACCORDA Software and Hardware Architecture | 2019 | VLDB | 6.5265033e-05 |
| 5,397 | Order-Preserving Key Compression for In-Memory Search Trees | 2020 | SIGMOD | 6.1490013e-05 |
| 7,495 | Fast Multi-Column Sorting in Main-Memory Column-Stores | 2016 | SIGMOD | 5.5091753e-05 |
| 8,500 | Tree-Encoded Bitmaps | 2020 | SIGMOD | 5.3296886e-05 |
| 10,241 | Rethinking the Encoding of Integers for Scans on Skewed Data | 2023 | SIGMOD | 5.0531436e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 32 of 32 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,600 | Approximate Encoding for Direct Access and Query Processing over Compressed Bitmaps | 2006 | VLDB |
| 2 | 8,563 | Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems | 2022 | VLDB |
| 3 | 1,459 | Row-wise Parallel Predicate Evaluation | 2008 | VLDB |
| 4 | 5,471 | Good to the Last Bit: Data-Driven Encoding with CodecDB | 2021 | SIGMOD |
| 5 | 8,608 | Adaptive Compression for Fast Scans on String Columns | 2021 | SIGMOD |
| 6 | 6,392 | Selection Pushdown in Column Stores using Bit Manipulation Instructions | 2023 | SIGMOD |
| 7 | 6,095 | Column Partition and Permutation for Run Length Encoding in Columnar Databases | 2020 | SIGMOD |
| 8 | 1,984 | How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans | 2007 | SIGMOD |
| 9 | 2,952 | Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation | 2018 | SIGMOD |
| 10 | 10,241 | Rethinking the Encoding of Integers for Scans on Skewed Data | 2023 | SIGMOD |