Preference formulas in relational queries

The handling of user preferences is becoming an increasingly important issue in present-day information systems. Among others, preferences are used for information filtering and extraction to reduce the volume of data presented to the user. They are also used to keep track of user profiles and formulate policies to improve and automate decision making.We propose here a simple, logical framework for formulating preferences as preference formulas. The framework does not impose any restrictions on the preference relations, and allows arbitrary operation and predicate signatures in preference formulas. It also makes the composition of preference relations straightforward. We propose a simple, natural embedding of preference formulas into relational algebra (and SQL) through a single winnow operator parameterized by a preference formula. The embedding makes possible the formulation of complex preference queries, for example, involving aggregation, by piggybacking on existing SQL constructs. It also leads in a natural way to the definition of further, preference-related concepts like ranking. Finally, we present general algebraic laws governing the winnow operator and its interactions with other relational algebra operators. The preconditions on the applicability of the laws are captured by logical formulas. The laws provide a formal foundation for the algebraic optimization of preference queries. We demonstrate the usefulness of our approach through numerous examples.

[1]  Werner Kießling,et al.  Preference SQL - Design, Implementation, Experiences , 2002, VLDB.

[2]  S. Mantha First-order preference theories and their applications , 1992 .

[3]  Jon Doyle,et al.  Preferential Semantics for Goals , 1991, AAAI.

[4]  Werner Kießling,et al.  Optimizing Preference Queries for Personalized Web Services , 2002, Communications, Internet, and Information Technology.

[5]  Rakesh Agrawal,et al.  A framework for expressing and combining preferences , 2000, SIGMOD '00.

[6]  Peter C. Fishburn,et al.  Preference Structures and Their Numerical Representations , 1999, Theor. Comput. Sci..

[7]  Markus Stolze,et al.  Soft navigation in electronic product catalogs , 2000, International Journal on Digital Libraries.

[8]  Luis Gravano,et al.  Top-k selection queries over relational databases: Mapping strategies and performance evaluation , 2002, TODS.

[9]  M. Lacroix,et al.  Preferences; Putting More Knowledge into Queries , 1987, VLDB.

[10]  Jan Chomicki,et al.  Skyline with presorting , 2003, Proceedings 19th International Conference on Data Engineering (Cat. No.03CH37405).

[11]  Matteo Cristani,et al.  Many-Sorted Preference Relations , 2002, International Conference on Principles of Knowledge Representation and Reasoning.

[12]  Ronen I. Brafman,et al.  Reasoning With Conditional Ceteris Paribus Preference Statements , 1999, UAI.

[13]  Hans Tompits,et al.  Logic Programs with Compiled Preferences , 2000, ECAI.

[14]  Pierre-Yves Schobbens,et al.  Operators and Laws for Combining Preference Relations , 2002, J. Log. Comput..

[15]  Werner Kießling,et al.  Database Reasoning - A Deductive Framework for Solving Large and Complex Problems by Means of Subsumption , 1994, IS/KI.

[16]  Riccardo Torlone,et al.  Management of User Preferences in Data Intensive Applications , 2003, SEBD.

[17]  Vagelis Hristidis,et al.  PREFER: a system for the efficient execution of multi-parametric ranked queries , 2001, SIGMOD '01.

[18]  Thomas Eiter,et al.  Preferred Answer Sets for Extended Logic Programs , 1999, Artif. Intell..

[19]  Rakesh Agrawal,et al.  A framework for expressing and combining preferences , 2000, SIGMOD 2000.

[20]  Werner Kießling,et al.  Preference XPATH: A Query Language for E-Commerce , 2001, Wirtschaftsinformatik.

[21]  Judea Pearl,et al.  Specification and Evaluation of Preferences Under Uncertainty , 1994, KR.

[22]  Serge Abiteboul,et al.  Foundations of Databases , 1994 .

[23]  Bernhard Seeger,et al.  An optimal and progressive algorithm for skyline queries , 2003, SIGMOD '03.

[24]  Robin Burke,et al.  Integrating Knowledge-based and Collaborative-filtering Recommender Systems , 2000 .

[25]  Wei Sun,et al.  Solving satisfiability and implication problems in database systems , 1996, TODS.

[26]  Kannan Govindarajan,et al.  Preference Logic Programming , 1995, ICLP.

[27]  Michael J. Carey,et al.  On saying “Enough already!” in SQL , 1997, SIGMOD '97.

[28]  Werner Kießling,et al.  Fixpoint iteration with subsumption in deductive databases , 1995, Journal of Intelligent Information Systems.

[29]  Werner Kießling,et al.  Foundations of Preferences in Database Systems , 2002, VLDB.

[30]  Chiaki Sakama,et al.  Prioritized logic programming and its application to commonsense reasoning , 2000, Artif. Intell..

[31]  Gabriel M. Kuper,et al.  Constraint Query Languages , 1995, J. Comput. Syst. Sci..

[32]  H. Chernoff Rational Selection of Decision Functions , 1954 .

[33]  Kevin Knight,et al.  Unification: a multidisciplinary survey , 1989, CSUR.

[34]  Gabriel M. Kuper,et al.  Constraint Databases , 2010, Springer Berlin Heidelberg.

[35]  Stephen T. C. Wong,et al.  Preference-based decision making for cooperative knowledge-based systems , 1994, TOIS.

[36]  Donald Kossmann,et al.  The Skyline operator , 2001, Proceedings 17th International Conference on Data Engineering.

[37]  Werner Kießling,et al.  Algebraic Optimization of Relational Preference Queries , 2003 .

[38]  N. Rescher The Logic of Preference , 1968 .

[39]  Riccardo Torlone,et al.  Which are my preferred items , 2002 .

[40]  R. Hughes Rationality and Intransitive Preferences , 1980 .

[41]  Donald Kossmann,et al.  Shooting Stars in the Sky: An Online Algorithm for Skyline Queries , 2002, VLDB.

[42]  Sergio Greco,et al.  Programming with non-determinism in deductive databases , 2004, Annals of Mathematics and Artificial Intelligence.

[43]  Jim Melton,et al.  SQL: 1999, formerly known as SQL3 , 1999, SGMD.

[44]  R. M. Adelson,et al.  Utility Theory for Decision Making , 1971 .

[45]  Markus Stolze,et al.  Soft Navigation in Product Catalogs , 1998, ECDL.

[46]  Moshe Y. Vardi The complexity of relational query languages (Extended Abstract) , 1982, STOC '82.

[47]  Gerhard Weikum,et al.  ACM Transactions on Database Systems , 2005 .

[48]  Stéphane Grumbach,et al.  Constraint Databases , 1999, JFPLC.

[49]  Jan Chomicki,et al.  Querying with Intrinsic Preferences , 2002, EDBT.