Tikrit Journal of Pure Science, vol.23, no.10, pp.87-101, 2019 (Peer-Reviewed Journal)
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.