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 |
|---|---|---|---|---|
| 941 | Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation | 2016 | SIGMOD | 0.00013078348 |
| 2,937 | Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation | 2018 | SIGMOD | 7.9435581e-05 |
| 3,598 | Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? | 2017 | SIGMOD | 7.2718988e-05 |
| 4,065 | LeCo: Lightweight Compression via Learning Serial Correlations | 2024 | SIGMOD | 6.930275e-05 |
| 4,483 | Accelerating Raw Data Analysis with the ACCORDA Software and Hardware Architecture | 2019 | VLDB | 6.6724044e-05 |
| 5,285 | Order-Preserving Key Compression for In-Memory Search Trees | 2020 | SIGMOD | 6.2821588e-05 |
| 7,242 | Fast Multi-Column Sorting in Main-Memory Column-Stores | 2016 | SIGMOD | 5.6641994e-05 |
| 8,349 | Tree-Encoded Bitmaps | 2020 | SIGMOD | 5.4460774e-05 |
| 10,056 | Rethinking the Encoding of Integers for Scans on Skewed Data | 2023 | SIGMOD | 5.1676234e-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,472 | Approximate Encoding for Direct Access and Query Processing over Compressed Bitmaps | 2006 | VLDB |
| 2 | 8,410 | Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems | 2022 | VLDB |
| 3 | 1,450 | Row-wise Parallel Predicate Evaluation | 2008 | VLDB |
| 4 | 5,622 | Good to the Last Bit: Data-Driven Encoding with CodecDB | 2021 | SIGMOD |
| 5 | 8,436 | Adaptive Compression for Fast Scans on String Columns | 2021 | SIGMOD |
| 6 | 7,139 | Selection Pushdown in Column Stores using Bit Manipulation Instructions | 2023 | SIGMOD |
| 7 | 5,985 | Column Partition and Permutation for Run Length Encoding in Columnar Databases | 2020 | SIGMOD |
| 8 | 1,950 | How to Barter Bits for Chronons: Compression and Bandwidth Trade Offs for Database Scans | 2007 | SIGMOD |
| 9 | 2,937 | Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation | 2018 | SIGMOD |
| 10 | 10,056 | Rethinking the Encoding of Integers for Scans on Skewed Data | 2023 | SIGMOD |