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

fYear

2011

fDate

3-5 Aug. 2011

Firstpage

487

Lastpage

489

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;

fLanguage

English

Publisher

ieee

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

Type

conf

DOI

10.1109/IRI.2011.6009598

Filename

6009598