Adaptive Lockable Units to Improve Data Availability in a Distributed Database System
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2016, Vol 7, Issue 1
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
- EP ID EP112173
- DOI 10.14569/IJACSA.2016.070168
- Views 107
- Downloads 0
Identifying Top-k Most Influential Nodes by using the Topological Diffusion Models in the Complex Networks
Social networks are sub-set of complex networks, where users are defined as nodes, and the connections between users are edges. One of the important issues concerning social network analysis is identifying influential an...
Performance Comparison of different hybrid amplifiers for different numbers of channels
We have investigated the performance comparison of different hybrid optical amplifiers (RAMAN-EDFA,RAMAN-SOA,SOA-EDFA,EDFA-RAMAN-EDFA).The proposed configuration consists of 16, 32 and 64 Gbps channels at speed of 10 Gbp...
Customer Value Proposition for E-Commerce: A Case Study Approach
E-Commerce tools have become a human needs everywhere and important not only to customers but to industry players. The intention to use E-Commerce tools among practitioners, especially in the Malaysian retail sector is n...
A Fuzzy Rough Rule Based System Enhanced By Fuzzy Cellular Automata
Handling uncertain knowledge is a very tricky problem in the current world as the data, we deal with, is uncertain, incomplete and even inconsistent. Finding an efficient intelligent framework for this kind of knowledge...
Formal Specification and Analysis of Termination Detection by Weight-throwing Protocol
Termination detection is a critical problem in distributed systems. A distributed computation is called terminated if all of its processes become idle and there are no in-transit messages in communication channels. A dis...