Date of Award
Master of Science
Dr. Dalia Motzkin
Masters Thesis-Open Access
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.
Ivey, Elmo Loren, "Horizontal Fragmentation and Allocation in a Distributed Database for Cost Minimization with Reliability and Space Constraints" (1986). Master's Theses. 1334.