Skip to Main content Skip to Navigation
Conference papers

Best Position Algorithms for Top-k Queries

Abstract : The general problem of answering top-k queries can be modeled using lists of data items sorted by their local scores. The most efficient algorithm proposed so far for answering top-k queries over sorted lists is the Threshold Algorithm (TA). However, TA may still incur a lot of useless accesses to the lists. In this paper, we propose two new algorithms which stop much sooner. First, we propose the best position algorithm (BPA) which executes top-k queries more efficiently than TA. For any database instance (i.e. set of sorted lists), we prove that BPA stops as early as TA, and that its execution cost is never higher than TA. We show that the position at which BPA stops can be (m-1) times lower than that of TA, where m is the number of lists. We also show that the execution cost of our algorithm can be (m-1) times lower than that of TA. Second, we propose the BPA2 algorithm which is much more efficient than BPA. We show that the number of accesses to the lists done by BPA2 can be about (m-1) times lower than that of BPA. Our performance evaluation shows that over our test databases, BPA and BPA2 achieve significant performance gains in comparison with TA.
Document type :
Conference papers
Complete list of metadatas

Cited literature [28 references]  Display  Hide  Download
Contributor : Reza Akbarinia <>
Submitted on : Monday, February 15, 2010 - 4:20:54 PM
Last modification on : Monday, May 4, 2020 - 11:37:43 AM
Long-term archiving on: : Thursday, June 10, 2010 - 6:32:01 PM


Files produced by the author(s)


  • HAL Id : inria-00378836, version 1



Reza Akbarinia, Esther Pacitti, Patrick Valduriez. Best Position Algorithms for Top-k Queries. International Conference on Very Large Data Bases (VLDB), Aug 2007, Vienna, Austria. pp.495-506. ⟨inria-00378836⟩



Record views


Files downloads