Definition
Rank-aware query processing refers to the efficient processing of a top-k query taking into account the ranking requirements on output results. A naïve way to process a top-k query is to calculate the full set of results and then sort them based on the ranking function; the top-k results are presented as the final query answers. Such a naïve materialize-then-sort scheme can be prohibitively expensive. Integrating top-k queries in SQL query engines requires addressing the challenge of making an RDBMS rank-aware. This requires introducing new constructs in the whole system including the data model, algebra, query operators, and query optimization techniques.
Historical Background
The need for rank-aware query processing arose since the introduction of top-k queries with score aggregation and rank joins to the database community. Fagin et al. [1] first introduced the problem of ranking a database of objects, given several rankings of the objects, by aggregating their scores...
Recommended Reading
Fagin R. Combining fuzzy information: an overview. ACM SIGMOD Rec. 2002;31(2):109–18.
Fagin R, Lotem A, Naor M. Optimal aggregation algorithms for middleware. J Comput Syst Sci. 2003;66(4):614–56.
Finger J, Polyzotis N. Robust and efficient algorithms for rank join evaluation. In: Proceedings of the 2009 ACM SIGMOD international conference on management of data. ACM; 2009. p. 415–28.
Ilyas IF, Aref WG, Elmagarmid AK. Joining ranked inputs in practice. In: Proceedings of the 28th international conference on very large data bases. VLDB Endowment. 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.
Li C, Chang KC-C, Ilyas IF, Song S. Ranksql: query algebra and optimization for relational top-k queries. In: Proceedings of the 2005 ACM SIGMOD international conference on Management of data. ACM; 2005. p. 131–42.
Li C, Soliman MA, Chang KC-C, Ilyas IF. Ranksql: supporting ranking queries in relational database management systems. In: Proceedings of the 31st international conference on very large data bases. VLDB Endowment; 2005. p. 1342–45.
Natsev A, chi Chang Y, Smith JR, Li C-S, Vitter JS. Supporting incremental join queries on ranked inputs. In: VLDB. 2001.
Roth MT, Arya M, Haas LM, Carey MJ, Cody W, Fagin R, Schwarz PM, Thomas J, Wimmers EL. The garlic project. Sigmod Rec. 1996;25:557.
Schnaitter K, Polyzotis N. Evaluating rank joins with optimal cost. In: Proceedings of the twenty-seventh ACM SIGMOD-SIGACT-SIGART symposium on principles of database systems. ACM; 2008. p. 43–52.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2016 Springer Science+Business Media LLC
About this entry
Cite this entry
Ilyas, I. (2016). Rank-Aware Query Processing. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_80680-1
Download citation
DOI: https://doi.org/10.1007/978-1-4899-7993-3_80680-1
Received:
Accepted:
Published:
Publisher Name: Springer, New York, NY
Online ISBN: 978-1-4899-7993-3
eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering