Efficient computation of skyline queries over a dynamic and incomplete database

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 skylin...

Full description

Saved in:
Bibliographic Details
Main Authors: Dehaki, Ghazaleh Babanejad, Ibrahim, Hamidah, Sidi, Fatimah, Udzir, Nur Izura, Alwan, Ali A., Gulzar, Yonis
Format: Article
Language:English
Published: Institute of Electrical and Electronics Engineers 2020
Online Access:http://psasir.upm.edu.my/id/eprint/88753/1/SKY.pdf
http://psasir.upm.edu.my/id/eprint/88753/
https://ieeexplore.ieee.org/document/9146842
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.upm.eprints.88753
record_format eprints
spelling my.upm.eprints.887532021-10-06T08:44:35Z http://psasir.upm.edu.my/id/eprint/88753/ Efficient computation of skyline queries over a dynamic and incomplete database Dehaki, Ghazaleh Babanejad Ibrahim, Hamidah Sidi, Fatimah Udzir, Nur Izura Alwan, Ali A. Gulzar, Yonis 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. Institute of Electrical and Electronics Engineers 2020 Article PeerReviewed text en http://psasir.upm.edu.my/id/eprint/88753/1/SKY.pdf Dehaki, Ghazaleh Babanejad and Ibrahim, Hamidah and Sidi, Fatimah and Udzir, Nur Izura and Alwan, Ali A. and Gulzar, Yonis (2020) Efficient computation of skyline queries over a dynamic and incomplete database. IEEE Access, 8. 141523 - 141546. ISSN 2169-3536 https://ieeexplore.ieee.org/document/9146842 10.1109/ACCESS.2020.3011652
institution Universiti Putra Malaysia
building UPM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Putra Malaysia
content_source UPM Institutional Repository
url_provider http://psasir.upm.edu.my/
language English
description 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.
format Article
author Dehaki, Ghazaleh Babanejad
Ibrahim, Hamidah
Sidi, Fatimah
Udzir, Nur Izura
Alwan, Ali A.
Gulzar, Yonis
spellingShingle Dehaki, Ghazaleh Babanejad
Ibrahim, Hamidah
Sidi, Fatimah
Udzir, Nur Izura
Alwan, Ali A.
Gulzar, Yonis
Efficient computation of skyline queries over a dynamic and incomplete database
author_facet Dehaki, Ghazaleh Babanejad
Ibrahim, Hamidah
Sidi, Fatimah
Udzir, Nur Izura
Alwan, Ali A.
Gulzar, Yonis
author_sort Dehaki, Ghazaleh Babanejad
title Efficient computation of skyline queries over a dynamic and incomplete database
title_short Efficient computation of skyline queries over a dynamic and incomplete database
title_full Efficient computation of skyline queries over a dynamic and incomplete database
title_fullStr Efficient computation of skyline queries over a dynamic and incomplete database
title_full_unstemmed Efficient computation of skyline queries over a dynamic and incomplete database
title_sort efficient computation of skyline queries over a dynamic and incomplete database
publisher Institute of Electrical and Electronics Engineers
publishDate 2020
url http://psasir.upm.edu.my/id/eprint/88753/1/SKY.pdf
http://psasir.upm.edu.my/id/eprint/88753/
https://ieeexplore.ieee.org/document/9146842
_version_ 1713201302229483520
score 13.18916