Implementing new approach for enhancing performance and throughput in a distributed database

Abstract EN

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.