Decomposition of Database Preferences
- n the Power Set of the Domain
Patrick Roocks
Institute for Computer Science, University of Augsburg
Decomposition of Database Preferences on the Power Set of the Domain - - PowerPoint PPT Presentation
Decomposition of Database Preferences on the Power Set of the Domain Patrick Roocks Institute for Computer Science, University of Augsburg RAMiCS15, Braga October 1, 2015 Introduction Power sets Decompostion Optimization Motivation
Institute for Computer Science, University of Augsburg
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ Database preferences construct strict partial orders ▸ They are a slight generalization of Skylines queries ▸ The allow optimizing w.r.t. many dimensions simultaneously ▸ For example: Pareto optimal cars with low fuel consumption (high
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ Database preferences construct strict partial orders ▸ They are a slight generalization of Skylines queries ▸ The allow optimizing w.r.t. many dimensions simultaneously ▸ For example: Pareto optimal cars with low fuel consumption (high
15 20 25 30 100 200 mpg (miles per gallon) hp (horsepower)
21.5, 97 15.5, 150 15.2, 150 13.3, 245 19.2, 175 27.3, 66 26, 91 30.4, 113 15.8, 264 19.7, 175 Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ Assume that a user having such a preferences has to decide between
▸ Use case: choose a car rental agency with two different fleets
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ Assume that a user having such a preferences has to decide between
▸ Use case: choose a car rental agency with two different fleets
▸ Hence we search for the induced power set preference
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ r = x1 + ... + xn is a finite data set with tuples xi. ▸ a preference a has an associated equivalence relation sa ▸ relational operations: union +, composition ⋅, intersection ⊓ ▸ inclusion order ≤ ▸ special relations:
▸ empty relation 0 ▸ identity 1 ▸ universal relation ⊺ Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ a ⊗ b is the Pareto composition
▸ The Prioritisation a & b equals the lexicographical order
▸ The set preference t(s) for s ≤ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ t(x1) ▸ t(x1) & t(x2 + x3)
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ t(x1) ▸ t(x1) & t(x2 + x3)
▸ t(x1) ⊗ t(x2) ▸ (t(x1) ⊗ t(x2)) & t(x3)
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ t(x1) ▸ t(x1) & t(x2 + x3)
▸ t(x1) ⊗ t(x2) ▸ (t(x1) ⊗ t(x2)) & t(x3)
▸ (t(x1) & t(x3)) ⊗ t(x2) ▸ t(x1) ⊗ t(x1 + x3) ⊗ t(x2)
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ Set preferences and ⊗ suffice to express arbitrary strict orders ▸ Tuple preferences and {&,⊗} also suffice ▸ &-composed set preferences are a proper sub class
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Motivation Preference background
▸ Set preferences and ⊗ suffice to express arbitrary strict orders ▸ Tuple preferences and {&,⊗} also suffice ▸ &-composed set preferences are a proper sub class
▸ We formally introduce the power construction for preferences ▸ We apply the decomposition algorithms to them ▸ We introduce some optimizations to retrieve shorter terms
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Power set preferences
0 v
1 v
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Power set preferences
0 v
1 v
1
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Power set preferences
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Power set preferences
0 v
1 v
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Power set preferences
0 v
1 v
2 =df πa 0 ⊓ πa 1.
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
▸ In the following we revisit the decomposition methods from the
▸ Let r = x1 + ... + x5 a data set and consider the following preference:
▸ We show example runs of both preference decomposition methods ▸ Additional definition: The maximum operator is given by
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
x ∈ r
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Set preferences and ⊗ Tuple preferences and {&, ⊗}
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
▸ The decomposition creates a lot of redundancy ▸ Consider b = t(x1 + x2) on r = x1 + ... + x5 ▸ The decomposition into tuple preferences and {&,⊗} results in
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
▸ The decomposition creates a lot of redundancy ▸ Consider b = t(x1 + x2) on r = x1 + ... + x5 ▸ The decomposition into tuple preferences and {&,⊗} results in
▸ Idea: merge “equivalent” nodes in the Hasse diagram
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
1, reducing the graph largely:
1)min is isomorphic to that of a.
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
2
2
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
2
2
2)min
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
1
1
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
1
1
1)min
1)min is still more complex than the original preference b
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
▸ The term complexity of the decompositions can be reduced ▸ This optimization is useful for decomposed power set preferences ▸ See the paper for an empirical study underlining that
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
▸ The term complexity of the decompositions can be reduced ▸ This optimization is useful for decomposed power set preferences ▸ See the paper for an empirical study underlining that ▸ Implementations of the algorithms are available at
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain
Introduction Power sets Decompostion Optimization Idea Formal definition Conclusion
▸ The term complexity of the decompositions can be reduced ▸ This optimization is useful for decomposed power set preferences ▸ See the paper for an empirical study underlining that ▸ Implementations of the algorithms are available at
▸ Is there a closed formula determining the term length of a
▸ How can we retrieve provable minimal decompositions?
Patrick Roocks – Decomposition of Database Preferences on the Power Set of the Domain