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.0003475226
Overall Rank
91 | 99.39%
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 32 of 82 citing papers.

Rank Citing Paper Year Venue Pagerank
4,330 MNC: Structure-Exploiting Sparsity Estimation for Matrix Expressions 2019 SIGMOD 6.6595681e-05
4,950 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3421691e-05
4,958 Similarity Join Size Estimation using Locality Sensitive Hashing 2011 VLDB 6.3394776e-05
5,003 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.3188773e-05
5,022 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.3100988e-05
5,044 Lightweight Cardinality Estimation in LSM-based Systems 2018 SIGMOD 6.30014e-05
5,597 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0718206e-05
5,865 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9659203e-05
5,973 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 5.9306716e-05
6,113 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 5.8823242e-05
6,169 Automatic Optimization of Matrix Implementations for Distributed Machine Learning and Linear Algebra 2021 SIGMOD 5.8624857e-05
6,800 ROX: Run-time Optimization of XQueries 2009 SIGMOD 5.6792071e-05
6,884 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.6563432e-05
7,247 Depth Estimation for Ranking Query Optimization 2007 VLDB 5.5748328e-05
7,410 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 5.5342768e-05
7,493 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS 5.5103311e-05
7,568 Histograms Revisited: When are histograms the best approximation method for aggregates over joins? 2005 PODS 5.49478e-05
7,774 Adaptive Factorization Using Linear-Chained Hash Tables 2025 CIDR 5.4549846e-05
8,035 JoinSketch: A Sketch Algorithm for Accurate and Unbiased Inner-Product Estimation 2023 SIGMOD 5.4025473e-05
8,164 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 5.3852872e-05
8,345 MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates 2020 SIGMOD 5.3511996e-05
8,347 alpha to omega: The Greek Alphabet of Sampling 2020 CIDR 5.350539e-05
8,751 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 5.284914e-05
9,718 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1353964e-05
10,294 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.0431863e-05
10,494 Prism: Private Relational Data Synthesis with Language Models 2026 SIGMOD 4.9793485e-05
10,604 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 4.9793485e-05
10,700 Sample-based Distinct Cardinality Estimation for Multiple Attributes in Multi-Dataset Queries 2026 VLDB 4.9793485e-05
10,918 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9793485e-05
11,257 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9793485e-05
11,280 Evaluating Methods for Efficient Entity Count Estimation 2025 VLDB 4.9793485e-05
11,507 Sub-optimal Join Order Identification with L1-error 2024 SIGMOD 4.9793485e-05
Previous Page 2 / 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
344 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020461727
397 R* Optimizer Validation and Performance Evaluation for Local Queries 1986 SIGMOD 0.00019157058
Previous Page 1 / 1 Next

Semantically Similar Papers