@inproceedings{DBLP:conf/vldb/MuroIMH83, author = {Shojiro Muro and Toshihide Ibaraki and Hidehiro Miyajima and Toshiharu Hasegawa}, editor = {Mario Schkolnick and Costantino Thanos}, title = {File Redundancy Issues in Distributed Database Systems}, booktitle = {9th International Conference on Very Large Data Bases, October 31 - November 2, 1983, Florence, Italy, Proceedings}, publisher = {Morgan Kaufmann}, year = {1983}, isbn = {0-934613-15-X}, pages = {275-277}, ee = {db/conf/vldb/MuroIMH83.html}, crossref = {DBLP:conf/vldb/83}, bibsource = {DBLP, http://dblp.uni-trier.de} }
This paper treats the file redundancy issue in distributed database systems asking what is the optimal number of file copies, given the ratio r of the frequencies of query and update requests. To draw a general conclusion applicable to a wide variety of practical distributed database systems, simplified network models are constructed, and optimal number of file copies, as well as their locations, to minimize the communication cost is ccmputed. By examining various network types, we plot the optimal number of file copies as a function of the ratio r.
Our conclusion is that a single copy suffices under moderate condition, and it is disadvantageous to have more than a few copies unless the frequency of query requests is unduly higher (e.g., 50 times) than that of update requests.
Copyright © 1983 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.