Solving Data Availability Problem by Increasing the Granularity Hierarchy Tree Levels to Reduce the Size of Lockable Entities
Dr.KHALED S. MAABREH and Prof. Dr. ALAA Al-HAMAMI
Zarqa Private University
Amman, Jordan, 2009
Abstract
There are many situations in which the transaction does not need the whole attributes during its process, so according to the increasing need for data to be available, there must be solutions to make the data available in a reliable way. This research suggested method here is to increase the availability of data, by reducing the size of lockable entities. This can be done by increasing the granularity hierarchy tree one more level down at the attributes to allow several transactions to access the same row simultaneously. The results proved that the suggested level has decreased the user competition for acquiring data items and to increase the performance of the database..
Keywords: Centralized Database, Locking, Attribute Level, Database Deadlock, Performance.