loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
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
Jamal R. Alsabbagh, Grand Valley State University, Allendale, MI
Vijay V. Raghavan, University of Louisiana - Lafayette
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.