The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

data synchronization

Are there any books you know that discuss how to synchronize data between offline location (desktop) and online location (server)? I need to quickly learn what to watch out for, security practices and some how-to techniques.

Thanks
coder
Monday, August 13, 2007
 
 
Two books that come to mind are:
http://www.amazon.com/SyncML-Synchronizing-Managing-Your-Mobile/dp/0130093696/
http://www.amazon.com/Data-Replication-Techniques-Distributed-Information/dp/0471157546/

I've seen both on the "remainder" shelf, so you should be able to snag some copies cheap.

SyncML was originally aimed at hand-helds, which can be disconnected most of the time from the DB, and lack a lot of memory, storage and processing power.
http://en.wikipedia.org/wiki/SyncML 

The Data Replication Techniques book talks a bit about some algorithms, but tends to talk a lot more about other things you need to look out for, such as security. It was written when replication was a very expensive add-on for databases and not included, as it is now with "fancy new stuff" like SQL Server 2000, or Oracle 9. Note for the humo(u)r/sarcasm impaired: The book is 10 years old, and those products weren't even in beta back then.
Peter Send private email
Monday, August 13, 2007
 
 
I can't answer directly, but here are a couple of things that might turn up some info:

First, CRM systems have been doing sycnh a long time - if you could turn up some implementation guidelines, you'd probably learn a few things about security, conflict resolution, and best practices.  I used to do implementations with SalesLogix and Pivotal, and synch setup was one of the touchiest parts of the implementation.

Second, if you're contemplating doing this in .Net, MS is releasing Synch Services for ADO.Net with .Net 3.5 / VS 2008 -- read more here:  http://blogs.msdn.com/stevelasker/archive/2007/07/31/sql-server-compact-3-5-b2-sync-services-for-ado-net-documentation-released.aspx
D. Lambert Send private email
Monday, August 13, 2007
 
 
I'll check those out. Thanks.
coder
Tuesday, August 14, 2007
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz