DBScholar

Back to papers

SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads

Summary: SASH introduces a Self-Adaptive Set of Histograms for dynamically changing workloads. It tunes online from query feedback only and periodically restructures to a more accurate set, selected from a batch, optimizing attribute sets and memory distribution for multidimensional queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9180
Venue
VLDB
Year
2003
Pagerank
9.1402718e-05
Overall Rank
2,121 | 85.45%
DOI
10.1016/B978-012722442-8/50040-9

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{lim_vldb03,
        title = {{SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads}},
        author = {Lim, Lipyeow and Wang, Min and Vitter, Jeffrey Scott},
        journal = {PVLDB},
        series = {{VLDB} '03},
        doi = {10.1016/B978-012722442-8/50040-9},
        url = {https://doi.org/10.1016/B978-012722442-8/50040-9},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank Citing Paper Year Venue Pagerank
159 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00028129426
1,061 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012369764
1,170 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011827259
3,086 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7708642e-05
4,591 Automated Statistics Collection in DB2 UDB 2004 VLDB 6.614318e-05
5,459 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.2108888e-05
6,138 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.9640712e-05
6,323 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9141228e-05
7,554 Consistent Histograms In The Presence of Distinct Value Counts 2009 VLDB 5.6001388e-05
9,671 Detecting Attribute Dependencies from Query Feedback 2007 VLDB 5.238674e-05
9,793 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD 5.2193018e-05
9,958 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1879626e-05
10,875 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.093636e-05
Previous Page 1 / 1 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
35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00048481081
100 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034385207
101 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00034376651
168 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD 0.00027541029
213 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024723025
222 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00024193708
280 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022454217
365 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00020041735
448 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00018292618
692 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00014919816
1,668 Global Optimization of Histograms 2001 SIGMOD 0.00010057026
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,889 Fast Algorithms For Hierarchical Range Histogram Construction 2002 PODS
2 235 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB
3 7,554 Consistent Histograms In The Presence of Distinct Value Counts 2009 VLDB
4 118 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD
5 168 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD
6 365 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD
7 35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD
8 723 Dynamic Multidimensional Histograms 2002 SIGMOD
9 274 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
10 448 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD