DBScholar

Back to papers

Optimal Histograms with Quality Guarantees

Summary: Optimal histograms with quality guarantees: compute bucket boundaries to minimize error for a fixed bucket count under broad metrics (incl. V-Optimality); time O(d^2) in distinct values. Also offers fast heuristics with provable space–accuracy tradeoffs and per-selectivity guarantees to isolate outliers. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h111c762a5fbf3617
Venue
VLDB
Year
1998
Pagerank
0.00022404363
Overall Rank
275 | 98.16%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{jagadish_vldb98,
        title = {{Optimal Histograms with Quality Guarantees}},
        author = {Jagadish, H. V. and Koudas, Nick and Muthukrishnan, S. and Poosala, Viswanath and Sevcik, Ken and Suel, Torsten},
        journal = {PVLDB},
        series = {{VLDB} '98},
        pages = {275--286},
        year = {1998}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 66 citing papers.

Rank Citing Paper Year Venue Pagerank
26 Models and Issues in Data Stream Systems 2002 PODS 0.00052097907
255 The History of Histograms (abridged) 2003 VLDB 0.00022974524
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019822444
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.0001971778
386 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019446558
402 Worst-case Optimal Join Algorithms 2012 PODS 0.00019095982
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016244162
743 Dynamic Multidimensional Histograms 2002 SIGMOD 0.00014309723
1,078 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012149796
1,155 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011777046
1,462 Substring Selectivity Estimation 1999 PODS 0.00010578962
1,530 A Data- and Workload-Aware Algorithm for Range Queries Under Differential Privacy 2014 VLDB 0.00010345019
1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010177136
1,687 Global Optimization of Histograms 2001 SIGMOD 9.8614576e-05
1,743 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.7342409e-05
1,895 Efficient Computation of Reverse Skyline Queries 2007 VLDB 9.4125147e-05
2,094 Selectivity Estimation For Boolean Queries 2000 PODS 9.0536495e-05
2,301 Principled Evaluation of Differentially Private Algorithms using DPBench 2016 SIGMOD 8.6690677e-05
2,360 Online Outlier Detection in Sensor Data Using Non-Parametric Models 2006 VLDB 8.5774153e-05
2,434 DDSketch: A Fast and Fully-Mergeable Quantile Sketch with Relative-Error Guarantees 2019 VLDB 8.4726771e-05
2,690 Quality and Efficiency in Kernel Density Estimates for Large Data 2013 SIGMOD 8.1226926e-05
2,808 Sampling Time-Based Sliding Windows in Bounded Space 2008 SIGMOD 7.9788841e-05
3,164 REHIST: Relative Error Histogram Construction Algorithms 2004 VLDB 7.5756378e-05
3,282 Kernel-Based Skyline Cardinality Estimation 2009 SIGMOD 7.4548746e-05
3,303 Optimal and Approximate Computation of Summary Statistics for Range Aggregates 2001 PODS 7.4400795e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3726415e-05
3,380 Ad-hoc Top-k Query Answering for Data Streams 2007 VLDB 7.353368e-05
3,563 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2023194e-05
3,646 Optimal Histograms for Hierarchical Range Queries (Extended Abstract) 2000 PODS 7.1368554e-05
4,118 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB 6.7927394e-05
4,463 DigitHist: a Histogram-Based Data Summary with Tight Error Bounds 2017 VLDB 6.5861255e-05
4,933 Space efficiency in Synopsis construction algorithms 2005 VLDB 6.3454089e-05
4,936 A Comparison of Selectivity Estimators for Range Queries on Metric Attributes 1999 SIGMOD 6.3447021e-05
5,007 Fast Algorithms For Hierarchical Range Histogram Construction 2002 PODS 6.3156906e-05
5,025 Adaptive Sampling for Rapidly Matching Histograms 2018 VLDB 6.3078009e-05
5,160 NashDB: An End-to-End Economic Method for Elastic Database Fragmentation, Replication, and Provisioning 2018 SIGMOD 6.2454263e-05
5,535 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS 6.0905677e-05
5,581 Bloom Histogram: Path Selectivity Estimation for XML Data with Updates 2004 VLDB 6.0741907e-05
5,653 Building Wavelet Histograms on Large Data in MapReduce 2012 VLDB 6.048773e-05
6,034 Hierarchical Subspace Sampling: A Unified Framework for High Dimensional Data Reduction, Selectivity Estimation and Nearest Neighbor Search 2002 SIGMOD 5.9073944e-05
6,202 Combining Aggregation and Sampling (Nearly) Optimally for Approximate Query Processing 2021 SIGMOD 5.8494367e-05
6,226 A Forward Scan based Plane Sweep Algorithm for Parallel Interval Joins 2017 VLDB 5.8430153e-05
6,559 Optimal Splitters for Temporal and Multi-version Databases 2013 SIGMOD 5.7471016e-05
6,643 Approximating and Testing k-Histogram Distributions in Sub-linear Time 2012 PODS 5.7233159e-05
6,750 Categorical Skylines for Streaming Data 2008 SIGMOD 5.6881113e-05
6,786 Robust Estimation With Sampling and Approximate Pre-Aggregation 2003 VLDB 5.6811262e-05
7,368 Weighted Distinct Sampling: Cardinality Estimation for SPJ Queries 2021 SIGMOD 5.5392867e-05
7,496 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS 5.5081355e-05
7,506 Pythia: Data Dependent Differentially Private Algorithm Selection 2017 SIGMOD 5.5051028e-05
7,517 Compact Histograms for Hierarchical Identifiers 2006 VLDB 5.5025167e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 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.00047864281
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.0004772731
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036476265
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033884854
175 Simple Random Sampling from Relational Databases 1986 VLDB 0.00026776696
284 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022205848
346 Sequential Sampling Procedures For Query Size Estimation 1992 SIGMOD 0.00020320726
806 Universality of Serial Histograms 1993 VLDB 0.00013786471
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,535 Fast and Near–Optimal Algorithms for Approximating Distributions by Histograms 2015 PODS
2 806 Universality of Serial Histograms 1993 VLDB
3 169 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD
4 119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD
5 37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD
6 9,151 Histograms Reloaded: The Merits of Bucket Diversity 2010 SIGMOD
7 3,646 Optimal Histograms for Hierarchical Range Queries (Extended Abstract) 2000 PODS
8 448 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB
9 284 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD
10 1,687 Global Optimization of Histograms 2001 SIGMOD