The objective of this study is to analyse the various technical aspects of synchronization between databases while replication is occurred. To achieve this feat we embarked in a systematic review of the literature around this theme an examination that revealed that synchronization is not done with more than one Peer at the time. Therefore we have been motivated to develop an algorithm which supports the synchronization with more than one Peer.
Background and Objective: This paper presents a systematic review of the two replication approaches namely: synchronous replication and asynchronous replication. The purpose of this study is to analyse the different technical aspects of synchronization between databases during replication. Methodology: To achieve this we used the documentary method that allowed us to collect the necessary documents containing the literature that fits with this research and that allowed us to conduct this review. Apart from this one algorithmic helped us to develop a model that supports synchronization with more than one peer. Result: Our long-awaited result being an algorithm we have similarly taken care to present the fruits of the efforts of our predecessors who would have proceeded in the same way as us. Conclusion: Finally we found that it is necessary to have a synchronization algorithm independently of the DBMSs that can be used by the designers of distributed databases.
, International Journal of Scientific Research in Computer Science Engineering and Information Technology, 2017, CSEIT174443