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.00029532435
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.00051942573
254 The History of Histograms (abridged) 2003 VLDB 0.00022999992
268 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00022654182
287 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022060616
311 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021315058
337 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00020593498
371 Evaluating Probabilistic Queries over Imprecise Data 2003 SIGMOD 0.00019776963
374 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019698889
432 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018400309
564 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00016251304
568 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016221103
646 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015166402
770 VerdictDB: Universalizing Approximate Query Processing 2018 SIGMOD 0.00014086699
793 Random Sampling over Joins Revisited 2018 SIGMOD 0.00013903938
838 Proactive Re-Optimization 2005 SIGMOD 0.00013528646
844 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013498392
868 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013336675
935 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00012968914
951 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00012886042
1,061 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012207625
1,174 Wavelet Synopses with Error Guarantees 2002 SIGMOD 0.0001165008
1,186 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00011581468
1,614 SciBORQ: Scientific data management with Bounds On Runtime and Quality 2011 CIDR 0.00010054823
1,681 Two-Level Sampling for Join Size Estimation 2017 SIGMOD 9.8821344e-05
1,839 DBEst: Revisiting Approximate Query Processing Engines with Machine Learning Models 2019 SIGMOD 9.5187688e-05
1,896 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4010932e-05
1,924 The Analytical Bootstrap: a New Method for Fast Error Estimation in Approximate Query Processing 2014 SIGMOD 9.3535088e-05
2,040 Database Learning: Toward a Database that Becomes Smarter Every Time 2017 SIGMOD 9.1319608e-05
2,329 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.6188984e-05
2,335 Online Maintenance of Very Large Random Samples 2004 SIGMOD 8.6050778e-05
2,438 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.4532693e-05
2,461 A Sampling Algebra for Aggregate Estimation 2013 VLDB 8.4123214e-05
2,661 A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries 2001 SIGMOD 8.1414177e-05
2,730 Partial Results in Database Systems 2014 SIGMOD 8.0676725e-05
2,762 Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams 2003 VLDB 8.025285e-05
2,766 Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration 2020 PODS 8.0221503e-05
2,888 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.8895201e-05
3,093 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 7.6378811e-05
3,212 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5145409e-05
3,371 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.3493132e-05
3,502 On Join Sampling and the Hardness of Combinatorial Output-Sensitive Join Algorithms 2023 PODS 7.2308675e-05
3,858 Graph-Based Synopses for Relational Selectivity Estimation 2006 SIGMOD 6.9543709e-05
3,884 A Bi-Level Bernoulli Scheme for Database Sampling 2004 SIGMOD 6.9285249e-05
3,912 Distributed Online Aggregations 2009 VLDB 6.9103187e-05
4,260 Buffer Pool Aware Query Optimization 2005 CIDR 6.6824533e-05
4,438 Deterministic Wavelet Thresholding for Maximum-Error Metrics 2004 PODS 6.5840202e-05
4,473 Bounded Conjunctive Queries 2014 VLDB 6.570529e-05
4,661 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD 6.4656621e-05
5,611 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0498181e-05
5,622 Responsible Data Integration: Next-generation Challenges 2022 SIGMOD 6.0460189e-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.0023948467
9 Online Aggregation 1997 SIGMOD 0.00076079812
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047654188
58 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00039922419
78 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00036725074
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036394222
153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.0002855087
234 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023726296
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023327437
337 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00020593498
750 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014246313
1,469 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010533259
2,176 Selectivity Estimation in Spatial Databases 1999 SIGMOD 8.9031141e-05
3,015 The Ins and Outs (and Everything in Between) of Data Warehousing 1996 SIGMOD 7.7376493e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 10,585 Succinct Structure Representations for Efficient Query Optimization 2026 SIGMOD
2 2,661 A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries 2001 SIGMOD
3 7,490 Reservoir Sampling over Joins 2024 SIGMOD
4 5,512 Compressed Representations of Conjunctive Query Results 2018 PODS
5 4,011 Guaranteeing the O~(AGM/OUT) Runtime for Uniform Sampling and Size Estimation over Joins 2023 PODS
6 1,439 Approximate Join Processing Over Data Streams 2003 SIGMOD
7 153 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD
8 10,464 Towards Output-Optimal Uniform Sampling and Approximate Counting for Join-Project Queries 2026 PODS
9 4,661 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD
10 7,512 Synopses for Query Optimization: A Space-Complexity Perspective 2004 PODS