Marrying Top-k with Skyline Queries: Operators with Relaxed Preference Input and Controllable Output Size

被引:0
|
作者
Mouratidis, Kyriakos [1 ]
Li, Keming [2 ]
Tang, Bo [3 ,4 ]
机构
[1] Singapore Management Univ, Sch Comp & Informat Syst, Singapore, Singapore
[2] Univ Calif Irvine, Sch Informat & Comp Sci, Irvine, CA 92697 USA
[3] Southern Univ Sci & Technol, Dept Comp Sci & Engn, Shenzhen, Peoples R China
[4] Southern Univ Sci & Technol, Res Inst Trustworthy Autonomous Syst, Shenzhen, Peoples R China
来源
ACM TRANSACTIONS ON DATABASE SYSTEMS | 2025年 / 50卷 / 01期
基金
美国国家科学基金会;
关键词
Top-k query; skyline; multi-dimensional datasets; ALGORITHMS; RANKING; OPTIMIZATION; COMPUTATION; GAIN;
D O I
10.1145/3705726
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
The two paradigms to identify records of preference in a multi-objective setting rely either on dominance (e.g., the skyline operator) or on a utility function defined over the records' attributes (typically using a top-k query). Despite their proliferation, each has its own palpable drawbacks. Motivated by these drawbacks, we identify three hard requirements for practical decision support, namely, personalization, controllable output size, and flexibility in preference specification. With these requirements as a guide, we combine elements from both paradigms and propose two new operators, ORD and ORU. We present a suite of algorithms for their efficient processing, dedicating more technical effort to ORU, whose nature is inherently more challenging. Specifically, besides a sophisticated algorithm for ORD, we describe two exact methods for ORU and one approximate. We perform a qualitative study to demonstrate how our operators work and evaluate the performance of our algorithms against adaptations of previous work that mimic their output. CCS Concepts: center dot Information systems -> Top-k retrieval in databases;
引用
收藏
页数:37
相关论文
共 35 条
  • [21] Durable reverse top-k queries on time-varying preference
    Zhang, Chuhan
    Li, Jianzhong
    Jiang, Shouxu
    WORLD WIDE WEB-INTERNET AND WEB INFORMATION SYSTEMS, 2024, 27 (05):
  • [22] A Partitioned-Based Method of Convex Skyline for Efficient Processing Top-k Queries
    Lee, Ki-Eun
    Ihm, Sun-Young
    Heo, Jun-Seok
    Lee, Jeong-Joon
    Park, Young-Ho
    SECOND INTERNATIONAL CONFERENCE ON CLOUD AND GREEN COMPUTING / SECOND INTERNATIONAL CONFERENCE ON SOCIAL COMPUTING AND ITS APPLICATIONS (CGC/SCA 2012), 2012, : 788 - 793
  • [23] An analysis and extension of top-k spatial preference queries optimization methods
    Gorawski, Marcin
    Dowlaszewicz, Kamil
    PROCEEDINGS OF THE 2008 1ST INTERNATIONAL CONFERENCE ON INFORMATION TECHNOLOGY, 2008, : 227 - 230
  • [24] Grid-PPPS: A Skyline Method for Efficiently Handling Top-k Queries in Internet of Things
    Ihm, Sun-Young
    Nasridinov, Aziz
    Park, Young-Ho
    JOURNAL OF APPLIED MATHEMATICS, 2014,
  • [25] User preference space partition and product filters for reverse top-k queries
    Yang, Zong-Hua
    Kao, Hung-Yu
    2014 INTERNATIONAL CONFERENCE ON DATA SCIENCE AND ADVANCED ANALYTICS (DSAA), 2014, : 498 - 504
  • [26] Crowdsourced top-k queries by pairwise preference judgments with confidence and budget control
    Yan Li
    Hao Wang
    Ngai Meng Kou
    Leong Hou U
    Zhiguo Gong
    The VLDB Journal, 2021, 30 : 189 - 213
  • [27] Crowdsourced top-k queries by pairwise preference judgments with confidence and budget control
    Li, Yan
    Wang, Hao
    Kou, Ngai Meng
    Hou, Leong U.
    Gong, Zhiguo
    VLDB JOURNAL, 2021, 30 (02): : 189 - 213
  • [28] Multi-User Preference Top-k Skyline Query Method Based on Road Network
    Li S.
    Bin T.
    Hao X.
    Zhang L.
    Hao Z.
    Jisuanji Yanjiu yu Fazhan/Computer Research and Development, 2023, 60 (10): : 2348 - 2358
  • [29] Approximate convex skyline: A partitioned layer-based index for efficient processing top-k queries
    Ihm, Sun-Young
    Lee, Ki-Eun
    Nasridinov, Aziz
    Heo, Jun-Seok
    Park, Young-Ho
    KNOWLEDGE-BASED SYSTEMS, 2014, 61 : 13 - 28
  • [30] A New Approach to Process Top-k Spatial Preference Queries in a Directed Road Network
    Attique, Muhammad
    Qamar, Rizwan
    Cho, Hyung-Ju
    Chung, Tae-Sun
    PROCEEDINGS OF THE THIRD ACM SIGSPATIAL INTERNATIONAL WORKSHOP ON MOBILE GEOGRAPHIC INFORMATION SYSTEMS (MOBIGIS), 2014, : 34 - 42