• 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