DBScholar

Back to papers

Synopses for Query Optimization: A Space-Complexity Perspective

Summary: Information-theoretic analysis of synopsis space: histograms suffice for single-table selections but are fundamentally limited for joins. For key–foreign-key joins, small precomputed samples yield nearly space-optimal probabilistic guarantees; experiments confirm samples outperform histograms as joins increase. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
hfc96da85ca314f10
Venue
PODS
Year
2004
Pagerank
5.5081355e-05
Overall Rank
7,496 | 49.62%
DOI
10.1145/1055558.1055586

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{kaushik_pods04,
        address = {New York, NY, USA},
        series = {{PODS} '04},
        title = {{Synopses for Query Optimization: A Space-Complexity Perspective}},
        url = {https://dl.acm.org/doi/10.1145/1055558.1055586},
        doi = {10.1145/1055558.1055586},
        booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
        publisher = {Association for Computing Machinery},
        author = {Kaushik, Raghav and Ramakrishnan, Raghu and Chakaravarthy, Venkatesan T.},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank Citing Paper Year Venue Pagerank
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019050182
4,299 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6766173e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

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

Rank Cited Paper Year Venue Pagerank
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00047864281
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.0004772731
57 On Random Sampling over Joins 1999 SIGMOD 0.00040095727
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036476265
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00034748721
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.0003136296
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029618887
175 Simple Random Sampling from Relational Databases 1986 VLDB 0.00026776696
222 Approximate Computation of Multidimensional Aggregates of Sparse Data Using Wavelets 1999 SIGMOD 0.00024210103
242 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023354266
275 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00022404363
284 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022205848
346 Sequential Sampling Procedures For Query Size Estimation 1992 SIGMOD 0.00020320726
429 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018445263
806 Universality of Serial Histograms 1993 VLDB 0.00013786471
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
3,568 On the Complexity of Approximate Query Optimization 2002 PODS 7.1978817e-05
3,646 Optimal Histograms for Hierarchical Range Queries (Extended Abstract) 2000 PODS 7.1368554e-05
Previous Page 1 / 1 Next

Semantically Similar Papers