The Repository @ St. Cloud State

Open Access Knowledge and Scholarship

Date of Award

5-2005

Culminating Project Type

Thesis

Degree Name

Special Studies: M.S.

Department

Information Assurance and Information Systems

College

Herberger School of Business

First Advisor

Dennis Guster

Second Advisor

Richard Sundheim

Third Advisor

Richard Mowe

Creative Commons License

Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.

Abstract

Although the concept of the distributed database has been around for over 20 years, it has not dominated the computer landscape especially in business-related applications. This paper will explore the effectiveness of distributed database under a variety of conditions by conducting experiments using a number of different combinations of variables listed below. Specifically, the following questions will be researched:

  1. How does the workload intensity influence the need and performance of distributed database applications?
  2. How does the number of nodes the database is stored upon affect the data access time?
  3. How does the method used to assign a given query to a specific database node influence the access time?

The first variable is workload intensity. It is expected as intensity increases the need to utilize some form of distributed database increases. The second factor is number of nodes upon which the database is distributed. One would expect that as the number of nodes increases, access time would be reduced. The third variable is the algorithm used to distribute the inquiries across multiple nodes. A symmetric algorithm, one that provides an equal chance of any given inquiry landing on any specific node, would be expected to offer the most promise. However, results indicate the load balanced method outperforms both the sequential and random selection methods.

Comments/Acknowledgements

I would like to thank my father and mother, Gregory and Wendee Brown, for encouraging me to complete my thesis after two unsuccessful topics. To my sisters, Tami, Jessica, and Faith, and brother Joshua for offering encouragement and motivational tools like the “Just Do It” hat. Special appreciation extended to Lee Lorentz (WBOTRA) for offering the use of his HAM log data and Chuck Hall for many long nights in the lab testing algorithms. Special thanks go to my committee for being patient and flexible with me through the years of deliberating over a topic. Finally, I extend my deepest appreciation to Dr. Dennis Guster who believed in me when I did not believe in myself.

Share

COinS