Exploiting Indifference for Customization of Partial Order Skylines

Unlike numerical preferences, preferences on attribute values do not show an inherent total order, but skyline computation has to rely on partial orderings explicitly stated by the user. In such orders many object values are incomparable, hence skylines sizes become unpractical. However, the Pareto semantics can be modified to benefit from indifferences: skyline result sizes can be essentially reduced by allowing the user to declare some incomparable values as equally desirable. A major problem of adding such equivalences is that they may result in intransitivity of the aggregated Pareto order and thus efficient query processing is hampered. In this paper we analyze how far the strict Pareto semantics can be relaxed while always retaining transitivity of the induced Pareto aggregation. Extensive practical tests show that skyline sizes can indeed be reduced about two orders of magnitude when using the maximum possible relaxation still guaranteeing the consistency with all user preferences

[1]  Wolf-Tilo Balke,et al.  Efficient Distributed Skylining for Web Information Systems , 2004, EDBT.

[2]  Amihai Motro,et al.  VAGUE: a user interface to relational databases that permits vague queries , 1988, TOIS.

[3]  H. T. Kung,et al.  On the Average Number of Maxima in a Set of Vectors and Applications , 1978, JACM.

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

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

[6]  Wolf-Tilo Balke,et al.  Approaching the Efficient Frontier: Cooperative Database Retrieval Using High-Dimensional Skylines , 2005, DASFAA.

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

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

[9]  Moni Naor,et al.  Optimal aggregation algorithms for middleware , 2001, PODS '01.

[10]  Wolf-Tilo Balke,et al.  Efficient Skyline Queries under Weak Pareto Dominance , 2005 .

[11]  Werner Kießling,et al.  Preference Queries with SV-Semantics , 2005, COMAD.

[12]  Wolf-Tilo Balke,et al.  Multi-objective Query Processing for Database Systems , 2004, VLDB.

[13]  Christos H. Papadimitriou,et al.  Approximately dominating representatives , 2005, Theor. Comput. Sci..

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

[15]  Kian-Lee Tan,et al.  Stratified computation of skylines with partially-ordered domains , 2005, SIGMOD '05.

[16]  Jan Chomicki,et al.  Preference formulas in relational queries , 2003, TODS.

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

[18]  Christian S. Jensen,et al.  In-Route Skyline Querying for Location-Based Services , 2004, W2GIS.

[19]  Lada A. Adamic,et al.  Zipf's law and the Internet , 2002, Glottometrics.

[20]  Qing Liu,et al.  Efficient Computation of the Skyline Cube , 2005, VLDB.

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