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
3168
Venue
SIGMOD
Year
1999
Pagerank
0.00030123303
Overall Rank
136 | 99.07%
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.00052982574
255 Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports 2001 VLDB 0.00023174541
257 The History of Histograms (abridged) 2003 VLDB 0.00023154793
280 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022454217
307 Approximate Query Processing Using Wavelets 2000 VLDB 0.00021792475
327 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00021091539
359 Evaluating Probabilistic Queries over Imprecise Data 2003 SIGMOD 0.0002023153
363 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.0002005475
418 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018812821
553 Congressional Samples for Approximate Answering of Group-By Queries 2000 SIGMOD 0.00016590619
566 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016436005
664 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015167825
772 VerdictDB: Universalizing Approximate Query Processing 2018 SIGMOD 0.00014147905
802 Random Sampling over Joins Revisited 2018 SIGMOD 0.00013907725
817 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013823702
829 Proactive Re-Optimization 2005 SIGMOD 0.00013769838
850 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013619394
909 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00013291205
931 Aqua: A Fast Decision Support System Using Approximate Query Answers 1999 VLDB 0.00013125812
1,071 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012322342
1,156 Wavelet Synopses with Error Guarantees 2002 SIGMOD 0.00011929041
1,166 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00011850439
1,582 SciBORQ: Scientific data management with Bounds On Runtime and Quality 2011 CIDR 0.00010295367
1,664 Two-Level Sampling for Join Size Estimation 2017 SIGMOD 0.00010070362
1,799 DBEst: Revisiting Approximate Query Processing Engines with Machine Learning Models 2019 SIGMOD 9.7326398e-05
1,872 The Analytical Bootstrap: a New Method for Fast Error Estimation in Approximate Query Processing 2014 SIGMOD 9.5759874e-05
1,893 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.5269935e-05
1,995 Database Learning: Toward a Database that Becomes Smarter Every Time 2017 SIGMOD 9.3403665e-05
2,270 When Can We Trust Progress Estimators for SQL Queries? 2005 SIGMOD 8.8310714e-05
2,271 Online Maintenance of Very Large Random Samples 2004 SIGMOD 8.8254873e-05
2,404 Cardinality Estimation Using Sample Views with Quality Assurance 2007 SIGMOD 8.6225576e-05
2,413 A Sampling Algebra for Aggregate Estimation 2013 VLDB 8.6116764e-05
2,608 A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries 2001 SIGMOD 8.347674e-05
2,663 Partial Results in Database Systems 2014 SIGMOD 8.2818137e-05
2,777 Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration 2020 PODS 8.1352657e-05
2,944 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9335187e-05
3,162 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.6785856e-05
3,228 Correlation Sketches for Approximate Join-Correlation Queries 2021 SIGMOD 7.6215176e-05
3,255 Processing Sliding Window Multi-Joins in Continuous Queries over Data Streams 2003 VLDB 7.591663e-05
3,309 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD 7.5368417e-05
3,453 On Join Sampling and the Hardness of Combinatorial Output-Sensitive Join Algorithms 2023 PODS 7.4004131e-05
3,788 Graph-Based Synopses for Relational Selectivity Estimation 2006 SIGMOD 7.1244416e-05
3,803 A Bi-Level Bernoulli Scheme for Database Sampling 2004 SIGMOD 7.1114677e-05
3,844 Distributed Online Aggregations 2009 VLDB 7.0782059e-05
4,197 Buffer Pool Aware Query Optimization 2005 CIDR 6.8406917e-05
4,325 Deterministic Wavelet Thresholding for Maximum-Error Metrics 2004 PODS 6.7605683e-05
4,393 Bounded Conjunctive Queries 2014 VLDB 6.7280426e-05
4,630 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD 6.5955933e-05
5,510 Responsible Data Integration: Next-generation Challenges 2022 SIGMOD 6.1919207e-05
5,514 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.1901666e-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.0024089429
9 Online Aggregation 1997 SIGMOD 0.00077458002
35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00048481081
55 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00040746149
75 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00037277061
76 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00037054261
149 New Sampling-Based Summary Statistics for Improving Approximate Query Answers 1998 SIGMOD 0.00029226907
222 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00024193708
235 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023783792
327 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00021091539
730 Bifocal Sampling for Skew-Resistant Join Size Estimation 1996 SIGMOD 0.00014539362
1,440 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010778889
2,127 Selectivity Estimation in Spatial Databases 1999 SIGMOD 9.127762e-05
2,943 The Ins and Outs (and Everything in Between) of Data Warehousing 1996 SIGMOD 7.9348214e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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