Date: 11/01/2012

Database for Android app developers from ITTIA syncs with MS SQL server

Database for Android app developers from ITTIA allows app softeware developers to distribute mobile and embedded data between Android devices and Microsoft SQL Server by providing replication environment necessary for improvement of data availability, reliability, modularity, mobility and interoperability.

ITTIA DB Synch bridges back-end RDBMS servers for applications running ITTIA DB SQL to 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.

ITTIA says 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 features of this DB includes:
Synchronous replication feature of ITTIA DB 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