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...
Saved in:
Main Authors: | , , , , , |
---|---|
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 |