IDENTIFYING SKYLINES IN CLOUD DATABASES WITH INCOMPLETE DATA

Skyline queries is a rich area of research in the database community. Due to its great benefits, it has been integrated into many database applications including but not limited to personalized recommendation, multi-objective, decision support and decision-making systems. Many variations of skyline...

Full description

Bibliographic Details
Main Authors: Yonis Gulzar, Ali Amer Alwan Aljuboori, Norsaremah Salleh, Imad Al Shaikhli
Format: Article
Language:English
Published: UUM Press 2018-11-01
Series:Journal of ICT
Online Access:https://www.scienceopen.com/document?vid=b90dd72e-e3c8-497e-9765-c1c27d0aeec5
_version_ 1818983820223840256
author Yonis Gulzar
Ali Amer Alwan Aljuboori
Norsaremah Salleh
Imad Al Shaikhli
author_facet Yonis Gulzar
Ali Amer Alwan Aljuboori
Norsaremah Salleh
Imad Al Shaikhli
author_sort Yonis Gulzar
collection DOAJ
description Skyline queries is a rich area of research in the database community. Due to its great benefits, it has been integrated into many database applications including but not limited to personalized recommendation, multi-objective, decision support and decision-making systems. Many variations of skyline technique have been proposed in the literature addressing the issue of handling skyline queries in incomplete database. Nevertheless, these solutions are designed to fit with centralized incomplete database single access. However, in many real-world database systems, this might not be the case, particularly for a database witha large amount of incomplete data distributed over various remote locations such as cloud databases. It is inadequate to directly apply skyline solutions designed for the centralized incomplete database to work on cloud due to the prohibitive cost. Thus, this paper introduces a new approach called Incomplete-data Cloud Skylines (ICS) aiming at processing skyline queries in cloud databases with incomplete data. This approach emphasizes on reducing the amount of data transfer and domination tests during skyline process. It incorporates sorting technique that assists in arranging the data items in a way where dominating data items will be placed at the top of the list helping in eliminate dominated data items. Besides, ICS also employs a filtering technique to prune the dominated data items before applying skyline technique. It comprises a technique named local skyline joiner that helps in reducing the amount of data transfer between datacenters when deriving the final skylines. It limit the amount of data items to be transferred to only those local skylines of each relation. A comprehensive experiment have been performed on both synthetic and real-life datasets, which demonstrate the effectiveness and versatility of our approach in comparison to the current existing approaches. We argue that our approach is practical and can be adopted in many contemporary cloud database systems with incomplete data to process skyline queries.
first_indexed 2024-12-20T18:09:11Z
format Article
id doaj.art-da6f3f640a834b8fb007a89e824bd814
institution Directory Open Access Journal
issn 1675-414X
language English
last_indexed 2024-12-20T18:09:11Z
publishDate 2018-11-01
publisher UUM Press
record_format Article
series Journal of ICT
spelling doaj.art-da6f3f640a834b8fb007a89e824bd8142022-12-21T19:30:31ZengUUM PressJournal of ICT1675-414X2018-11-0110.32890/jict2019.18.1.8278IDENTIFYING SKYLINES IN CLOUD DATABASES WITH INCOMPLETE DATAYonis GulzarAli Amer Alwan AljubooriNorsaremah SallehImad Al ShaikhliSkyline queries is a rich area of research in the database community. Due to its great benefits, it has been integrated into many database applications including but not limited to personalized recommendation, multi-objective, decision support and decision-making systems. Many variations of skyline technique have been proposed in the literature addressing the issue of handling skyline queries in incomplete database. Nevertheless, these solutions are designed to fit with centralized incomplete database single access. However, in many real-world database systems, this might not be the case, particularly for a database witha large amount of incomplete data distributed over various remote locations such as cloud databases. It is inadequate to directly apply skyline solutions designed for the centralized incomplete database to work on cloud due to the prohibitive cost. Thus, this paper introduces a new approach called Incomplete-data Cloud Skylines (ICS) aiming at processing skyline queries in cloud databases with incomplete data. This approach emphasizes on reducing the amount of data transfer and domination tests during skyline process. It incorporates sorting technique that assists in arranging the data items in a way where dominating data items will be placed at the top of the list helping in eliminate dominated data items. Besides, ICS also employs a filtering technique to prune the dominated data items before applying skyline technique. It comprises a technique named local skyline joiner that helps in reducing the amount of data transfer between datacenters when deriving the final skylines. It limit the amount of data items to be transferred to only those local skylines of each relation. A comprehensive experiment have been performed on both synthetic and real-life datasets, which demonstrate the effectiveness and versatility of our approach in comparison to the current existing approaches. We argue that our approach is practical and can be adopted in many contemporary cloud database systems with incomplete data to process skyline queries.https://www.scienceopen.com/document?vid=b90dd72e-e3c8-497e-9765-c1c27d0aeec5
spellingShingle Yonis Gulzar
Ali Amer Alwan Aljuboori
Norsaremah Salleh
Imad Al Shaikhli
IDENTIFYING SKYLINES IN CLOUD DATABASES WITH INCOMPLETE DATA
Journal of ICT
title IDENTIFYING SKYLINES IN CLOUD DATABASES WITH INCOMPLETE DATA
title_full IDENTIFYING SKYLINES IN CLOUD DATABASES WITH INCOMPLETE DATA
title_fullStr IDENTIFYING SKYLINES IN CLOUD DATABASES WITH INCOMPLETE DATA
title_full_unstemmed IDENTIFYING SKYLINES IN CLOUD DATABASES WITH INCOMPLETE DATA
title_short IDENTIFYING SKYLINES IN CLOUD DATABASES WITH INCOMPLETE DATA
title_sort identifying skylines in cloud databases with incomplete data
url https://www.scienceopen.com/document?vid=b90dd72e-e3c8-497e-9765-c1c27d0aeec5
work_keys_str_mv AT yonisgulzar identifyingskylinesinclouddatabaseswithincompletedata
AT aliameralwanaljuboori identifyingskylinesinclouddatabaseswithincompletedata
AT norsaremahsalleh identifyingskylinesinclouddatabaseswithincompletedata
AT imadalshaikhli identifyingskylinesinclouddatabaseswithincompletedata