DBScholar

Back to papers

Join Synopses for Approximate Query Answering

Summary: Join synopses enable accurate approximate answers for join queries using only statistics. A single synopsis per relation boosts FK-join accuracy; the work provides optimal and heuristic space allocation under known workloads, plus incremental maintenance and extensive TPC-D experiments. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h51f52fff9f5825bc
Venue
SIGMOD
Year
1999
Pagerank
0.00029618887
Overall Rank
138 | 99.08%
DOI
10.1145/304182.304207

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{acharya_sigmod99,
        title = {{Join Synopses for Approximate Query Answering}},
        author = {Acharya, Swarup and Gibbons, Phillip B. and Poosala, Viswanath and Ramaswamy, Sridhar},
        series = {{SIGMOD} '99},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/304182.304207},
        url = {https://dl.acm.org/doi/10.1145/304182.304207},
        year = {1999}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 87 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
267 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00022713652
286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022112534
309 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021376597
335 The Aqua Approximate Query Answering System 1999 SIGMOD 0.000206533
370 Evaluating Probabilistic Queries over Imprecise Data 2003 SIGMOD 0.00019837998
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.0001971778
429 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018445263
564 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00016297598
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016244162
644 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015209065
772 VerdictDB: Universalizing Approximate Query Processing 2018 SIGMOD 0.0001409096
795 Random Sampling over Joins Revisited 2018 SIGMOD 0.00013934719
837 Proactive Re-Optimization 2005 SIGMOD 0.00013551072
843 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013534623
867 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013376165
930 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00013009255
947 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00012920489
1,058 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012224038
1,173 Wavelet Synopses with Error Guarantees 2002 SIGMOD 0.0001168187
1,182 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00011615497
1,608 SciBORQ: Scientific data management with Bounds On Runtime and Quality 2011 CIDR 0.00010085907
1,678 Two-Level Sampling for Join Size Estimation 2017 SIGMOD 9.9056116e-05
1,828 DBEst: Revisiting Approximate Query Processing Engines with Machine Learning Models 2019 SIGMOD 9.547768e-05
1,892 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4150583e-05
1,916 The Analytical Bootstrap: a New Method for Fast Error Estimation in Approximate Query Processing 2014 SIGMOD 9.3822742e-05
2,028 Database Learning: Toward a Database that Becomes Smarter Every Time 2017 SIGMOD 9.1584244e-05
2,320 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.6429103e-05
2,324 Online Maintenance of Very Large Random Samples 2004 SIGMOD 8.6332031e-05
2,432 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4742372e-05
2,455 A Sampling Algebra for Aggregate Estimation 2013 VLDB 8.4377251e-05
2,654 A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries 2001 SIGMOD 8.1670397e-05
2,719 Partial Results in Database Systems 2014 SIGMOD 8.0942034e-05
2,754 Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams 2003 VLDB 8.0512921e-05
2,757 Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration 2020 PODS 8.0487636e-05
2,890 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9010819e-05
3,092 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 7.6548729e-05
3,208 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5355264e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3726415e-05
3,494 On Join Sampling and the Hardness of Combinatorial Output-Sensitive Join Algorithms 2023 PODS 7.2548566e-05
3,852 Graph-Based Synopses for Relational Selectivity Estimation 2006 SIGMOD 6.9756022e-05
3,872 A Bi-Level Bernoulli Scheme for Database Sampling 2004 SIGMOD 6.9512121e-05
3,904 Distributed Online Aggregations 2009 VLDB 6.9307047e-05
4,267 Buffer Pool Aware Query Optimization 2005 CIDR 6.6936093e-05
4,418 Deterministic Wavelet Thresholding for Maximum-Error Metrics 2004 PODS 6.6058591e-05
4,452 Bounded Conjunctive Queries 2014 VLDB 6.5918046e-05
4,644 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD 6.4869417e-05
5,598 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0690976e-05
5,610 Responsible Data Integration: Next-generation Challenges 2022 SIGMOD 6.0660772e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0023943337
9 Online Aggregation 1997 SIGMOD 0.00076265429
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.0004772731
58 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00040025054
77 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00036817139
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036476265
153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.00028621958
232 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.0002378554
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023354266
335 The Aqua Approximate Query Answering System 1999 SIGMOD 0.000206533
746 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014282427
1,467 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010563809
2,164 Selectivity Estimation in Spatial Databases 1999 SIGMOD 8.9309999e-05
3,004 The Ins and Outs (and Everything in Between) of Data Warehousing 1996 SIGMOD 7.7627215e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,829 Joins on Samples: A Theoretical Guide for Practitioners 2020 VLDB
2 2,654 A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries 2001 SIGMOD
3 7,471 Reservoir Sampling over Joins 2024 SIGMOD
4 5,492 Compressed Representations of Conjunctive Query Results 2018 PODS
5 3,994 Guaranteeing the O~(AGM/OUT) Runtime for Uniform Sampling and Size Estimation over Joins 2023 PODS
6 1,431 Approximate Join Processing Over Data Streams 2003 SIGMOD
7 153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD
8 10,398 Towards Output-Optimal Uniform Sampling and Approximate Counting for Join-Project Queries 2026 PODS
9 4,644 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD
10 7,496 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS