Ordering selection operators under partial ignorance

KH Alyoubi, S Helmer, PT Wood - … of the 24th ACM International on …, 2015 - dl.acm.org
Proceedings of the 24th ACM International on Conference on Information and …, 2015dl.acm.org
Optimising queries in real-world situations under imperfect conditions is still a problem that
has not been fully solved. We consider finding the optimal order in which to execute a given
set of selection operators under partial ignorance of their selectivities. The selectivities are
modelled as intervals rather than exact values and we apply a concept from decision theory,
the minimisation of the maximum regret, as a measure of optimality. The associated decision
problem turns out to be NP-hard, which renders a brute-force approach to solving it …
Optimising queries in real-world situations under imperfect conditions is still a problem that has not been fully solved. We consider finding the optimal order in which to execute a given set of selection operators under partial ignorance of their selectivities. The selectivities are modelled as intervals rather than exact values and we apply a concept from decision theory, the minimisation of the maximum regret, as a measure of optimality. The associated decision problem turns out to be NP-hard, which renders a brute-force approach to solving it impractical. Nevertheless, by investigating properties of the problem and identifying special cases which can be solved in polynomial time, we gain insight that we use to develop a novel heuristic for solving the general problem. We also evaluate minmax regret query optimisation experimentally, showing that it outperforms a currently employed strategy of optimisers that uses mean values for uncertain parameters.
ACM Digital Library
以上显示的是最相近的搜索结果。 查看全部搜索结果