This project proposes an algorithm which attempts to predict the best execution plan for a join query retrieving data from two remote computers. The goal of this algorithm is to execute efficiently the join query in a distributed database. My algorithm estimates the response time for the possible execution plan based on the size of the transmission data, the transmission speed, and the machine processing speed. Also, the report presents a service-oriented system which executes a join query using my algorithm. The report describes the system development activities under the Unified Process model.

Recommended Citation: Jiang S., Ferner C., Simmonds D., Reinicke B., Clark U., (2011). Optimizing Join Query in Distributed Database. UNCW MS CSIS Proceedings. V. 5 , N. 1 .