ITTIA announces DB Sync database software for Android apps | Automation.com

ITTIA announces DB Sync database software for Android apps

September 29, 2014 - ITTIA announces bidirectional synchronization for Android apps to bridge the gap of collecting big data on-the-go.

To synchronize data, an Android app must identify local changes, open a communication channel to a back-end service, and transfer the data. While a sync adapter can be used to schedule synchronization in the background, apps that store data in an SQLite database must track changes manually and define protocols for authentication and communication. For any non-trival data model, this represents a significant development effort. ITTIA DB SQL is a drop-in replacement for SQLite that automatically synchronizes local changes with a back-end database quickly and efficiently.

Likewise, developing a custom network service to synchronize with numerous Android devices is no simple task, especially when every device has a different subset of the available data. Instead, ITTIA DB SQL communicates with ITTIA DB Sync, a bidirectional data synchronization service for Windows and Linux. ITTIA DB Sync uses a back-end RDBMS, such as Microsoft SQL Server or Oracle Database, to store device data in existing tables and download updates specific to each device.

To enable synchronization, an Android app simply creates similar tables in its local database and designates which tables should send and/or receive changes. The ITTIA DB SQL sync adapter runs in the background at scheduled times or whenever the device is online. For authenticated connections, the sync adapter automatically displays a customized login activity that the app can tailor to match its own look and brand.

Benefits of ITTIA DB SQL for bidirectional synchronization on Android include:

  • Small Footprint Architecture: provides high-speed mobile synchronization capability;
  • Flexible Deployment: supports Android Froyo (2.2) and above, including KitKat (4.4);
  • Bidirectional Synchronization: automatically detects conflicts and provides multiple options for resolution;
  • Data Fragmentation: divides tables across multiple devices with robust filters;
  • Concurrent Shared Access: optimizes multi-threaded apps with row-level locking;
  • Low Development Cost: simplifies implementation and validation with a rich tool set for data management.

Interested developers can download an example Android app to try ITTIA DB Sync.

 

MORE RESOURCES

VIEW ALL

RELATED