scholarly journals Simulation Studies of Distributed Two-phase Locking in Distributed Database Management Systems

2015 ◽  
Vol 13 (1-2) ◽  
pp. 46-55 ◽  
Author(s):  
Svetlana Vasileva ◽  
Aleksandar Milev
Keyword(s):  
Phase Locking ◽  
Database Systems ◽  
Distributed Database ◽  
Simulation Modelling ◽  
Integrated Modelling ◽  
Two Phase ◽  
Distributed Database Systems ◽  
Timestamp Ordering ◽  
Distributed Database Management ◽  
Personal Version

Abstract This paper considers algorithms simulating the implementation of distributed two-phase locking (2PL) protocols in distributed database systems and simulation results. It describes specifically the simulations of two-version 2PL and 2PL with integrated timestamp ordering mechanism. Integrated modelling algorithms for deadlock avoiding are suggested in the paper: twoversion architecture of database and timestamp ordering strategy “wait-die”. The results of the simulations of these two variants of the 2PL method at different scales of the networks for data transmission and at different intensities of inflow transactions are also presented. Modelling algorithms are developed by means of the system for simulation modelling GPSS World Personal Version.

Performance Evaluation of Distributed Database Systems

2014 ◽  
Vol 13 (9) ◽  
pp. 4859-4867
Author(s):  
Khaled Saleh Maabreh
Keyword(s):  
Performance Evaluation ◽  
System Performance ◽  
Operation Mode ◽  
Database Systems ◽  
Distributed Database ◽  
Evaluation Study ◽  
Distributed Database Systems ◽  
Different Types ◽  
Distributed Database System ◽  
Distributed Database Management

Distributed database management systems manage a huge amount of data as well as large and increasingly growing number of users through different types of queries. Therefore, efficient methods for accessing these data volumes will be required to provide a high and an acceptable level of system performance.  Data in these systems are varying in terms of types from texts to images, audios and videos that must be available through an optimized level of replication. Distributed database systems have many parameters like data distribution degree, operation mode and the number of sites and replication. These parameters have played a major role in any performance evaluation study. This paper investigates the main parameters that may affect the system performance, which may help with configuring the distributed database system for enhancing the overall system performance.

An Efficient Non-Blocking Commit Protocol

2013 ◽  
Vol 325-326 ◽  
pp. 1692-1696
Author(s):  
Wen Jun Huang ◽  
Long Li ◽  
De Wen Li ◽  
Ke Wei
Keyword(s):  
Single Point ◽  
Database Systems ◽  
Distributed Database ◽  
Communication Overhead ◽  
Two Phase ◽  
Distributed Database Systems ◽  
Three Phase ◽  
Distributed Transaction ◽  
Failure Conditions ◽  
Commit Protocol

The two-phase commit protocol is widely used in distributed database systems to ensure the atomicity of distributed transaction. The traditional two-phase commit protocol fails to solve the blocking problem when the coordinator is out of service. Three-phase non-blocking commit protocol was designed to solve the blocking problem of two phase commit protocol, but it brought heavy communication and log overhead between sites. In todays distributed database systems, due to the growing large number of sites, the failure of single point become more and more often. The traditional commit protocol has become a bottleneck of the system. In this paper, a new non-blocking two-phase commit protocol is proposed to solve the blocking problem. Compared to the traditional three-phase commit protocol, the proposed protocol reduces the log and communication overhead. Theoretical proof has been given to show that the proposed commit protocol is non-blocking and meet the ACID properties under variety of failure conditions.

scholarly journals Benchmarking scalability and elasticity of distributed database systems

2014 ◽  
Vol 7 (12) ◽  
pp. 1219-1230 ◽  
Author(s):  
Jörn Kuhlenkamp ◽  
Markus Klems ◽  
Oliver Röss
Keyword(s):  
Database Systems ◽  
Distributed Database ◽  
Distributed Database Systems
Sign in / Sign up

Export Citation Format

Share Document