DSpace
 

DSpace at IIT Bombay >
IITB Publications >
Article >

Please use this identifier to cite or link to this item: http://dspace.library.iitb.ac.in/jspui/handle/10054/1644

Title: Pipelining in multi-query optimization
Authors: DALVI, NILESH N
SANGHAI, SUMIT K
ROY, PRASAN
SUDARSHAN, S
Keywords: multi-query optimization
algorithms
heuristic methods
computational complexity
query processing
Issue Date: 2003
Publisher: Elsevier
Citation: Journal of Computer and System Sciences 66(4), 728-762
Abstract: Database systems frequently have to execute a set of related queries, which share several common subexpressions. Multi-query optimization exploits this, by finding evaluation plans that share common results. Current approaches to multi-query optimization assume that common subexpressions are materialized. Significant performance benefits can be had if common subexpressions are pipelined to their uses, without being materialized. However, plans with pipelining may not always be realizable with limited buffer space, as we show. We present a general model for schedules with pipelining, and present a necessary and sufficient condition for determining validity of a schedule under our model. We show that finding a valid schedule with minimum cost is NP-hard. We present a greedy heuristic for finding good schedules. Finally, we present a performance study that shows the benefit of our algorithms on batches of queries from the TPCD benchmark.
URI: http://dx.doi.org/10.1016/S0022-0000(03)00031-X
http://hdl.handle.net/10054/1644
http://dspace.library.iitb.ac.in/xmlui/handle/10054/1644
ISSN: 0022-0000
Appears in Collections:Article

Files in This Item:

File Description SizeFormat
6864.pdf757.3 kBAdobe PDFView/Open
View Statistics

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.

 

Valid XHTML 1.0! DSpace Software Copyright © 2002-2010  Duraspace - Feedback