Synchronize Android embedded data with Microsoft SQL Server

by K C Krishnadas, TechOnline India - January 11, 2012

Android application developers of intelligent devices, embedded systems and mobile devices can now share and communicate data stored in ITTIA DB SQL with a back-end Microsoft® SQL Server with just a few mouse clicks.

Android application developers of intelligent devices, embedded systems and mobile devices can now share and communicate data stored in ITTIA DB SQL with a back-end Microsoft SQL Server with just a few mouse clicks.

This  is made possible by ITTIA DB Sync, and allows developers not only to distribute mobile and embedded data between Android devices and Microsoft SQL Server, but also to benefit from the replication environment necessary for improvement of data availability, reliability, modularity, mobility and interoperability. Ittia is a provider of software and services for data management.

The Synchronization Advantage

ITTIA DB Synch provides a bridge to back-end RDBMS servers for applications running ITTIA DB SQL on mobile devices and other embedded systems. When synchronization is enabled, shadow tables are added to the back-end database so that changes can be shared incrementally with the devices.

The advantage of this synchronization technology lies in the fact that in most distributed applications, only part of the data in a back-end RDBMS should be shared with each device. For this reason, ITTIA DB Sync can limit which rows are sent to each device using a device ID, group ID, or custom query. This flexibility allows applications to reduce overhead, protect access to data, and prevent conflicts. Conflicts are automatically detected whenever a shared row is modified both in the back-end and on the device, and can be resolved either through simple rules or custom stored procedures.

The Replication Advantage

ITTIA DB SQL's built-in replication logging allows devices to record transaction history and exchange data bi-directionally between devices and the back-end. Every distributed application has different requirements for the distribution of data. ITTIA DB's synchronous replication feature ensures that the distributed database as a whole adheres to the ACID properties while the asynchronous replication relaxes the ACID properties, allowing the data to be inconsistent between sites at certain times.

ITTIA DB SQL supports two-phase commit, which allows applications to perform distributed transactions over two or more ITTIA DB SQL database sites. In addition, ITTIA DB's table snapshot protocol enables embedded and device developers to optimize network traffic by identifying and sending only modified rows. With this approach, even large tables can be updated without sending the full contents of the table over the network.

When replication is done between two ITTIA DB instances, conflicts are detected using either row comparison or STAMP columns. ITTIA DB supports policy-based conflict resolution and provides the replication environment needed to improve system availability using distributed commits or synchronous replication across multiple sites.

A free copy of ITTIA DB SQL is available for evaluation at http://www.ittia.com/products/evaluation

About Author

Comments

blog comments powered by Disqus