Depth Estimation for Ranking Query Optimization

Summary: DEEP estimates rank-join input depth—the key cost driver—by modeling the joint score distribution across base tables. Efficient algorithms integrate this principled, data-aware framework into optimizers, outperforming prior estimation techniques. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hdeb5ee2b9e96a7a3
Venue: VLDB
Year: 2007
Pagerank: 5.5722715e-05
Overall Rank: 7,249 | 51.28%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Karl Schnaitter (University of California Santa Cruz)
2. Joshua Spiegel (BEA Systems)
3. Neoklis Polyzotis (University of California Santa Cruz)

BibTeX Citation

@article{schnaitter_vldb07,
        title = {{Depth Estimation for Ranking Query Optimization}},
        author = {Schnaitter, Karl and Spiegel, Joshua and Polyzotis, Neoklis},
        journal = {PVLDB},
        series = {{VLDB} '07},
        pages = {902--913},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,615	Evaluating Rank Joins with Optimal Cost	2008	PODS	8.2217676e-05
4,745	Optimal Join Algorithms Meet Top-k	2020	SIGMOD	6.4369578e-05
5,233	Robust and Efficient Algorithms for Rank Join Evaluation	2009	SIGMOD	6.2167391e-05
5,770	Proximity Rank Join	2010	VLDB	5.9979126e-05
7,828	Sharing Work in Keyword Search over Databases	2011	SIGMOD	5.4434032e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
5	Optimal Aggregation Algorithms for Middleware [Extended Abstract]	2001	PODS	0.0010679903
37	Improved Histograms for Selectivity Estimation of Range Predicates	1996	SIGMOD	0.0004772731
91	On the Propagation of Errors in the Size of Join Results	1991	SIGMOD	0.00034748721
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029618887
169	Wavelet-Based Histograms for Selectivity Estimation	1998	SIGMOD	0.00027126333
253	Approximate Medians and other Quantiles in One Pass and with Limited Memory	1998	SIGMOD	0.00023047482
309	Approximate Query Processing Using Wavelets	2000	VLDB	0.00021376597
448	Histogram-Based Approximation of Set-Valued Query Answers	1999	VLDB	0.00018121533
524	Supporting Top-k Join Queries in Relational Databases	2003	VLDB	0.00016902116
962	RankSQL: Query Algebra and Optimization for Relational Top-k Queries	2005	SIGMOD	0.00012818013
1,773	Rank-aware Query Optimization	2004	SIGMOD	9.6683429e-05
3,852	Graph-Based Synopses for Relational Selectivity Estimation	2006	SIGMOD	6.9756022e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	15	How Good Are Query Optimizers, Really?	2016	VLDB
2	7,603	On the Calculation of Optimality Ranges for Relational Query Execution Plans	2018	SIGMOD
3	272	An Overview of Query Optimization in Relational Systems	1998	PODS
4	12,683	Efficient Rank Join with Aggregation Constraints	2011	VLDB
5	10,519	Succinct Structure Representations for Efficient Query Optimization	2026	SIGMOD
6	2,615	Evaluating Rank Joins with Optimal Cost	2008	PODS
7	7,031	The Case for Deep Query Optimisation	2020	CIDR
8	962	RankSQL: Query Algebra and Optimization for Relational Top-k Queries	2005	SIGMOD
9	9,342	Deep Query Optimization	2019	SIGMOD
10	1,773	Rank-aware Query Optimization	2004	SIGMOD