Synchronous and Asynchronous Replication

Authors(3) :-Katembo Kituta Ezechiel, Dr. Ruchi Agarwal, Dr. Baijnath Kaushik

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.

Authors and Affiliations

Katembo Kituta Ezechiel
CSE-SET, Sharda University, Greater Noida,Uttar Pradesh, India
Dr. Ruchi Agarwal
JIMS Engineering Management Technical Campus, Greater Noida, Uttar Pradesh, India
Dr. Baijnath Kaushik
Shri Mata Vaishno Devi University, Jammu and Kashmir, India

Algorithm, Synchronization, Replication, Peer, Database.

  • Kaur, K., & Singh, H. (2016). Distributed database system on web server: A Review. International Journal of Computer Techniques, 3(6), 12-16.
  • Ozsu, M. T., & Valduriez, P. (2011). Principles of Distributed Database Systems (3rd ed.). New York, USA: © Springer Science+Business Media, LLC.
  • Microsoft. (2017). SQL Server Replication. Retrieved May 2017, from Microsoft Documentation: https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication
  • Truica, C., & Boicea, A. (2013). "Asynchronous Replication in Microsoft SQL Server, PostgreSQL and MySQL". International conference on cyber science and engineering.
  • Malhotra N., Chaudhary A., (2014), Implementation of Database Synchronization Technique between Client and Server, International Journal of Engineering and Computer Science, 3(7): 7070-7073.
  • Souri, A., Pashazadeh S. & Navin, A., H. (2014). "Consistency of data replication protocols in database systems: A review", International Journal on Information Theory (IJIT),3(4), 19-32.
  • Tomar, P., & Megha. (2014). "An Overview of Distributed Databases". International Journal of Information and Computation Technology, 4(2), 207-214.
  • Chaturvedi, N., & Prof. Jain, D., C., (2012), Analysis of Replication and Replication Algorithms in Distributed System, International Journal of Advanced Research in Computer Science and Software Engineerin, 2(5), 2277 128X.
  • Gudakesa, R., Sukarsa, I., & Sasmita, I., M., A., (2014). Two-ways database synchronization in homogeneous dbms using audit log approach, Journal of Theoretical and Applied Information Technology, 65(3), 1992-8645.
  • Agrawal, D., El Abbadi, A., & Salem,K., (2015). A Taxonomy of Partitioned Replicated Cloud-based Database Systems, Bulletin of the IEEE Computer Society Technical Committee on Data Engineering, 38(1), 4-9.
  • Krishna, S., V., Gokul, K.& Kumar, S., (2012). Data Synchronization Using Cloud Storage, International Journal of Advanced Research in Computer Science and Software Engineering, 2(6), 2277 128X.
  • Kelemu, Y., & Prof. Patil, S., (2016). Hybridized Fragmentation of Distributed Databases using Clustering, International Journal of Engineering Trends and Technology (IJETT), 37(1), 2231-5381.
  • Salunke, D., T., & Potdar, G., P., (2014). A Survey Paper on Database Partitioning, International Journal of Advanced Research in Computer Science & Technology (IJARCST), 2(3), 2347 – 8446.
  • Hiremath, D., S., & Dr. Kishor, S., B., (2016). Distributed Database Problem areas and Approaches, Journal of Computer Engineering : National Conference on Recent Trends in Computer Science and Information Technology, 2278-8727.
  • Akshay, M., G., &Yogesh, R., G., (2016). Concurrency Control and Security Issue in Distributed Database System, International Journal of Engineering Development and Research, 4(2), 2321-9939.
  • Imam, A., A., Basri, S., Ahmad, R., (2015). Data synchronization between mobile devices and server-side databases: a systematic literature review, Journal of Theoretical and Applied Information Technology, 81(2), 1992-8645.
  • Shabani, I., Çiço B.,& Dika, A., (2012), Solving Problems in Software Applications through Data Synchronization in Case of Absence of the Network, International Journal of Computer Science Issues, 9(1): 1694-0814.
  • Fadoua, H., & Amel, G., T., (2015), Near Real-time Synchronization Approach for Heterogeneous Distributed Databases, The Seventh International Conference on Advances in Databases, Knowledge, and Data Applications, 978-1-61208-408-4.
  • Ruchi Agarwal, Sunny Singh, Satvik Vats, 'Review of Parallel Apriori Algorithm on Map Reduce Framework for Performance Enhancement’, organized by Computer society of India(CSI) Delhi and NCR chapter at Bharti vidyapeeth educational complex, New Delhi during 2nd -5thDecember, 2015. Published in Springer Nature Singapore, Advances in Intelligent and Soft Computing (AISC) series, Scopus Indexed pp 403-411.
  • Ruchi Agarwal, Jayanthi Ranjan, 'An empirical investigation on association rule mining in Indian Retail Industry’, International Journal of Intercultural Information Management, Inderscience Publishers, Vol. 3, No. 3, pp.226–241, November 2013.
  • Jayanthi Ranjan, Ruchi Agarwal, 'Advantages of Decision Trees Using Data Mining In Indian Retail Industry’, Journal of Knowledge Management Practice, Vol. 11, Special Issue 1, January 2010.
  • Jayanthi Ranjan, Ruchi Agarwal, 'Application of segmentation in customer relationship management: a Data Mining perspective’, International Journal of Electronic Customer Relationship Management, Inderscience Publishers, Scopus Indexed, Vol. 3, No 4, pp.402-414, 2009.
  • Kaushik B. et al., (2015), 'Performance evaluation of approximated artificial neural network (AANN) algorithm for reliability improvement’, Journal of Applied Soft Computing, Elsevier, Vol. 26, pp.303-314.
  • Kaushik B. et al., (2013), 'Achieving Maximum Reliability in Fault Tolerant Network Design for Variable Networks’ Journal of Applied Soft Computing, Elsevier, pp. 3211-3223.
  • Kaushik B. et al., (2012), 'Improved Approach for Maximizing Reliability in Fault Tolerant Networks’, Journal of Advanced Computational Intelligence and Intelligent Informatics, Fuji Press, Japan, Vol. 17, 1, pp. 27-41.
  • Publication Details

    Published in : Volume 2 | Issue 7 | September 2017
    Date of Publication : 2017-09-30
    License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
    Page(s) : 347-354
    Manuscript Number : CSEIT174443
    Publisher : Technoscience Academy

    ISSN : 2456-3307

    Cite This Article :

    Katembo Kituta Ezechiel, Dr. Ruchi Agarwal, Dr. Baijnath Kaushik, "Synchronous and Asynchronous Replication", International Journal of Scientific Research in Computer Science, Engineering and Information Technology (IJSRCSEIT), ISSN : 2456-3307, Volume 2, Issue 7, pp.347-354, September-2017.
    Journal URL : http://ijsrcseit.com/CSEIT174443

    Article Preview

    Follow Us

    Contact Us