Heterogeneous database replication with SyncML

Availability and performance are primary considerations when you’re developing distributed applications. But using data stores to address these concerns can result in problems with data synchronization between heterogeneous data stores. In this article, Jayanthi Suryanarayana and Neil Tunnicliffe offer a solution using JDBC and the SyncML standard to achieve generic database data replication.

When you are designing distributed applications, you must consider availability and performance. A common solution is to include a data store on the client system. Typically, the client will require a lightweight data store as a result of limited resources. This approach poses a challenge for data synchronization between heterogeneous data stores. One resolution to this problem is a Java-based approach using JDBC and SyncML standards for heterogeneous database replication, but first a little background.