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