Managing MyGRANTS Fragmented Database Using Binary Vote Assignment Grid Quorum with Association Rule (BVAGQ-AR) Replication Model

Replication is one of the mechanisms managing data since it improves data access and reliability. However, in recent years, with widely available, low-cost technology, the amount of various data grows rapidly. The problem is although we are packed with data, but we have lacked of knowledge. Nevertheless, if the impractical data is used in database replication, this will cause waste of data storage and the time taken for a replication process will be delayed. This paper propose a new algorithm namely Binary Vote Assignment on Grid Quorum with Association Rule (BVAGQ-AR) in order to handle fragmented database replication. BVAGQ-AR algorithm is capable of partitioning the database into disjoint fragments. Fragmentation in distributed database is very useful in terms of usage, reliability and efficiency. Handling fragmented database replication becomes challenging issue to administrator since the distributed database is scattered into split replica partitions or fragments. We address how to build reliable system by using the proposed BVAGQ-AR algorithm for distributed database fragmentation by using Malaysian Greater Research Network (MyGRANTS) data as a case study. The result shows that managing fragmented database replication through proposed BVAGQ-AR algorithm able to preserve MyGRANTS data consistency