Efficient Aggregation of Ranked Inputs

A top-k query combines different rankings of the same set of objects and returns the k objects with the highest combined score according to an aggregate function. We bring to light some key observations, which impose two phases that any top-k algorithm, based on sorted accesses, should go through. Based on them, we propose a new algorithm, which is designed to minimize the number of object accesses, the computational cost, and the memory requirements of top-k search. Adaptations of our algorithm for search variants (exact scores, on-line and incremental search, top-k joins, other aggregate functions, etc.) are also provided. Extensive experiments with synthetic and real data show that, compared to previous techniques, our method accesses fewer objects, while being orders of magnitude faster.

• Type: Conference
• Year: 2006
• Where: ICDE
• Authors: Nikos Mamoulis, Kit Hung Cheng, Man Lung Yiu, David W. Cheung
• Keywords: Aggregate Function, Database, Fewer Objects, ICDE 2006, Sorted Accesses