Efficient execution of query in distributed database systems

Caching methods can be used for single query optimization and for multi-query optimization. Cost of evaluation can be reduced by exploiting common subexpressions and maintaining intermediate data structure. In this paper with integrating single query optimization, cache investment and multi-query optimization performance of query execution in distributed database systems will be improved. Maintaining intermediate data structure generated by queries, caching input data in memory, providing support for multi-threaded execution and using hybrid shipping has been used for this purpose. Finally this model reduce evaluation cost, communication cost and response time.