DBScholar

Back to papers

STHoles: A Multidimensional Workload-Aware Histogram

Summary: STHoles is a workload-aware multidimensional histogram with nested buckets that capture uniform-density regions. Built without scanning data, it uses query results to place buckets where the workload concentrates, yielding accurate selectivity and often outperforming data-driven histograms. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h0452cd250d7dcceb
Venue
SIGMOD
Year
2001
Pagerank
0.00019829769
Overall Rank
371 | 97.51%
DOI
10.1145/375663.375686

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{bruno_sigmod01,
        title = {{STHoles: A Multidimensional Workload-Aware Histogram}},
        author = {Bruno, Nicolas and Chaudhuri, Surajit and Gravano, Luis},
        series = {{SIGMOD} '01},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/375663.375686},
        url = {https://dl.acm.org/doi/10.1145/375663.375686},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 72 citing papers.

Rank Citing Paper Year Venue Pagerank
160 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00027837289
255 The History of Histograms (abridged) 2003 VLDB 0.00022981861
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019720059
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019045544
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
955 Flexible Database Generators 2005 VLDB 0.00012866364
982 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012714044
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,257 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011310561
1,331 A Privacy-Preserving Index for Range Queries 2004 VLDB 0.00010999239
1,508 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010440205
1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010180835
1,734 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7545773e-05
1,929 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 9.3546057e-05
2,004 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2065719e-05
2,140 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 8.9682092e-05
2,155 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 8.9456729e-05
2,172 A Black-Box Approach to Query Cardinality Estimation 2007 CIDR 8.9214171e-05
2,216 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.8177753e-05
2,242 Automatic Categorization of Query Results 2004 SIGMOD 8.7685327e-05
2,291 GORDIAN: Efficient and Scalable Discovery of Composite Keys 2006 VLDB 8.6872323e-05
2,413 Data Generation using Declarative Constraints 2011 SIGMOD 8.5094338e-05
2,583 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2589758e-05
2,616 Query Optimization over Web Services 2006 VLDB 8.2253465e-05
2,846 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9453616e-05
3,052 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7052471e-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,562 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2046519e-05
3,993 Output Perturbation with Query Relaxation 2008 VLDB 6.8685183e-05
4,311 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6727978e-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,563 Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts 2022 SIGMOD 6.5320994e-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,209 SAM: Database Generation from Query Workloads with Supervised Autoregressive Models 2022 SIGMOD 6.2262056e-05
5,580 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.0769576e-05
5,789 A Neural Database for Differentially Private Spatial Range Queries 2022 VLDB 5.9942738e-05
5,840 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9737703e-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,241 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8381762e-05
7,072 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.6074688e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank Cited Paper Year Venue Pagerank
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00047863192
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047731453
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
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
275 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00022413521
283 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022214789
448 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00018129161
454 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017962189
866 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013381261
1,077 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012154948
1,404 Towards an Analysis of Range Query Performance in Spatial Data Structures 1993 PODS 0.00010767648
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 275 Optimal Histograms with Quality Guarantees 1998 VLDB
2 9,976 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD
3 1,508 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD
4 283 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
5 2,140 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB
6 866 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD
7 169 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD
8 37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD
9 9,818 Hierarchically Organized Skew-Tolerant Histograms for Geographic Data Objects 2010 SIGMOD
10 119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD