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
2597
Venue
SIGMOD
Year
1991
Pagerank
0.00035031529
Overall Rank
89 | 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 31 of 81 citing papers.

Rank Citing Paper Year Venue Pagerank
4,481 Dynamically Optimizing Queries over Large Scale Data Platforms 2014 SIGMOD 6.6754521e-05
4,857 Similarity Join Size Estimation using Locality Sensitive Hashing 2011 VLDB 6.4752373e-05
4,900 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.4534715e-05
4,945 Lightweight Cardinality Estimation in LSM-based Systems 2018 SIGMOD 6.4321265e-05
5,010 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.4023732e-05
5,514 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.1901666e-05
5,529 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.18591e-05
5,860 Understanding Cardinality Estimation using Entropy Maximization 2010 PODS 6.0636893e-05
6,019 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 6.0060149e-05
6,046 Automatic Optimization of Matrix Implementations for Distributed Machine Learning and Linear Algebra 2021 SIGMOD 5.9956597e-05
6,323 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9141228e-05
6,688 ROX: Run-time Optimization of XQueries 2009 SIGMOD 5.8015211e-05
6,760 LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries 2024 SIGMOD 5.7826781e-05
7,123 Depth Estimation for Ranking Query Optimization 2007 VLDB 5.6966694e-05
7,388 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS 5.6268292e-05
7,443 Histograms Revisited: When are histograms the best approximation method for aggregates over joins? 2005 PODS 5.6166792e-05
8,183 alpha to omega: The Greek Alphabet of Sampling 2020 CIDR 5.4714466e-05
8,211 MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates 2020 SIGMOD 5.4658735e-05
8,232 Adaptive Factorization Using Linear-Chained Hash Tables 2025 CIDR 5.4612012e-05
8,494 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 5.4142129e-05
8,601 Goals and Benchmarks for Autonomic Configuration Recommenders 2005 SIGMOD 5.4048965e-05
9,027 JoinSketch: A Sketch Algorithm for Accurate and Unbiased Inner-Product Estimation 2023 SIGMOD 5.3293224e-05
9,756 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 5.2258278e-05
9,958 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1879626e-05
10,282 Prism: Private Relational Data Synthesis with Language Models 2026 SIGMOD 5.093636e-05
10,413 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 5.093636e-05
10,515 Sample-based Distinct Cardinality Estimation for Multiple Attributes in Multi-Dataset Queries 2026 VLDB 5.093636e-05
10,851 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 5.093636e-05
10,875 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.093636e-05
10,878 Evaluating Methods for Efficient Entity Count Estimation 2025 VLDB 5.093636e-05
11,160 Sub-optimal Join Order Identification with L1-error 2024 SIGMOD 5.093636e-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
342 R* Optimizer Validation and Performance Evaluation for Distributed Queries 1986 VLDB 0.00020673706
396 R* Optimizer Validation and Performance Evaluation for Local Queries 1986 SIGMOD 0.00019287574
Previous Page 1 / 1 Next

Semantically Similar Papers