Adaptive Lockable Units to Improve Data Availability in a Distributed Database System

Abstract

Distributed database systems have become a phenomenon and have been considered a crucial source of information for numerous users. Users with different jobs are using such systems locally or via the Internet to meet their professional requirements. Distributed database systems consist of a number of sites connected over a computer network. Each site deals with its own database and interacts with other sites as needed. Data replication in these systems is considered a key factor in improving data availability. However, it may affect system performance when most of the transactions that access the data contain write or a mix of read and write operations because of exclusive locks and update propagation. This research proposes a new adaptive approach for increasing the availability of data contained in a distributed database system. The proposed approach suggests a new lockable unit by increasing the database hierarchy tree by one level to include attributes as lockable units instead of the entire row. This technique may allow several transactions to access the database row simultaneously by utilizing some attributes and keeping others available for other transactions. Data in a distributed database system can be accessed locally or remotely by a distributed transaction, with each distributed transaction decomposed into several sub-transactions called participants or agents. These agents access the data at multiple sites and must guarantee that any changes to the data must be committed in order to complete the main transaction. The experimental results show that using attribute-level locking will increase data availability, reliability, and throughput, as well as enhance overall system performance. Moreover, it will increase the overhead of managing such a large number of locks, which will be managed according to the qualification of the query.

Authors and Affiliations

Khaled Maabreh

Keywords

Related Articles

A Context-Sensitive Approach to Find Optimum Language Model for Automatic Bangla Spelling Correction

Automated spelling correction is an important phenomenon in typing that has intense effect on aiding both literate and semi-literate people while using keyboard or other similar devices. Such automated spelling correctio...

Hierarchical Cellular Structures in High-Capacity Cellular Communication Systems 

In the prevailing cellular environment, it is important to provide the resources for the fluctuating traffic demand exactly in the place and at the time where and when they are needed. In this paper, we explored the abil...

Distributed Group Key Management with Cluster based Communication for Dynamic Peer Groups

Secure group communication is an increasingly popular research area having received much attention in recent years. Group key management is a fundamental building block for secure group communication systems. This paper...

An Investigational Study and Analysis of Cloud-based Content Delivery Network: Perspectives

The content management includes a major technical strategy in the network paradigm of the internet which is called a Content delivery network. The design and the deployment of the CDN shall ensure optimal Quality of serv...

Audio Search Based on Keyword Spotting in Arabic Language

Keyword spotting is an important application of speech recognition. This research introduces a keyword spotting approach to perform audio searching of uttered words in Arabic speech. The matching process depends on the u...

Download PDF file
  • EP ID EP112173
  • DOI 10.14569/IJACSA.2016.070168
  • Views 106
  • Downloads 0

How To Cite

Khaled Maabreh (2016). Adaptive Lockable Units to Improve Data Availability in a Distributed Database System. International Journal of Advanced Computer Science & Applications, 7(1), 495-500. https://europub.co.uk/articles/-A-112173