Efficient Computation of Skyline Queries Over a Dynamic and Incomplete Database

被引:7
|
作者
Dehaki, Ghazaleh Babanejad [1 ]
Ibrahim, Hamidah [1 ]
Sidi, Fatimah [1 ]
Udzir, Nur Izura [1 ]
Alwan, Ali A. [2 ]
Gulzar, Yonis [3 ]
机构
[1] Univ Putra Malaysia, Fac Comp Sci & Informat Technol, Dept Comp Sci, Serdang 43400, Malaysia
[2] Int Islamic Univ Malaysia, Kulliyyah Informat & Commun Technol, Dept Comp Sci, Kuala Lumpur 53100, Malaysia
[3] King Faisal Univ, Coll Business Adm, Dept Management Informat Syst, Al Hufuf 31982, Saudi Arabia
关键词
Indexes; Optimization; Computer science; Query processing; Information filters; Skyline queries; incomplete database; dynamic database; pairwise comparisons;
D O I
10.1109/ACCESS.2020.3011652
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Skyline queries rely on the notion of Pareto dominance, filter the data items by keeping only those data items that are the best, most preferred, also known as skylines, from a database to meet the user's preferences. Skyline query has been studied extensively and a significant number of skyline algorithms have been proposed, mostly attempt to resolve the optimisation problem that is mainly associated with a reduction in the processing time of skyline computations. In today's era, the presence of incomplete data in a database is inevitable. Furthermore, databases are dynamic in nature in which their states change throughout the time to reflect the current and latest information of the applications. The skylines derived before changes are made towards the initial database are no longer valid in the new state of the database. Blindly examining the entire database to identify the new set of skylines is unwise as not all data items are affected by the changes made towards the database. Hence, in this paper we propose a solution, named DyIn-Skyline, which is capable of deriving skylines over a dynamic and incomplete database, by exploiting only those data items that are affected by the changes. Several experiments have been conducted and the results show that our proposed solution outperforms the previous works with regard to the number of pairwise comparisons and processing time.
引用
收藏
页码:141523 / 141546
页数:24
相关论文
共 50 条
  • [31] An Efficient Pruning Method to Process Reverse Skyline Queries
    Han, Ah
    Park, Youngbae
    Kwon, Dongseop
    JOURNAL OF INFORMATION SCIENCE AND ENGINEERING, 2014, 30 (02) : 501 - 517
  • [32] Efficient and Privacy-Preserving Multi-Party Skyline Queries Over Encrypted Data
    Ding, Xiaofeng
    Wang, Zuan
    Zhou, Pan
    Choo, Kim-Kwang Raymond
    Jin, Hai
    IEEE TRANSACTIONS ON INFORMATION FORENSICS AND SECURITY, 2021, 16 : 4589 - 4604
  • [33] Secure Dynamic Skyline Queries Using Result Materialization
    Zeighami, Sepanta
    Ghinita, Gabriel
    Shahabi, Cyrus
    2021 IEEE 37TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2021), 2021, : 157 - 168
  • [34] Efficient group-by reverse skyline computation
    Zonghui Wang
    Yunjun Gao
    Qing Liu
    Xiaoye Miao
    Qing Li
    Chuan Li
    World Wide Web, 2016, 19 : 1023 - 1049
  • [35] Efficient group-by reverse skyline computation
    Wang, Zonghui
    Gao, Yunjun
    Liu, Qing
    Miao, Xiaoye
    Li, Qing
    Li, Chuan
    WORLD WIDE WEB-INTERNET AND WEB INFORMATION SYSTEMS, 2016, 19 (06): : 1023 - 1049
  • [36] Toward efficient multidimensional subspace skyline computation
    Jongwuk Lee
    Seung-won Hwang
    The VLDB Journal, 2014, 23 : 129 - 145
  • [37] Toward efficient multidimensional subspace skyline computation
    Lee, Jongwuk
    Hwang, Seung-won
    VLDB JOURNAL, 2014, 23 (01): : 129 - 145
  • [38] Efficient Location-Based Skyline Queries With Secure R-Tree Over Encrypted Data
    Wang, Zuan
    Ding, Xiaofeng
    Lu, Junfeng
    Zhang, Liang
    Zhou, Pan
    Choo, Kim-Kwang Raymond
    Jin, Hai
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2023, 35 (10) : 10436 - 10450
  • [39] SecSkyline: Fast Privacy-Preserving Skyline Queries Over Encrypted Cloud Databases
    Zheng, Yifeng
    Wang, Weibo
    Wang, Songlei
    Jia, Xiaohua
    Huang, Hejiao
    Wang, Cong
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2023, 35 (09) : 8955 - 8967
  • [40] Parallelization of skyline probability computation over uncertain preferences
    Zhu, Haoyang
    Zhu, Peidong
    Li, Xiaoyong
    Liu, Qiang
    Xun, Peng
    CONCURRENCY AND COMPUTATION-PRACTICE & EXPERIENCE, 2017, 29 (18):