© 1985 by British Computer Society
Analysis and Optimisation of Data Currency and Consistency in Replicated Distributed Databases
Department of Computer Science, University College London, Gower Street, London, WC1E 6BT, UK
Data currency and consistency for the single primary update and moving primary update strategies for replicated distributed databases are analysed. Data currency and consistency are expressed in terms of probabilities and their evaluation is based on a quantitative analysis of the race condition to which the system is subject; the race condition is dependent on the intensity of site transaction traffic and the speed of update propagation. Both homogeneous and heterogeneous systems are considered. A common requirement of resilient systems is dynamic site re-configuration which may, for example, be necessitated by an earlier site crash. Here algorithms for configuration optimisation are presented for both strategies which are simple and practical to implement; such optimisation could dramatically increase data currency and consistency, and improvements of 30% to 100+% are not untypical. In addition, the present evaluation also allows the quantitative justification of a number of intuitively known facts relating to data currency and consistency.
* Department of Computer Science, University College London, Gower Street, London, WC1E 6BT