ITTIA has announced the availability of its flagship database for embedded systems and intelligent devices, ITTIA DB SQL, on Android. With an enhanced alternative to Android's built-in data storage now available, Android applications can benefit from high-throughput write operations, large data set scalability, in-memory table performance, and synchronize with other devices and back-end databases.
Android application developers will find the ITTIA DB SQL Java API familiar, and can easily migrate existing application code. The ITTIA DB SQL library is automatically added to the application package, and all configuration is handled by the application code. Applications can immediately benefit from the improved scalability, for example by quickly filling a large SD card with data and then incrementally reading and modifying its contents.
ITTIA DB SQL supports concurrent shared access, both for reading and writing. Background threads can safely access a database, and row-level locking ensures that accessing the same database from the user interface does not cause the Application Not Responding (ANR) dialog to appear. The database can also be shared with other applications on or off the device through client/server communications.
When Android devices make up all or part of a larger system, ITTIA DB SQL is the ideal high availability technology. Redundant copies of the data on each device are maintained automatically according to replication rules stored in the database files, so that data is always available regardless of device failures, intermittent network connections, and other unpredictable errors. Since ITTIA DB SQL is a cross-platform database, replication is not limited to Android devices and can be adapted to a wide range of scenarios.
In particular, Android devices can use ITTIA DB to synchronize with remote back-end enterprise databases, such as Oracle, MySQL, MS SQL Server, and more. When a device communicates with the ITTIA DB Synchronization Server on a back-end or desktop system, changes to selected tables are automatically exchanged, with many options available to detect and resolve conflicts. Records can even be limited to certain devices to protect access and reduce overhead.
While the database built into Android is sufficient for many applications, developers can easily switch to ITTIA DB when data management gets more serious and the limitations need to be addressed.