Preference evaluation techniques of preference queries in database

Preference queries are considered as a major necessity tool in today’s database management system (DBMS). Adopting preference queries in the database application systems enable users to determine more than one objective in the submitted query which result into more accurate results compared to the...

Full description

Bibliographic Details
Main Authors: Alwan, Ali A., Ibrahim, Hamidah, Udzir, Nur Izura, Sidi, Fatimah
Format: Article
Language:English
Published: Advanced Institute of Convergence Information Technology 2013
Online Access:http://psasir.upm.edu.my/id/eprint/30579/1/Preference%20evaluation%20techniques%20of%20preference%20queries%20in%20database.pdf
_version_ 1796971769513377792
author Alwan, Ali A.
Ibrahim, Hamidah
Udzir, Nur Izura
Sidi, Fatimah
author_facet Alwan, Ali A.
Ibrahim, Hamidah
Udzir, Nur Izura
Sidi, Fatimah
author_sort Alwan, Ali A.
collection UPM
description Preference queries are considered as a major necessity tool in today’s database management system (DBMS). Adopting preference queries in the database application systems enable users to determine more than one objective in the submitted query which result into more accurate results compared to the traditional queries. Preference queries prefer one data item (tuple) p over the other data item (tuple) q if and only if p is better than q in all dimensions (attributes) and not worse than q in at least one dimension (attribute). Several preference evaluation techniques for preference queries have been proposed which aimed at finding the “best” results that meet the user preferences. These include but not limited to top-k, skyline, ranked skylines, k-representative dominance, k-dominance,top-k dominating, and k-frequency. This paper attempts to survey and analyze the following preference evaluation techniques of query processing in database systems: top-k, skyline, top-k dominating, k-dominance, and k-frequency by highlighting the strengths and the weaknesses of each technique.
first_indexed 2024-03-06T08:17:59Z
format Article
id upm.eprints-30579
institution Universiti Putra Malaysia
language English
last_indexed 2024-03-06T08:17:59Z
publishDate 2013
publisher Advanced Institute of Convergence Information Technology
record_format dspace
spelling upm.eprints-305792015-09-07T07:50:36Z http://psasir.upm.edu.my/id/eprint/30579/ Preference evaluation techniques of preference queries in database Alwan, Ali A. Ibrahim, Hamidah Udzir, Nur Izura Sidi, Fatimah Preference queries are considered as a major necessity tool in today’s database management system (DBMS). Adopting preference queries in the database application systems enable users to determine more than one objective in the submitted query which result into more accurate results compared to the traditional queries. Preference queries prefer one data item (tuple) p over the other data item (tuple) q if and only if p is better than q in all dimensions (attributes) and not worse than q in at least one dimension (attribute). Several preference evaluation techniques for preference queries have been proposed which aimed at finding the “best” results that meet the user preferences. These include but not limited to top-k, skyline, ranked skylines, k-representative dominance, k-dominance,top-k dominating, and k-frequency. This paper attempts to survey and analyze the following preference evaluation techniques of query processing in database systems: top-k, skyline, top-k dominating, k-dominance, and k-frequency by highlighting the strengths and the weaknesses of each technique. Advanced Institute of Convergence Information Technology 2013-03 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/30579/1/Preference%20evaluation%20techniques%20of%20preference%20queries%20in%20database.pdf Alwan, Ali A. and Ibrahim, Hamidah and Udzir, Nur Izura and Sidi, Fatimah (2013) Preference evaluation techniques of preference queries in database. International Journal of Advancements in Computing Technology, 5 (5). pp. 756-766. ISSN 2005-8039; ESSN: 2233-9337
spellingShingle Alwan, Ali A.
Ibrahim, Hamidah
Udzir, Nur Izura
Sidi, Fatimah
Preference evaluation techniques of preference queries in database
title Preference evaluation techniques of preference queries in database
title_full Preference evaluation techniques of preference queries in database
title_fullStr Preference evaluation techniques of preference queries in database
title_full_unstemmed Preference evaluation techniques of preference queries in database
title_short Preference evaluation techniques of preference queries in database
title_sort preference evaluation techniques of preference queries in database
url http://psasir.upm.edu.my/id/eprint/30579/1/Preference%20evaluation%20techniques%20of%20preference%20queries%20in%20database.pdf
work_keys_str_mv AT alwanalia preferenceevaluationtechniquesofpreferencequeriesindatabase
AT ibrahimhamidah preferenceevaluationtechniquesofpreferencequeriesindatabase
AT udzirnurizura preferenceevaluationtechniquesofpreferencequeriesindatabase
AT sidifatimah preferenceevaluationtechniquesofpreferencequeriesindatabase