Affiliation:
1. University of Hong Kong, Pokfulam Road, Hong Kong
2. Aalborg University, Aalborg, Denmark
Abstract
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 with monotone aggregate functions. We provide an analysis for its cost and show that it is always no worse than the baseline “no random accesses” algorithm in terms of computations, accesses, and memory required. As a side contribution, we perform a space analysis, which indicates the memory requirements of top-
k
algorithms that only perform sorted accesses. For the case, where the required space exceeds the available memory, we propose disk-based variants of our algorithm. We propose and optimize a multiway top-
k
join operator, with certain advantages over evaluation trees of binary top-
k
join operators. Finally, we define and study the computation of top-
k
cubes and the implementation of roll-up and drill-down operations in such cubes. Extensive experiments with synthetic and real data show that, compared to previous techniques, our method accesses fewer objects, while being orders of magnitude faster.
Publisher
Association for Computing Machinery (ACM)
Cited by
65 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. Fair&Share: Fast and Fair Multi-Criteria Selections;Proceedings of the 32nd ACM International Conference on Information and Knowledge Management;2023-10-21
2. T-LevelIndex: Towards Efficient Query Processing in Continuous Preference Space;Proceedings of the 2022 International Conference on Management of Data;2022-06-10
3. PSATop-k: Approximate range top-k computation on big data;Knowledge-Based Systems;2022-01
4. Threshold queries in theory and in the wild;Proceedings of the VLDB Endowment;2022-01
5. Beyond equi-joins;Proceedings of the VLDB Endowment;2021-07