Database Paper Browser

Back to papers

Consistent Histograms In The Presence of Distinct Value Counts

Summary: Proposes consistent histograms from query feedback that account for distinct value counts and cardinalities. Compares EM-based entropy maximization, accurate but costly, with a one-pass L2-minimization, yielding similar accuracy at lower cost. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9909
Venue
VLDB
Year
2009
Pagerank
4.666214e-05
Overall Rank
7,728 | 46.24%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank Citing Paper Year Venue Pagerank
1,737 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00010720294
5,977 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 5.2455909e-05
7,457 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD 4.7247191e-05
7,467 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 4.7218691e-05
7,645 Selectivity Estimation on Streaming Spatio-Textual Data Using Local Correlations 2015 VLDB 4.6896215e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

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

Rank Cited Paper Year Venue Pagerank
18 On Random Sampling over Joins 1999 SIGMOD 0.00092385438
64 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00063612837
182 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00036962631
252 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00030632263
326 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00027358981
327 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00027308479
512 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00021380733
529 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020828852
549 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00020376603
790 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.0001663283
852 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00015941524
1,695 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 0.00010882793
2,137 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 9.4719326e-05
2,356 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 8.9620762e-05
3,013 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 7.7137441e-05
3,619 Fast Algorithms For Hierarchical Range Histogram Construction 2002 PODS 6.9084829e-05
4,017 Optimal Histograms for Hierarchical Range Queries (Extended Abstract) 2000 PODS 6.524501e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
361 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00025775749
6,244 Approximate Distinct Counts for Billions of Datasets 2019 SIGMOD 5.139669e-05
1,695 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 0.00010882793
1,120 Global Optimization of Histograms 2001 SIGMOD 0.00013856211
326 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00027358981
852 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00015941524
116 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00046148737
8,893 Histograms Reloaded: The Merits of Bucket Diversity 2010 SIGMOD 4.4275272e-05
529 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020828852
327 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00027308479