Mediation of Lazy Update Propagation in a Replicated Database over a Decentralized P2P Architecture

α
Katembo Kituta Ezechiel
Katembo Kituta Ezechiel
σ
Katembo Kituta Ezéchiel
Katembo Kituta Ezéchiel
ρ
Shri Kant
Shri Kant
Ѡ
Ruchi Agarwal
Ruchi Agarwal
α to σ Sharda University

Send Message

To: Author

Mediation of Lazy Update Propagation in a Replicated Database over a Decentralized P2P Architecture

Article Fingerprint

ReserarchID

CSTSDEWSLFE

Mediation of Lazy Update Propagation in a Replicated Database over a Decentralized P2P Architecture Banner

AI TAKEAWAY

Connecting with the Eternal Ground
  • English
  • Afrikaans
  • Albanian
  • Amharic
  • Arabic
  • Armenian
  • Azerbaijani
  • Basque
  • Belarusian
  • Bengali
  • Bosnian
  • Bulgarian
  • Catalan
  • Cebuano
  • Chichewa
  • Chinese (Simplified)
  • Chinese (Traditional)
  • Corsican
  • Croatian
  • Czech
  • Danish
  • Dutch
  • Esperanto
  • Estonian
  • Filipino
  • Finnish
  • French
  • Frisian
  • Galician
  • Georgian
  • German
  • Greek
  • Gujarati
  • Haitian Creole
  • Hausa
  • Hawaiian
  • Hebrew
  • Hindi
  • Hmong
  • Hungarian
  • Icelandic
  • Igbo
  • Indonesian
  • Irish
  • Italian
  • Japanese
  • Javanese
  • Kannada
  • Kazakh
  • Khmer
  • Korean
  • Kurdish (Kurmanji)
  • Kyrgyz
  • Lao
  • Latin
  • Latvian
  • Lithuanian
  • Luxembourgish
  • Macedonian
  • Malagasy
  • Malay
  • Malayalam
  • Maltese
  • Maori
  • Marathi
  • Mongolian
  • Myanmar (Burmese)
  • Nepali
  • Norwegian
  • Pashto
  • Persian
  • Polish
  • Portuguese
  • Punjabi
  • Romanian
  • Russian
  • Samoan
  • Scots Gaelic
  • Serbian
  • Sesotho
  • Shona
  • Sindhi
  • Sinhala
  • Slovak
  • Slovenian
  • Somali
  • Spanish
  • Sundanese
  • Swahili
  • Swedish
  • Tajik
  • Tamil
  • Telugu
  • Thai
  • Turkish
  • Ukrainian
  • Urdu
  • Uzbek
  • Vietnamese
  • Welsh
  • Xhosa
  • Yiddish
  • Yoruba
  • Zulu

Abstract

While replicating data over a decentralized Peer-to-Peer (P2P) network, transactions broadcasting updates arising from different peers run simultaneously so that a destination peer replica can be updated concurrently, that always causes transaction and data conflicts. Moreover, during data migration, connectivity interruption and network overload corrupt running transactions so that destination peers can experience duplicated data or improper data or missing data, hence replicas remain inconsistent. Different methodological approaches have been combined to solve these problems: the audit log technique to capture the changes made to data; the algorithmic method to design and analyse algorithms and the statistical method to analyse the performance of new algorithms and to design prediction models of the execution time based on other parameters. A Graphical User Interface software as prototype, have been designed with C #, to implement these new algorithms to obtain a database synchronizer-mediator. A stream of experiments, showed that the new algorithms were effective. So, the hypothesis according to which “The execution time of replication and reconciliation transactions totally depends on independent factors.” has been confirmed.

References

