Reverse Top-k Queries

被引:68
|
作者
Vlachou, Akrivi [1 ]
Doulkeridis, Christos [1 ]
Kotidis, Yannis [2 ]
Norvag, Kjetil [1 ]
机构
[1] NTNU, Dept Comp Sci, Trondheim, Norway
[2] AUEB, Dept Informat, Athens, Greece
基金
对外科技合作项目(国际科技项目); 中国国家自然科学基金;
关键词
D O I
10.1109/ICDE.2010.5447890
中图分类号
TP301 [理论、方法];
学科分类号
081202 ;
摘要
Rank-aware query processing has become essential for many applications that return to the user only the top-k objects based on the individual user's preferences. Top-k queries have been mainly studied from the perspective of the user, focusing primarily on efficient query processing. In this work, for the first time, we study top-k queries from the perspective of the product manufacturer. Given a potential product, which are the user preferences for which this product is in the top-k query result set? We identify a novel query type, namely reverse top-k query, that is essential for manufacturers to assess the potential market and impact of their products based on the competition. We formally define reverse top-k queries and introduce two versions of the query, namely monochromatic and bichromatic. We first provide a geometric interpretation of the monochromatic reverse top-k query in the solution space that helps to understand the reverse top-k query conceptually. Then, we study in more details the case of bichromatic reverse top-k query, which is more interesting for practical applications. Such a query, if computed in a straightforward manner, requires evaluating a top-k query for each user preference in the database, which is prohibitively expensive even for moderate datasets. In this paper, we present an efficient threshold-based algorithm that eliminates candidate user preferences, without processing the respective top-k queries. Furthermore, we introduce an indexing structure based on materialized reverse top-k views in order to speed up the computation of reverse top-k queries. Materialized reverse top-k views trade preprocessing cost for query speed up in a controllable manner. Our experimental evaluation demonstrates the efficiency of our techniques, which reduce the required number of top-k computations by 1 to 3 orders of magnitude.
引用
收藏
页码:365 / 376
页数:12
相关论文
共 50 条
  • [1] Probabilistic Reverse Top-k Queries
    Jin, Cheqing
    Zhang, Rong
    Kang, Qiangqiang
    Zhang, Zhao
    Zhou, Aoying
    [J]. DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, DASFAA 2014, PT I, 2014, 8421 : 406 - 419
  • [2] Reverse k nearest neighbors queries and spatial reverse top-k queries
    Yang, Shiyu
    Cheema, Muhammad Aamir
    Lin, Xuemin
    Zhang, Ying
    Zhang, Wenjie
    [J]. VLDB JOURNAL, 2017, 26 (02): : 151 - 176
  • [3] Reverse k nearest neighbors queries and spatial reverse top-k queries
    Shiyu Yang
    Muhammad Aamir Cheema
    Xuemin Lin
    Ying Zhang
    Wenjie Zhang
    [J]. The VLDB Journal, 2017, 26 : 151 - 176
  • [4] Reverse spatial top-k keyword queries
    Ahmed, Pritom
    Eldawy, Ahmed
    Hristidis, Vagelis
    Tsotras, Vassilis J.
    [J]. VLDB JOURNAL, 2023, 32 (03): : 501 - 524
  • [5] Monochromatic and Bichromatic Reverse Top-k Queries
    Vlachou, Akrivi
    Doulkeridis, Christos
    Kotidis, Yannis
    Norvag, Kjetil
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2011, 23 (08) : 1215 - 1229
  • [6] Reverse spatial top-k keyword queries
    Pritom Ahmed
    Ahmed Eldawy
    Vagelis Hristidis
    Vassilis J. Tsotras
    [J]. The VLDB Journal, 2023, 32 : 501 - 524
  • [7] Efficient Processing of Reverse Top-k Dominating Queries
    Jiang, Tao
    Zhang, Bin
    Yang, Jun
    [J]. PROCEEDINGS OF 2018 THE 2ND INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND ARTIFICIAL INTELLIGENCE (CSAI 2018) / 2018 THE 10TH INTERNATIONAL CONFERENCE ON INFORMATION AND MULTIMEDIA TECHNOLOGY (ICIMT 2018), 2018, : 115 - 119
  • [8] Parallel and Distributed Processing of Reverse Top-k Queries
    Nikitopoulos, Panagiotis
    Sfyris, Georgios A.
    Vlachou, Akrivi
    Doulkeridis, Christos
    Telelis, Orestis
    [J]. 2019 IEEE 35TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2019), 2019, : 1586 - 1589
  • [9] Answering Why-not Questions on Reverse Top-k Queries
    Gao, Yunjun
    Liu, Qing
    Chen, Gang
    Zheng, Baihua
    Zhou, Linlin
    [J]. PROCEEDINGS OF THE VLDB ENDOWMENT, 2015, 8 (07): : 738 - 749
  • [10] Pruning techniques for parallel processing of reverse top-k queries
    Panagiotis Nikitopoulos
    Georgios A. Sfyris
    Akrivi Vlachou
    Christos Doulkeridis
    Orestis Telelis
    [J]. Distributed and Parallel Databases, 2021, 39 : 169 - 199