DBScholar

Back to papers

Self-tuning Histograms: Building Histograms Without Looking at Data

Summary: Self-tuning histograms infer distributions from query-execution feedback, not data samples, and refine via range-selectivity observations. Data-size independent, cheaper than multi-dimensional histograms; effective for low–moderate skew, with initialization/refinement techniques and experimental validation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hdcfd44ae6c3d1545
Venue
SIGMOD
Year
1999
Pagerank
0.00017962189
Overall Rank
454 | 96.95%
DOI
10.1145/304182.304198

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{aboulnaga_sigmod99,
        title = {{Self-tuning Histograms: Building Histograms Without Looking at Data}},
        author = {Aboulnaga, Ashraf and Chaudhuri, Surajit},
        series = {{SIGMOD} '99},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/304182.304198},
        url = {https://dl.acm.org/doi/10.1145/304182.304198},
        year = {1999}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 57 citing papers.

Rank Citing Paper Year Venue Pagerank
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034106982
160 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00027837289
255 The History of Histograms (abridged) 2003 VLDB 0.00022981861
312 Surfing Wavelets on Streams: One-Pass Summaries for Approximate Aggregate Queries 2001 VLDB 0.00021311793
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019829769
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019720059
560 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00016403151
646 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.0001520859
682 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.0001481781
692 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014741011
742 Dynamic Multidimensional Histograms 2002 SIGMOD 0.0001431602
866 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013381261
955 Flexible Database Generators 2005 VLDB 0.00012866364
1,004 Dynamic Maintenance of Wavelet-Based Histograms 2000 VLDB 0.00012594522
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202282
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011777105
1,159 Toward a Progress Indicator for Database Queries 2004 SIGMOD 0.00011771949
1,242 Compressing SQL Workloads 2002 SIGMOD 0.00011373611
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010417728
1,587 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.0001014156
1,607 SciBORQ: Scientific data management with Bounds On Runtime and Quality 2011 CIDR 0.0001008742
1,929 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 9.3546057e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.250242e-05
2,140 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 8.9682092e-05
2,172 A Black-Box Approach to Query Cardinality Estimation 2007 CIDR 8.9214171e-05
2,411 Towards Elastic Transactional Cloud Storage with Range Query Support 2010 VLDB 8.5108707e-05
2,842 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 7.949193e-05
2,891 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9021718e-05
2,974 Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs 2022 VLDB 7.7938744e-05
3,052 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7052471e-05
3,060 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 7.6928239e-05
3,073 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6777283e-05
3,210 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5363533e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3760492e-05
3,527 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.2310714e-05
3,644 Optimal Histograms for Hierarchical Range Queries (Extended Abstract) 2000 PODS 7.1399991e-05
3,851 Graph-Based Synopses for Relational Selectivity Estimation 2006 SIGMOD 6.9785886e-05
4,252 Primitives for Workload Summarization and Implications for SQL 2003 VLDB 6.7015609e-05
4,462 DigitHist: a Histogram-Based Data Summary with Tight Error Bounds 2017 VLDB 6.5880099e-05
4,528 XPathLearner: An On-Line Self-Tuning Markov Histogram for XML Path Selectivity Estimation 2002 VLDB 6.5602044e-05
4,659 Automated Statistics Collection in DB2 UDB 2004 VLDB 6.4822228e-05
5,044 Lightweight Cardinality Estimation in LSM-based Systems 2018 SIGMOD 6.30014e-05
5,470 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.1182634e-05
5,865 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9659203e-05
6,208 Efficient Detection of Empty-Result Queries 2006 VLDB 5.8497045e-05
6,660 Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation 2023 SIGMOD 5.7178404e-05
6,710 Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis 2023 VLDB 5.7019157e-05
7,072 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.6074688e-05
7,519 Comparing Synopsis Techniques for Approximate Spatial Data Analysis 2019 VLDB 5.502959e-05
7,633 Consistent Histograms In The Presence of Distinct Value Counts 2009 VLDB 5.4792473e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank Cited Paper Year Venue Pagerank
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047731453
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036487763
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033894985
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.0003137356
149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00028981723
169 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD 0.00027134723
232 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023792809
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023363722
252 Approximate Medians and other Quantiles in One Pass and with Limited Memory 1998 SIGMOD 0.00023050233
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 9,142 Histograms Reloaded: The Merits of Bucket Diversity 2010 SIGMOD
2 9,818 Hierarchically Organized Skew-Tolerant Histograms for Geographic Data Objects 2010 SIGMOD
3 11,939 Data-Independent Space Partitionings for Summaries 2021 PODS
4 1,687 Global Optimization of Histograms 2001 SIGMOD
5 742 Dynamic Multidimensional Histograms 2002 SIGMOD
6 37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD
7 119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD
8 2,140 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB
9 283 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
10 7,633 Consistent Histograms In The Presence of Distinct Value Counts 2009 VLDB