Implementing New Approach for Enhancing Performance and Throughput in A Distributed Database

Khaled Maabreh1 and Alaa al Hamami2
1Faculty of Information Technology and Computer Science, Zarqa University, Jordan
2Graduate College of Computer Studies, Amman Arab University for Graduate Studies, Jordan

 
Abstract: A distributed database system consists of a number of sites over a network and has a huge amount of data. Besides a high number of users use these data. The lock manager coordinates the use of database resources among distributed transactions. Because a distributed transaction consists of several participants to execute over sites; all participants must guarantee that any change to data will be permanent in order to commit the transaction.
Because the number of users is increasingly growing and the data must be available all of the time, this research applied a new method for reducing the size of lockable entities to allow several transactions to access the same database row simultaneously, the other attributes remain available to other users if needed. It is possible to do that by increasing the granularity hierarchy tree one more level down at the attributes. The experimental results proved that using attribute level locking will increase the throughput and enhance the system performance.

Keywords: Granularity hierarchy tree, locks, attribute level, concurrency control, data availability.

 

Received March 16, 2011; accepted July 28, 2011

  

Full Text