A Case Study of Snapshot Replication and Transfer of Data in Distributed Databases

Abstract

The database replication refers to distributing a database among multiple locations. There are three kinds of database replication system: snapshot, transactional and merge. The snapshot replication refers to the fragment of database items and distributing them to multi databases at once. An important goal in this paper is to experiment with a distributed database study the snapshot replication and examine the issues associated with it. In this work, the data from another database is used to increase availability and flexibility as well as provide the information exchange between databases. In this process, the data is infrequently updated at specified periods by copying and changing the data from the original database towards the subscriber database. The work of agents in this technology will do the most of the work to achieve the stated goal. The experimental results show that at both vertical and horizontal fragmentation, the proposed approach of replicating distributed database is efficient and the performance is significantly improved in terms of data transfer time, load sharing and update of database fragmentation. Hence the snapshot replication system is much schedulable and protective replication in business markets.