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 条
  • [31] Optimization of top-k spatial preference queries' execution process based on similarity of preferences
    Gorawski, Marcin
    Dowlaszewicz, Kamil
    Frontiers in Artificial Intelligence and Applications, 2008, 181 (01) : 140 - 151
  • [32] External Merge Sort for Top-K Queries Eager input filtering guided by histograms
    Chronis, Yannis
    Thanh Do
    Graefe, Goetz
    Peters, Keith
    SIGMOD'20: PROCEEDINGS OF THE 2020 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2020, : 2423 - 2437
  • [33] The partitioned-layer index: Answering monotone top-k queries using the convex skyline and partitioning-merging technique
    Heo, Jun-Seok
    Whang, Kyu-Young
    Kim, Min-Soo
    Kim, Yi-Reun
    Song, Il-Yeol
    INFORMATION SCIENCES, 2009, 179 (19) : 3286 - 3308
  • [34] Adaptive convex skyline: a threshold-based project partitioned layer-based index for efficient-processing top-k queries in entrepreneurship applications
    Son, Yunsik
    Ihm, Sun-Young
    Nasridinov, Aziz
    Park, Young-Ho
    JOURNAL OF SUPERCOMPUTING, 2016, 72 (11): : 4262 - 4275
  • [35] Adaptive convex skyline: a threshold-based project partitioned layer-based index for efficient-processing top-k queries in entrepreneurship applications
    Yunsik Son
    Sun-Young Ihm
    Aziz Nasridinov
    Young-Ho Park
    The Journal of Supercomputing, 2016, 72 : 4262 - 4275