ITTIA DB SQL database for embedded systems and intelligent devices is now available on Google Android. ITTIA DB SQL offers high-throughput write operations, large data set scalability, in-memory table performance, and synchronize with other devices and back-end databases. It is an enhanced alternative to Android’s built-in data storage. A free copy of ITTIA DB SQL for Android is available now for evaluation.
ITTIA DB SQL offers a Java API familiar. Android application developers 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. ITTIA DB SQL will improve scalability for applications. For example: 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.
ITTIA DB SQL is the ideal high availability technology. Redundant copies of the data on each Android 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. ITTIA DB SQL is a cross-platform database. As a result, replication is not limited to Android devices and can be adapted to a wide range of scenarios.
Android devices can use ITTIA DB to synchronize with remote back-end enterprise databases (such as Oracle, MySQL, MS SQL Server). 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.