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 32 of 82 citing papers.

Rank Citing Paper Year Venue Pagerank
4,329 MNC: Structure-Exploiting Sparsity Estimation for Matrix Expressions 2019 SIGMOD 6.64569e-05
4,971 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3209003e-05
4,981 Similarity Join Size Estimation using Locality Sensitive Hashing 2011 VLDB 6.3161219e-05
5,029 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.2952031e-05
5,044 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.2888728e-05
5,056 Lightweight Cardinality Estimation in LSM-based Systems 2018 SIGMOD 6.282339e-05
5,505 Automatic Optimization of Matrix Implementations for Distributed Machine Learning and Linear Algebra 2021 SIGMOD 6.0884328e-05
5,611 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0498181e-05
5,854 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9520525e-05
5,986 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 5.9085861e-05
6,128 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 5.860258e-05
6,816 ROX: Run-time Optimization of XQueries 2009 SIGMOD 5.6593309e-05
6,906 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.634971e-05
7,266 Depth Estimation for Ranking Query Optimization 2007 VLDB 5.55407e-05
7,432 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 5.5133928e-05
7,512 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS 5.490671e-05
7,584 Histograms Revisited: When are histograms the best approximation method for aggregates over joins? 2005 PODS 5.4749539e-05
7,782 Adaptive Factorization Using Linear-Chained Hash Tables 2025 CIDR 5.4368388e-05
8,060 JoinSketch: A Sketch Algorithm for Accurate and Unbiased Inner-Product Estimation 2023 SIGMOD 5.382134e-05
8,188 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 5.3649397e-05
8,361 MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates 2020 SIGMOD 5.3310744e-05
8,363 alpha to omega: The Greek Alphabet of Sampling 2020 CIDR 5.3305234e-05
8,780 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 5.2650571e-05
9,753 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1159926e-05
10,327 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.0241309e-05
10,571 Prism: Private Relational Data Synthesis with Language Models 2026 SIGMOD 4.9605343e-05
10,676 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 4.9605343e-05
10,771 Sample-based Distinct Cardinality Estimation for Multiple Attributes in Multi-Dataset Queries 2026 VLDB 4.9605343e-05
10,988 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9605343e-05
11,321 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9605343e-05
11,344 Evaluating Methods for Efficient Entity Count Estimation 2025 VLDB 4.9605343e-05
11,564 Sub-optimal Join Order Identification with L1-error 2024 SIGMOD 4.9605343e-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
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