DocumentCode :
3143755
Title :
Preference queries over sets
Author :
Zhang, Xi ; Chomicki, Jan
Author_Institution :
Dept. of Comput. Sci. & Eng., Univ. at Buffalo, Buffalo, NY, USA
fYear :
2011
fDate :
11-16 April 2011
Firstpage :
1019
Lastpage :
1030
Abstract :
We propose a “logic + SQL” framework for set preferences. Candidate best sets are represented using profiles consisting of scalar features. This reduces set preferences to tuple preferences over set profiles. We propose two optimization techniques: superpreference and M-relation. Superpreference targets dominated profiles. It reduces the input size by filtering out tuples not belonging to any best k-subset. M-relation targets repeated profiles. It consolidates tuples that are exchangeable with regard to the given set preference, and therefore avoids redundant computation of the same profile. We show the results of an experimental study that demonstrates the efficacy of the optimizations.
Keywords :
SQL; formal logic; query processing; set theory; M-relation optimization technique; k-subset; logic + SQL framework; preference queries; set preferences; set profiles; superpreference optimization technique; Additives; Aggregates; Algebra; Context; Databases; Generators; Optimization;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Data Engineering (ICDE), 2011 IEEE 27th International Conference on
Conference_Location :
Hannover
ISSN :
1063-6382
Print_ISBN :
978-1-4244-8959-6
Electronic_ISBN :
1063-6382
Type :
conf
DOI :
10.1109/ICDE.2011.5767866
Filename :
5767866
Link To Document :
بازگشت