Synchronizing a database for off-line mobile clients

by CyberChic
In this paper published by Samuel A. Ajila and Ahmed Al-Asaad from Carleton University in Canada, address concerns with synchronizing a SQL server database for mobile users while off-line. SQL Server has three features to help. They are Remote Data access, Merge replication, and MS Sync Services. Some of the problems that the business experienced are that multiple subscribers (clients) may potentially update the same data at various times and propagate those changes to the publisher (server) and to other subscribers and that there is a need to detect and resolve these conflicts. They conclude that using the merge replication function is best suited for this company.

It is interesting to know that MS SQL Server can be used for more than just storing data and that there are several functions within SQL Server to help with this problem each having its benefits.

I am amazed how much functionality CA Erwin and SQL Server contain. I am also daunted by the fact that there is so much to learn and use in these softwares.

Ajila, S.A. & Al-Asaad, A. (Aug 2011). “Mobile databases – Synchronization & conflict resolution strategies using SQL server.” Information Reuse and Integration (IRI), 2011 IEEE International Conference on Print. vol., no., pp.487-489. doi: 10.1109/IRI.2011.6009598

4 thoughts on “Synchronizing a database for off-line mobile clients

  • May 17, 2012 at 4:25 pm

    I agree there is a lot to learn about the programs you mentioned, I personally haven’t even scratched the surface in terms of using the programs to their full capabilities. I also found the merge replication function interesting and it certainly can benefit businesses.

  • May 18, 2012 at 7:42 pm

    I posted something similar a couple of weeks ago. I agree that SQL is very powerful when it comes to the support of different devices. When server vendors implement a database they offer synchronization methods but they are dependents of the server side. SQL is the backbone of the database and it is used to synchronize databases regardless of the devices and platforms that they are being used.

  • May 19, 2012 at 12:34 am

    The SQL statement we are learning in class feels like it is something that is really basic. It feels like we are just learning how to output “hello world” in a programming class. I am sure it has a lot of powerful function in this program, or else it wouldn’t be industry standard for databases. I hope to dig deeper into databases and SQLs.

  • May 19, 2012 at 2:32 pm

    I would have assume that developers would have figured out a way to solve this problem before releasing the software. SQL have always been a good tool to use when developing a database. SQL just seems reliable and everyone know how the write sql statement that sql would always be the first tool used.

Comments are closed.