A Cost Model for the Estimation of Query Execution Time in a Parallel Environment Supporting Pipeline

M. Spiliopoulou, M. Hatzopoulos and C. Vassilakis
in Journal Computers and Artificial Intelligence, Vol. 14, 1996, No. 1, pp. 341-368

We propose a model for the estimation of query execution time in an environment supporting bushy and pipelined parallelism. We consider a parallel architecture of processors having private main memories, accessing a shared secondary storage and communicating to each other via a network. For this environment, we compute the cost of query operators when processed in isolation and when in pipeline mode. We use those formulae to incrementally compute the cost of a query execution plan from its components. Our cost model can be incorporated to any optimizer for parallel query processing that considers parallel and pipelined execution of the query operators.

Note: This material is presented to ensure timely dissemination of scholarly and technical work. Copyright and all rights therein are retained by authors or by other copyright holders. All persons copying this information are expected to adhere to the terms and constraints invoked by each author's copyright. In most cases, these works may not be reposted without the explicit permission of the copyright holder.
PDF icon cost-model-95.pdf259.36 KB