Date of Award
12-1986
Degree Name
Master of Science
Department
Computer Science
First Advisor
Dr. Dalia Motzkin
Access Setting
Masters Thesis-Open Access
Abstract
In this paper a method for horizontal fragmentation of a relational database is presented. A method is given for calculating the benefit or cost savings obtained by allocating a given fragment to a site, independently for each site.
To obtain optimal benefit each fragment is allocated to all sites where there is a positive benefit. This may result in the allocation of some fragments to multiple sites.
Finally a method is given for removing or reallocating certain fragments from sites with insufficient storage. Also, a method is given for allocating fragments to multiple sites to meet constraints on the required reliability of applications of the database.
Recommended Citation
Ivey, Elmo Loren, "Horizontal Fragmentation and Allocation in a Distributed Database for Cost Minimization with Reliability and Space Constraints" (1986). Masters Theses. 1334.
https://scholarworks.wmich.edu/masters_theses/1334