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 |
|---|---|---|---|---|
| 894 | Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation | 2016 | SIGMOD | 0.00013179915 |
| 2,965 | Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation | 2018 | SIGMOD | 7.7894987e-05 |
| 3,606 | Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? | 2017 | SIGMOD | 7.1528863e-05 |
| 4,169 | LeCo: Lightweight Compression via Learning Serial Correlations | 2024 | SIGMOD | 6.7526687e-05 |
| 4,591 | Accelerating Raw Data Analysis with the ACCORDA Software and Hardware Architecture | 2019 | VLDB | 6.5021605e-05 |
| 5,398 | Order-Preserving Key Compression for In-Memory Search Trees | 2020 | SIGMOD | 6.1338952e-05 |
| 7,492 | Fast Multi-Column Sorting in Main-Memory Column-Stores | 2016 | SIGMOD | 5.4981253e-05 |
| 8,516 | Tree-Encoded Bitmaps | 2020 | SIGMOD | 5.3110731e-05 |
| 10,271 | Rethinking the Encoding of Integers for Scans on Skewed Data | 2023 | SIGMOD | 5.0360769e-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,614 | Approximate Encoding for Direct Access and Query Processing over Compressed Bitmaps | 2006 | VLDB |
| 2 | 8,589 | Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems | 2022 | VLDB |
| 3 | 1,461 | Row-wise Parallel Predicate Evaluation | 2008 | VLDB |
| 4 | 5,489 | Good to the Last Bit: Data-Driven Encoding with CodecDB | 2021 | SIGMOD |
| 5 | 8,633 | Adaptive Compression for Fast Scans on String Columns | 2021 | SIGMOD |
| 6 | 6,400 | Selection Pushdown in Column Stores using Bit Manipulation Instructions | 2023 | SIGMOD |
| 7 | 6,101 | Column Partition and Permutation for Run Length Encoding in Columnar Databases | 2020 | SIGMOD |
| 8 | 1,990 | How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans | 2007 | SIGMOD |
| 9 | 2,965 | Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation | 2018 | SIGMOD |
| 10 | 10,271 | Rethinking the Encoding of Integers for Scans on Skewed Data | 2023 | SIGMOD |