Joining Ranked Inputs in Practice

Summary: NRA-RJ, a practical pipelined operator joining ranked streams to produce a global rank from a score function. Bridges Fagin’s optimal aggregation to a scalable implementation; experiments on medical video workloads show NRA-RJ outperforms rival rank-join methods for equi-joins. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h47cd559f8b19d68a
Venue: VLDB
Year: 2002
Pagerank: 7.7058408e-05
Overall Rank: 3,051 | 79.50%
DOI: 10.1016/B978-155860869-6/50094-9

Incoming Non-self Citations Over Time

Authors

1. Ihab F. Ilyas (Purdue University)
2. Walid G. Aref (Purdue University)
3. Ahmed K. Elmagarmid (Hewlett Packard)

BibTeX Citation

@article{ilyas_vldb02,
        title = {{Joining Ranked Inputs in Practice}},
        author = {Ilyas, Ihab F. and Aref, Walid G. and Elmagarmid, Ahmed K.},
        journal = {PVLDB},
        series = {{VLDB} '02},
        doi = {10.1016/B978-155860869-6/50094-9},
        url = {https://doi.org/10.1016/B978-155860869-6/50094-9},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
524	Supporting Top-k Join Queries in Relational Databases	2003	VLDB	0.00016902116
674	Efficient Similarity Search and Classification via Rank Aggregation	2003	SIGMOD	0.00014886449
962	RankSQL: Query Algebra and Optimization for Relational Top-k Queries	2005	SIGMOD	0.00012818013
1,441	Continuous Monitoring of Top-k Queries over Sliding Windows	2006	SIGMOD	0.00010638056
1,773	Rank-aware Query Optimization	2004	SIGMOD	9.6683429e-05
2,236	Efficient Network-Aware Search in Collaborative Tagging Sites	2008	VLDB	8.7830564e-05
2,787	EVA: A Symbolic Approach to Accelerating Exploratory Video Analytics with Materialized Views	2022	SIGMOD	8.0121053e-05
7,102	DeepEverest: Accelerating Declarative Top-K Queries for Deep Neural Network Interpretation	2022	VLDB	5.5991152e-05
9,688	Rank Join Queries in NoSQL Databases	2014	VLDB	5.1403642e-05
12,605	Optimal Top-k Generation of Attribute Combinations based on Ranked Lists	2012	SIGMOD	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,770	Proximity Rank Join	2010	VLDB
2	1,108	Maximizing the Output Rate of Multi-Way Join Queries over Streaming Information Sources	2003	VLDB
3	5,941	RankSQL: Supporting Ranking Queries in Relational Database Management Systems	2005	VLDB
4	6,547	Ranked Enumeration of Join Queries with Projections	2022	VLDB
5	12,683	Efficient Rank Join with Aggregation Constraints	2011	VLDB
6	5,233	Robust and Efficient Algorithms for Rank Join Evaluation	2009	SIGMOD
7	1,773	Rank-aware Query Optimization	2004	SIGMOD
8	2,615	Evaluating Rank Joins with Optimal Cost	2008	PODS
9	524	Supporting Top-k Join Queries in Relational Databases	2003	VLDB
10	507	Supporting Incremental Join Queries on Ranked Inputs	2001	VLDB