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 条
  • [21] Skyline Queries over Incomplete Data - Error Models for Focused Crowd-Sourcing
    Lofi, Christoph
    El Maarry, Kinda
    Balke, Wolf-Tilo
    CONCEPTUAL MODELING, ER 2013, 2013, 8217 : 298 - +
  • [22] Efficient Routing of Subspace Skyline Queries over Highly Distributed Data
    Vlachou, Akrivi
    Doulkeridis, Christos
    Kotidis, Yannis
    Vazirgiannis, Michalis
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2010, 22 (12) : 1694 - 1708
  • [23] k-dominant skyline queries on incomplete data
    Miao, Xiaoye
    Gao, Yunjun
    Chen, Gang
    Zhang, Tianyi
    INFORMATION SCIENCES, 2016, 367 : 990 - 1011
  • [24] Skyline computation for frequent queries in update intensive environment
    Kulkarni, R. D.
    Momin, B. F.
    JOURNAL OF KING SAUD UNIVERSITY-COMPUTER AND INFORMATION SCIENCES, 2016, 28 (04) : 447 - 456
  • [25] Parallel Skyline Computation for Frequent Queries in Distributed Environment
    Kulkarni, R. D.
    Momin, B. F.
    2016 INTERNATIONAL CONFERENCE ON COMPUTATIONAL TECHNIQUES IN INFORMATION AND COMMUNICATION TECHNOLOGIES (ICCTICT), 2016,
  • [26] A new efficient algorithm for continuous skyline queries
    Gomaa, Ibrahim
    Mokhtar, Hoda M. O.
    2016 7TH INTERNATIONAL CONFERENCE ON INFORMATION, INTELLIGENCE, SYSTEMS & APPLICATIONS (IISA), 2016,
  • [27] Efficient Processing of Skyline Queries Using MapReduce
    Park, Yoonjae
    Min, Jun-Ki
    Shim, Kyuseok
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2017, 29 (05) : 1031 - 1044
  • [28] CIDS: An Efficient Algorithm for Processing Skyline Queries for Partially Complete Data in Cloud Environment
    Gulzar, Yonis
    Alwan, Ali A.
    IEEE ACCESS, 2022, 10 : 66449 - 66466
  • [29] Processing k-skyband, constrained skyline, and group-by skyline queries on incomplete data
    Gao, Yunjun
    Miao, Xiaoye
    Cui, Huiyong
    Chen, Gang
    Li, Qing
    EXPERT SYSTEMS WITH APPLICATIONS, 2014, 41 (10) : 4959 - 4974
  • [30] Energy-Efficient Evaluation of Multiple Skyline Queries over a Wireless Sensor Network
    Xin, Junchang
    Wang, Guoren
    Chen, Lei
    Oria, Vincent
    DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, PROCEEDINGS, 2009, 5463 : 247 - +