28 Cites in Article
  1. K Kituta,R Agarwal,B Kaushik (2017). Synchronous and Asynchronous Replication.
  2. M Özsu,Patrick Valduriez (2011). Distributed Database Design.
  3. N Magdalena,I (2011). The Replication Technology in E-learning Systems.
  4. M Wiesmann,F Pedone,A Schiper,B Kemme,G Alonso (2002). Understanding replication in databases and distributed systems.
  5. R Gudakesa,M Sukarsa,G Sasmita (2014). T woways database synchronization in homogeneous DBMS using audit log approach.
  6. S Pandey,U Shanker (2017). IDRC: A Distributed Real-T ime Commit Protocol.
  7. T Kudo (2014). An implementation of concurrency control between batch update and online entries.
  8. O Diallo,Joel Rodrigues,J Sene,M Lloret,J (2015). Distributed Database Management T echniques for Wireless Sensor Networks.
  9. A Silberschatz,H Korth,S Sudarshan (1997). Database system concepts.
  10. Quang Vu,Mihai Lupu,Beng Ooi (2010). Peer-to-Peer Computing.
  11. I Filip,C Vasar,R Robu (2009). Considerations about an Oracle database multi-master replication.
  12. Yaser Mansouri,Rajkumar Buyya (2018). Dynamic replication and migration of data objects with hot-spot and cold-spot statuses across storage data centers.
  13. M Sebastian (2013). Configuring Snapshot Replication Using T-SQL.
  14. D Kirtikumar (2011). Oracle Streams.
  15. A George,C Balakrishnan (2012). An optimized strategy for replication in peer-to-peer distributed databases.
  16. T Zhang (2016). A Novel Replication Model with Enhanced Data Availability in P2P Platforms.
  17. Z Ing,W Yu (2013). Database Replication T echnology having high Consistency Requirements.
  18. T Cormen,H (2012). Introduction to Algorithms.
  19. C Kothari,R Garg,G (2014). Introduction.
  20. K Shahin,G Pedram,D Khuzaima (2011). Dynamic Data Allocation with Replication in Distributed Systems.
  21. H Jonathan (2018). MySQL_Diff: Database Schema Difference Reconciliation.
  22. D B Convert (2018). Executing Your Web Site Strategy.
  23. K Kituta,S Kant,R Agarwal (2018). Analysis of database replication protocols.
  24. Evjola Spaho,Admir Barolli,Fatos Xhafa,Leonard Barolli (2015). P2P Data Replication: Techniques and Applications.
  25. X Fatos (2012). Data Replication in Collaborative Systems.
  26. K Kituta,S Kant,R Agarwal (2019). A systematic review on distributed databases systems and their techniques.
  27. Alireza Souri,Saeid Pashazadeh,Ahmad Habibizad Navin (2014). Consistency of Data Replication Protocols in Database Systems: A Review.
  28. M Santana,Enrique,J Francesc,D (2015). Replication of Messages.

Funding

No external funding was declared for this work.

Conflict of Interest

The authors declare no conflict of interest.

Ethical Approval

No ethics committee approval was required for this article type.

Data Availability

Not applicable for this article.

How to Cite This Article

Katembo Kituta Ezechiel. 2019. \u201cMediation of Lazy Update Propagation in a Replicated Database over a Decentralized P2P Architecture\u201d. Global Journal of Computer Science and Technology - C: Software & Data Engineering GJCST-C Volume 19 (GJCST Volume 19 Issue C3): .

Download Citation

Journal Specifications

Crossref Journal DOI 10.17406/gjcst

Print ISSN 0975-4350

e-ISSN 0975-4172

Keywords
Classification
GJCST-C Classification: C.2.4
Version of record

v1.2

Issue date

December 9, 2019

Language
en
Experiance in AR

Explore published articles in an immersive Augmented Reality environment. Our platform converts research papers into interactive 3D books, allowing readers to view and interact with content using AR and VR compatible devices.

Read in 3D

Your published article is automatically converted into a realistic 3D book. Flip through pages and read research papers in a more engaging and interactive format.

Article Matrices
Total Views: 4849
Total Downloads: 1246
2026 Trends
Related Research

Published Article

While replicating data over a decentralized Peer-to-Peer (P2P) network, transactions broadcasting updates arising from different peers run simultaneously so that a destination peer replica can be updated concurrently, that always causes transaction and data conflicts. Moreover, during data migration, connectivity interruption and network overload corrupt running transactions so that destination peers can experience duplicated data or improper data or missing data, hence replicas remain inconsistent. Different methodological approaches have been combined to solve these problems: the audit log technique to capture the changes made to data; the algorithmic method to design and analyse algorithms and the statistical method to analyse the performance of new algorithms and to design prediction models of the execution time based on other parameters. A Graphical User Interface software as prototype, have been designed with C #, to implement these new algorithms to obtain a database synchronizer-mediator. A stream of experiments, showed that the new algorithms were effective. So, the hypothesis according to which “The execution time of replication and reconciliation transactions totally depends on independent factors.” has been confirmed.

Our website is actively being updated, and changes may occur frequently. Please clear your browser cache if needed. For feedback or error reporting, please email [email protected]

Request Access

Please fill out the form below to request access to this research paper. Your request will be reviewed by the editorial or author team.
X

Quote and Order Details

Contact Person

Invoice Address

Notes or Comments

This is the heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

High-quality academic research articles on global topics and journals.

Mediation of Lazy Update Propagation in a Replicated Database over a Decentralized P2P Architecture

Katembo Kituta Ezéchiel
Katembo Kituta Ezéchiel Sharda University
Shri Kant
Shri Kant
Ruchi Agarwal
Ruchi Agarwal

Research Journals