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
9910
Venue
VLDB
Year
2009
Pagerank
4.6621296e-05
Overall Rank
7,725 | 46.32%
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,727 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00010731889
5,983 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 5.240797e-05
7,442 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD 4.7248554e-05
7,465 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 4.7186055e-05
7,644 Selectivity Estimation on Streaming Spatio-Textual Data Using Local Correlations 2015 VLDB 4.6853638e-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.00092569117
63 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00063595699
181 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00036970794
250 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00030640525
326 Optimal Histograms with Quality Guarantees 1998 VLDB 0.0002737538
328 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00027301497
512 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00021385343
527 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020862475
550 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00020346247
786 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00016624743
849 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00015919478
1,691 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 0.00010890775
2,136 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 9.4668797e-05
2,359 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 8.967267e-05
3,013 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 7.7082045e-05
3,621 Fast Algorithms For Hierarchical Range Histogram Construction 2002 PODS 6.9022467e-05
4,018 Optimal Histograms for Hierarchical Range Queries (Extended Abstract) 2000 PODS 6.5250686e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
360 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.00025768448
6,243 Approximate Distinct Counts for Billions of Datasets 2019 SIGMOD 5.1348218e-05
1,691 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 0.00010890775
1,116 Global Optimization of Histograms 2001 SIGMOD 0.00013863484
326 Optimal Histograms with Quality Guarantees 1998 VLDB 0.0002737538
849 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00015919478
114 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00046317654
8,893 Histograms Reloaded: The Merits of Bucket Diversity 2010 SIGMOD 4.4232868e-05
527 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020862475
328 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00027301497