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.00029627449
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.00052121228
255 The History of Histograms (abridged) 2003 VLDB 0.00022981861
267 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00022722971
286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.0002211981
309 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021384073
336 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00020657819
370 Evaluating Probabilistic Queries over Imprecise Data 2003 SIGMOD 0.00019846702
372 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019720059
428 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.0001845349
564 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00016296665
569 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016245271
646 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.0001520859
784 VerdictDB: Universalizing Approximate Query Processing 2018 SIGMOD 0.00014012614
795 Random Sampling over Joins Revisited 2018 SIGMOD 0.00013938779
836 Proactive Re-Optimization 2005 SIGMOD 0.00013557047
842 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013540697
866 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013381261
931 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00013011667
948 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00012914559
1,060 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012224575
1,173 Wavelet Synopses with Error Guarantees 2002 SIGMOD 0.00011686985
1,183 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00011616705
1,607 SciBORQ: Scientific data management with Bounds On Runtime and Quality 2011 CIDR 0.0001008742
1,678 Two-Level Sampling for Join Size Estimation 2017 SIGMOD 9.9088372e-05
1,829 DBEst: Revisiting Approximate Query Processing Engines with Machine Learning Models 2019 SIGMOD 9.5510333e-05
1,891 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4184294e-05
1,916 The Analytical Bootstrap: a New Method for Fast Error Estimation in Approximate Query Processing 2014 SIGMOD 9.3837729e-05
2,027 Database Learning: Toward a Database that Becomes Smarter Every Time 2017 SIGMOD 9.1618139e-05
2,318 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.6464837e-05
2,322 Online Maintenance of Very Large Random Samples 2004 SIGMOD 8.6361485e-05
2,433 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4766785e-05
2,456 A Sampling Algebra for Aggregate Estimation 2013 VLDB 8.4377192e-05
2,655 A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries 2001 SIGMOD 8.1706092e-05
2,717 Partial Results in Database Systems 2014 SIGMOD 8.0980367e-05
2,753 Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams 2003 VLDB 8.0549317e-05
2,757 Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration 2020 PODS 8.0525756e-05
2,891 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9021718e-05
3,090 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 7.6584982e-05
3,210 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5363533e-05
3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3760492e-05
3,494 On Join Sampling and the Hardness of Combinatorial Output-Sensitive Join Algorithms 2023 PODS 7.2582926e-05
3,851 Graph-Based Synopses for Relational Selectivity Estimation 2006 SIGMOD 6.9785886e-05
3,871 A Bi-Level Bernoulli Scheme for Database Sampling 2004 SIGMOD 6.9543581e-05
3,905 Distributed Online Aggregations 2009 VLDB 6.9335334e-05
4,267 Buffer Pool Aware Query Optimization 2005 CIDR 6.6967071e-05
4,416 Deterministic Wavelet Thresholding for Maximum-Error Metrics 2004 PODS 6.6089486e-05
4,452 Bounded Conjunctive Queries 2014 VLDB 6.5938977e-05
4,642 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD 6.4898745e-05
5,597 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0718206e-05
5,609 Responsible Data Integration: Next-generation Challenges 2022 SIGMOD 6.0689501e-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.0023947656
9 Online Aggregation 1997 SIGMOD 0.00076195956
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047731453
58 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00040035279
77 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00036828234
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036487763
153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.00028633995
232 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023792809
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023363722
336 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00020657819
745 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014288286
1,467 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010567959
2,162 Selectivity Estimation in Spatial Databases 1999 SIGMOD 8.935022e-05
3,002 The Ins and Outs (and Everything in Between) of Data Warehousing 1996 SIGMOD 7.7661188e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,655 A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries 2001 SIGMOD
2 5,831 Joins on Samples: A Theoretical Guide for Practitioners 2020 VLDB
3 7,467 Reservoir Sampling over Joins 2024 SIGMOD
4 5,489 Compressed Representations of Conjunctive Query Results 2018 PODS
5 3,992 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,386 Towards Output-Optimal Uniform Sampling and Approximate Counting for Join-Project Queries 2026 PODS
9 4,642 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD
10 7,493 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS