PUMA
Istituto di Scienza e Tecnologie dell'Informazione     
Thanos C., Bertino E., Carlesi C. The effects of two-phase locking on the performance of a distributed database management system. In: Performance Evaluation, vol. 8 pp. 129 - 157. Elsevier, 1988.
 
 
Abstract
(English)
In this paper, the effects of two-phase locking on the performance of a distributed database management system are evaluated. In particular, the relationship between the average transaction response time for four concurrency control algorithms based on two-phase locking has been established with respect to the static degree of interference for a given multiprogramming level, database size, and transaction size. The increase in average probability of one lock request conflicting with another has been measured with respect to the static degree of interference and the percentage of aborted transactions has been measured for each algorithm. In addition, the impact of a number of parameters (e.g. data replicatioI1, lock predeclaration, time-out, local processing time, degree of locality of references, interarrival time, number of nodes and transmission time) on the performance of a distributed database management system in the presence of a concurrency control mechanism has also been measured. The study has been made using simulation and the SIMULA programming language.
Subject Database
Distributed Database
Concurrency Control
Two-Phase Locking
Simulation


Icona documento 1) Download Document PDF


Icona documento Open access Icona documento Restricted Icona documento Private

 


Per ulteriori informazioni, contattare: Librarian http://puma.isti.cnr.it

Valid HTML 4.0 Transitional