International Conference on Information Technology: Coding and Computing (ITCC'04) Volume 1 A Model for Multiple-Query Processing Based upon Strong Factoring Las Vegas, Nevada April 05-April 07 ISBN: 0-7695-2108-8
This paper proposes a model for interleaving the execution of multiple queries simultaneously. The queries are rewritten, in the context of each other, in order to induce common subexpressions (CSEs). A CSE will then need to be evaluated once only and its result is used in the evaluation of the queries that contain it, thereby leading to cost saving over the conventional query-at-a-time scenario. Two important aspects characterize the proposed model. First, it rewrites the queries in such a way that the isolated CSEs are, themselves, heuristically efficient to evaluate during query execution. Second, it reduces the optimization overhead (due to query rewriting) by using a divide-and-conquer approach to deduce relationships among inter-query selection conditions on base relations while using only pattern matching to find relationships among higher-order subexpressions (those involving an arbitrary number of joins).
Index Terms:
Multiple Query Optimization, Multi-Query Optimization, global Query Optimization, Common Subexpressions, Database Management Systems
Citation:
Jamal R. Alsabbagh, Vijay V. Raghavan, "A Model for Multiple-Query Processing Based upon Strong Factoring," itcc, vol. 1, pp.528, International Conference on Information Technology: Coding and Computing (ITCC'04) Volume 1, 2004 Usage of this product signifies your acceptance of the Terms of Use. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||