V5 N1 Paper 1
Annals of the MS in Computer Science and Information Systems at UNC Wilmington
Spring 2011

Optimizing Join Query in Distributed Database  

Shun Jiang

Committee

Clayton Ferner (chair)
Devon Simmonds
Bryan Reinicke
Ulku Clark

Abstract

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.

download (pdf)

Recommended Citation: Jiang, S., Ferner, C, Simmonds, D., Reinicke, B., Clark, U. (2011) Optimizing Join Query in Distributed Database. Annals of the Master of Science in Computer Science and Information Systems at UNC Wilmington, 5(1) paper 1. http://csbapp.uncw.edu/data/mscsis/full.aspx.

V5 N1 Paper 1
Annals of the MS in Computer Science and Information Systems at UNC Wilmington
Spring 2011