ecms_neu_mini.png

Digital Library

of the European Council for Modelling and Simulation

 

Title:

Simulation Studies Of The Implementation Of Centralized Two-Phase Locking In DDBMS

Authors:

Alina Culciar, Svetlana Vasileva

Published in:

 

 

(2015).ECMS 2015 Proceedings edited by: Valeri M. Mladenov, Grisha Spasov, Petia Georgieva, Galidiya Petrova, European Council for Modeling and Simulation. doi:10.7148/2015

 

 

ISBN: 978-0-9932440-0-1

 

29th European Conference on Modelling and Simulation,

Albena (Varna), Bulgaria, May 26th – 29th, 2015

 

Citation format:

Alina Culciar, Svetlana Vasileva (2015). Simulation Studies Of The Implementation Of Centralized Two-Phase Locking In DDBMS, ECMS 2015 Proceedings edited by: Valeri M. Mladenov, Petia Georgieva, Grisha Spasov, Galidiya Petrova  European Council for Modeling and Simulation. doi:10.7148/2015-0107

DOI:

http://dx.doi.org/10.7148/2015-0107

Abstract:

One of the most important problems in distributed database systems is the concurrency control. This paper considers algorithms simulating the implementation of centralized two-phase locking (2PL) in distributed database systems and simulation results. It describes specifically the simulations of two-version 2PL and 2PL with integrated timestamp ordering mechanism. In concurrency control method 2PL may take place deadlocks of the transactions. Therefore, in the modeling algorithms described here are integrated algorithms for deadlock avoiding: two-version architecture of database and timestamp ordering strategy “wait-die”. There are also presented, the results of the simulations of these two variants of the 2PL method at different scales of the networks for the transmission of data and at different intensities of inflow transactions. Modeling algorithms are developed by means of the system for simulation modeling GPSS World Personal Version.

Full text: