Handling Fragmented Database Replication through Binary Vote Assignment Grid Quorum

Fauzi Fauzi

doi:10.3844/jcssp.2011.1338.1342

Abstract

Problem statement: Organizations critically needed to supply recent data to users who may be geographically remote, while at the same time handle a volume request of distributed data around multiple sites. The storage, availability and consistency are important issues to be addressed in order to allow distributed users efficiently and safely access data from many different sites. Approach: Data replication is a way to deal with this problem since it provides user with fast, local access to shared data and protects availability of applications because alternate data access options exist. Handling fragmented database replication becomes challenging issue to administrator since the distributed database was scattered into split replica partitions or fragments. Results: This study presented a new mechanism on how to handle the fragmented database replication through the Binary Vote Assignment on Grid Quorum (BVAGQ). We address how to build reliable system by using the proposed BVAGQ for distributed database fragmentation. Conclusion: The result shows that managing fragmented database replication and transaction through proposed BVAGQ is able to preserve the data consistency.

Highlights

Nowadays, organizations critically need to supply recent data to users who may be geographically remote and to handle a volume of requests of data distributed around multiple sites
Distributed database replication involves the process of copying and maintaining database objects in multiple databases that make up a Distributed Database Systems (DDS) (Ren et al, 2003)
Handling fragmented database replication becomes challenging issue to administrator since the distributed database is scattered into split replica partitions or fragments

Summary

Introduction

Organizations critically need to supply recent data to users who may be geographically remote and to handle a volume of requests of data distributed around multiple sites. Replication provides user with fast, local access to shared data and protects availability of applications because alternate data access options exist (Dastgheib, 2010). Each partition or fragment of a distributed database may be replicated into several different sites in distributed environment. Fragmentation in distributed database is very useful in terms of usage, efficiency, parallelism and for security. This strategy will partition the database into disjoint fragments. If data items are located at the site where they used most frequently, locality of reference is high. Even if one site becomes unavailable, users can continue to query or even update the remaining fragments

Methods

Results

Discussion

Conclusion