A Comprehensive Replication Strategy for Improving Availability and Maintaining Consistency in Large-Scale Mobile Distributed Database Systems

• Main Author: Ahmed Fadelelmoula, Ashraf Ahmed Fadelelmoula
• Format: Thesis
• Language: English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English; English
• Published: 2010
• Online Access: http://utpedia.utp.edu.my/id/eprint/2900/1/1._Status_of_thesis.pdf; http://utpedia.utp.edu.my/id/eprint/2900/2/2._Approval_Page.pdf; http://utpedia.utp.edu.my/id/eprint/2900/3/3._Title_Page.pdf; http://utpedia.utp.edu.my/id/eprint/2900/4/4._Declaration.pdf; http://utpedia.utp.edu.my/id/eprint/2900/5/5._Dedication.pdf; http://utpedia.utp.edu.my/id/eprint/2900/6/6._Acknowledgements.pdf; http://utpedia.utp.edu.my/id/eprint/2900/7/7._Abstract.pdf; http://utpedia.utp.edu.my/id/eprint/2900/8/8._Abstract_%28Bahasa_Melayu%29.pdf; http://utpedia.utp.edu.my/id/eprint/2900/9/9._Table_of_Contents.pdf; http://utpedia.utp.edu.my/id/eprint/2900/10/10._List_of_Tables.pdf; http://utpedia.utp.edu.my/id/eprint/2900/11/11._List_of_Figures.pdf; http://utpedia.utp.edu.my/id/eprint/2900/12/12._Abbreviations.pdf; http://utpedia.utp.edu.my/id/eprint/2900/13/13._CHAPTER_ONE.pdf; http://utpedia.utp.edu.my/id/eprint/2900/14/14._CHAPTER_TWO.pdf; http://utpedia.utp.edu.my/id/eprint/2900/15/15._CHAPTER_THREE.pdf; http://utpedia.utp.edu.my/id/eprint/2900/16/16._CHAPTER_FOUR.pdf; http://utpedia.utp.edu.my/id/eprint/2900/17/17._CHAPTER_FIVE.pdf; http://utpedia.utp.edu.my/id/eprint/2900/18/18._CHAPTER_SIX.pdf; http://utpedia.utp.edu.my/id/eprint/2900/19/19._CHAPTER_SEVEN.pdf; http://utpedia.utp.edu.my/id/eprint/2900/20/20._PUBLICATIONS.pdf; http://utpedia.utp.edu.my/id/eprint/2900/21/21._REFERENCES.pdf; http://utpedia.utp.edu.my/id/eprint/2900/22/22._Appendix_One.pdf; http://utpedia.utp.edu.my/id/eprint/2900/23/23._Appendix_Two.pdf; http://utpedia.utp.edu.my/id/eprint/2900/24/24._Appendix_Three.pdf; http://utpedia.utp.edu.my/id/eprint/2900/25/25._Appendix_Four.pdf; http://utpedia.utp.edu.my/id/eprint/2900/26/26._Appendix_Five.pdf; http://utpedia.utp.edu.my/id/eprint/2900/

Recent years have witnessed tremendous growth of database applications in mobile computing environments. An important challenge to database researchers in such environments is to provide a data replication solution that maintains the consistency and improves the availability of replicated data. This research addresses these problems for large scale distributed database systems that operate in mobile environments. The research called such systems as Large-Scale Mobile Distributed Database Systems (LMDDBSs). As a solution, the research provides a new comprehensive replication strategy that consists of four components in order to act in accord with the characteristics of LMDDBSs, and to better support the mobility and disconnections of mobile hosts. The components of the replication strategy are: replication architecture, updates propagation protocol, updates ordering mechanism, and replication method. The effectiveness of the proposed strategy with respect to updates propagation is verified through a comparative study with Roam replication system. The results revealed that the proposed strategy achieves better propagation delay and lesser total number of messages than Roam. Moreover, the proposed strategy achieves load balance in both propagation and ordering processes. Also, the proposed updates propagation protocol is compared with N-ary tree based propagation protocol. The results showed that the horizontal extension provided by the proposed protocol is more suitable than the vertical extension for LMDDBSs. The characteristic of updates ordering mechanism reveals that it is more suitable to meet the ordering requirements of LMDDBSs than the previous mechanisms that are based on version vectors. To analyze the stochastic behavior of the replication system, the research developed a Stochastic Petri Net (SPN) model. The analysis proved that the mobile database state in which availability and consistency are satisfied is a recurrent state with a probability that depends on the number of the synchronizations of the mobile host with the fixed network. Keywords: availability, consistency, optimistic replication, pessimistic replication, replication method, propagation protocol.