Definition
A rank-join operator RJ(R, J, F, k) joins a set of relations R = {R1, …, Rn} on a set of join predicates J, and returns the k join results with the largest combined scores. The combined score of each join result is computed according to a scoring function F(p1, …, pn), where p1, …, pn are scoring predicates defined over the input relations {R1, …, Rn} respectively. A naïve implantation of a rank-join operator involves computing the full set of join results and then sorting the results on F to report the top k answers. However, the order of the inputs and the properties of the scoring function can be leveraged to avoid materializing the full join results and sorting. For instance, when the inputs are ordered on the scoring predicates p1, …, pn, and the scoring function F is monotone, early termination can be achieved by computing tight bounds on the scores of join results that are not yet produced. Most rank-join algorithms are generalization of the Threshold algorithms [2]...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Fagin R. Combining fuzzy information from multiple systems. In: Proceedings of the ACM SIGACT-SIGMOD Symposium on Principles of Database Systems; 1996.
Fagin R, Lotem A, Naor M. Optimal aggregation algorithms for middleware. In: Proceedings of the ACM SIGACT-SIGMOD Symposium on Principles of Database Systems; 2001.
Finger J, Polyzotis N. Robust and efficient algorithms for rank join evaluation. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2009. p. 415–28.
Hristidis V, Koudas N, Papakonstantinou Y. Prefer: a system for the efficient execution of multi-parametric ranked queries. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2001. p. 259–70.
Ilyas IF, Aref WG, Elmagarmid AK. Joining ranked inputs in practice. In: Proceedings of the 28th International Conference on Very Large Data Bases; 2002. p. 950–61.
Ilyas IF, Aref WG, Elmagarmid AK. Supporting top-k join queries in relational databases. VLDB J Int J Very Large Data Bases. 2004;13(3):207–21.
Natsev A, chi Chang Y, Smith JR, Li C-S, Vitter JS. Supporting incremental join queries on ranked inputs. In: Proceedings of the 27th International Conference on Very Large Data Base; 2001.
Niblack CW, Barber R, Equitz W, Flickner MD, Glasman EH, Petkovic D, Yanker P, Faloutsos C, Taubin G. Qbic project: querying images by content, using color, texture, and shape. San Jose: IBM Thomas J. Watson Research Division; 1993.
Schnaitter K, Polyzotis N. Evaluating rank joins with optimal cost. In: Proceedings of the 27th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems; 2008. p. 43–52.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Ilyas, I.F. (2018). Rank-Join. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_80679
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_80679
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering