Ranked Enumeration of Join Queries with Projections

Summary: Ranked enumeration with projections for join queries; enables ORDER BY with LIMIT. Acyclic queries achieve near-linear delay after preprocessing; star queries allow preprocessing–latency tradeoff; extensible to cycles and unions; experiments show up to 1,000x speedups. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 12615
Venue: VLDB
Year: 2022
Pagerank: 4.8124491e-05
Overall Rank: 7,166 | 50.15%
DOI: 10.14778/3510397.3510401

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,003	Clustering with Set Outliers and Applications in Relational Clustering	2026	PODS	4.1945683e-05
10,483	Fast Hypertree Decompositions via Linear Programming: Fractional and Generalized	2025	SIGMOD	4.1945683e-05
10,924	Improved Approximation Algorithms for Relational Clustering	2024	PODS	4.1945683e-05
10,927	Computing A Well-Representative Summary of Conjunctive Query Results	2024	PODS	4.1945683e-05
10,970	Relational Algorithms for Top-k Query Evaluation	2024	SIGMOD	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 20 of 20 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
7	Optimal Aggregation Algorithms for Middleware [Extended Abstract]	2001	PODS	0.0015496097
502	Worst-case Optimal Join Algorithms	2012	PODS	0.00021526612
536	The LDBC Social Network Benchmark: Interactive Workload	2015	SIGMOD	0.00020722862
583	FAQ: Questions Asked Frequently	2016	PODS	0.00019717214
690	An Analytical Study of Large SPARQL Query Logs	2018	VLDB	0.00018099792
757	Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct	2009	VLDB	0.00017078358
1,259	Aggregation and Ordering in Factorised Databases	2013	VLDB	0.00012995821
1,262	RankSQL: Query Algebra and Optimization for Relational Top-k Queries	2005	SIGMOD	0.00012986539
1,442	What do Shannon-type Inequalities, Submodular Width, and Disjunctive Datalog have to do with one another?	2017	PODS	0.00011956109
2,009	IO-Top-k: Index-access Optimized Top-k Query Processing	2006	VLDB	9.7977564e-05
2,393	Rank-aware Query Optimization	2004	SIGMOD	8.9016542e-05
3,082	FDB: A Query Engine for Factorised Relational Databases	2012	VLDB	7.6014248e-05
3,143	Extracting and Analyzing Hidden Graphs from Relational Databases	2017	SIGMOD	7.4804326e-05
3,715	Optimal Algorithms for Ranked Enumeration of Answers to Full Conjunctive Queries	2020	VLDB	6.8220943e-05
3,781	Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries	2020	PODS	6.7723513e-05
5,962	Beyond Equi-joins: Ranking, Enumeration and Factorization	2021	VLDB	5.2536266e-05
6,882	RankSQL: Supporting Ranking Queries in Relational Database Management Systems	2005	VLDB	4.8963901e-05
7,240	Sum-Max Monotonic Ranked Joins for Evaluating Top-K Twig Queries on Weighted Data Graphs	2007	VLDB	4.792172e-05
7,762	Optimal Enumeration: Efficient Top-k Tree Matching	2015	VLDB	4.6583829e-05
9,627	Modern Lower Bound Techniques in Database Theory and Constraint Satisfaction	2021	PODS	4.3146507e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
7,692	Processing Top-k Join Queries	2010	VLDB	4.6761366e-05
674	Supporting Top-k Join Queries in Relational Databases	2003	VLDB	0.00018327585
12,191	Efficient Rank Join with Aggregation Constraints	2011	VLDB	4.1945683e-05
3,387	Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration	2020	PODS	7.1573735e-05
552	Supporting Incremental Join Queries on Ranked Inputs	2001	VLDB	0.00020310903
2,393	Rank-aware Query Optimization	2004	SIGMOD	8.9016542e-05
8,061	Efficient Computation of Quantiles over Joins	2023	PODS	4.5943269e-05
5,962	Beyond Equi-joins: Ranking, Enumeration and Factorization	2021	VLDB	5.2536266e-05
3,715	Optimal Algorithms for Ranked Enumeration of Answers to Full Conjunctive Queries	2020	VLDB	6.8220943e-05
10,324	Towards Efficient Random-Order Enumeration for Join Queries	2026	VLDB	4.1945683e-05