DBScholar

Back to papers

On the Propagation of Errors in the Size of Join Results

Summary: Formal framework for how errors in statistics propagate to join size estimates and optimizer plans. Analyzes general, extreme, and average-case propagation; derives guarantees for statistics-driven plans; outlines strategies to control error growth. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hbeeda4265fc3e3e2
Venue
SIGMOD
Year
1991
Pagerank
0.00034691614
Overall Rank
91 | 99.40%
DOI
10.1145/115790.115835

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{ioannidis_sigmod91,
        title = {{On the Propagation of Errors in the Size of Join Results}},
        author = {Ioannidis, Yannis E. and Christodoulakis, Stavros},
        series = {{SIGMOD} '91},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/115790.115835},
        url = {https://dl.acm.org/doi/10.1145/115790.115835},
        year = {1991}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 82 citing papers.

Rank Citing Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047654188
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
149 Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans 1998 SIGMOD 0.00028910892
234 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023726296
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023327437
254 The History of Histograms (abridged) 2003 VLDB 0.00022999992
285 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022143946
291 Optimization of Dynamic Query Evaluation Plans 1994 SIGMOD 0.00021898776
318 Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems 2018 PODS 0.00021178303
374 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019698889
381 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019497061
397 Worst-case Optimal Join Algorithms 2012 PODS 0.0001911958
471 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.00017691682
568 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016221103
689 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014725904
838 Proactive Re-Optimization 2005 SIGMOD 0.00013528646
1,061 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012207625
1,086 On B-tree Indices for Skewed Distributions 1992 VLDB 0.00012069306
1,134 Dremel: A Decade of Interactive SQL Analysis at Web Scale 2020 VLDB 0.00011863043
1,143 Beyond Uniformity and Independence : Analysis of R-trees Using the Concept of Fractal Dimension 1994 PODS 0.00011810737
1,296 From Theory to Practice: Efficient Join Query Evaluation in a Parallel Database System 2015 SIGMOD 0.00011119184
1,436 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010658836
1,511 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010408003
1,541 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB 0.00010288394
1,587 Estimating Progress of Execution for SQL Queries 2004 SIGMOD 0.00010119368
1,603 Adopting Worst-Case Optimal Joins in Relational Database Systems 2020 VLDB 0.00010090639
1,693 Global Optimization of Histograms 2001 SIGMOD 9.8377504e-05
1,754 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.7111856e-05
1,935 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 9.3407959e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.2323722e-05
2,009 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.1813272e-05
2,167 DIFF: A Relational Interface for Large-Scale Data Explanation 2019 VLDB 8.9166414e-05
2,228 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.7912743e-05
2,329 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.6188984e-05
2,730 Partial Results in Database Systems 2014 SIGMOD 8.0676725e-05
2,838 Estimating the Selectivity of Spatial Queries Using the 'Correlation' Fractal Dimension 1995 VLDB 7.9401525e-05
2,852 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9201312e-05
2,888 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.8895201e-05
2,972 Scalable and Adaptive Online Joins 2014 VLDB 7.7844791e-05
3,104 On Optimizing Operator Fusion Plans for Large-Scale Machine Learning in SystemML 2018 VLDB 7.6281929e-05
3,361 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3621595e-05
3,531 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.2065332e-05
3,558 Lazy, Adaptive RID-List Intersection, and Its Application to Index Anding 2007 SIGMOD 7.1850547e-05
3,662 Scalable Computation of Acyclic Joins (Extended Abstract) 2006 PODS 7.1009211e-05
3,941 Big Metadata: When Metadata is Big Data 2021 VLDB 6.8939123e-05
3,977 Estimation of Query-Result Distribution and its Application in Parallel-Join Load Balancing 1996 VLDB 6.8707656e-05
4,088 Dynamically Optimizing Queries over Large Scale Data Platforms 2014 SIGMOD 6.7973616e-05
4,210 Adaptive Work Placement for Query Processing on Heterogeneous Computing Resources 2017 VLDB 6.7206837e-05
4,260 Buffer Pool Aware Query Optimization 2005 CIDR 6.6824533e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

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

Rank Cited Paper Year Venue Pagerank
345 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020445813
396 R* Optimizer Validation and Performance Evaluation for Local Queries 1986 SIGMOD 0.00019119719
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 144 Optimization of Nonrecursive Queries 1986 VLDB
2 1,516 Computing Joins Of Relations 1975 SIGMOD
3 1,603 Adopting Worst-Case Optimal Joins in Relational Database Systems 2020 VLDB
4 4,905 Evaluation Of The Size Of A Query Expressed In Relational Algebra 1981 SIGMOD
5 7,512 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS
6 397 Worst-case Optimal Join Algorithms 2012 PODS
7 318 Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems 2018 PODS
8 432 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS
9 2,151 Optimization of Multi-Way Join Queries for Parallel Execution 1991 VLDB
10 1,185 Adaptive Optimization of Very Large Join Queries 2018 SIGMOD