Title :
Mobile databases - Synchronization & conflict resolution strategies using SQL server
Author :
Ajila, Samuel A. ; Al-Asaad, Ahmed
Author_Institution :
Dept. of Syst. & Comput. Eng., Carleton Univ., Ottawa, ON, Canada
Abstract :
This paper presents the synchronization and conflict resolution for Transport Canada´s RSIG (Rail Safety Integrated Gateway) system. In this work, we have designed and developed a comprehensive solution to address the challenges of a Disconnected Mode problem in the RSIG system. The proposed solution is based on Microsoft SQL Server database technology. SQL Server database provides three types of replications-transactional, merge, and snapshot. Our solution is based on merge replication. Merge replication is used for mobile application or distributed server applications with possible data conflicts. This solution could further be applied to the disconnected mode based architecture used by retail wholesalers.
Keywords :
SQL; merging; mobile computing; railway engineering; railway safety; Microsoft SQL Server database technology; RSIG system; conflict resolution strategies; data synchronization; disconnected mode based architecture; merge replication; mobile databases; rail safety integrated gateway; snapshot replication; transactional replication; Databases; Mobile communication; Rails; Safety; Servers; Subscriptions; Synchronization; Data synchronization; Replication; SQL; conflict resolution;
Conference_Titel :
Information Reuse and Integration (IRI), 2011 IEEE International Conference on
Conference_Location :
Las Vegas, NV
Print_ISBN :
978-1-4577-0964-7
Electronic_ISBN :
978-1-4577-0965-4
DOI :
10.1109/IRI.2011.6009598
