ITTIA's DB SQL HA (high availability) uses replication and online backup to connect databases across embedded Android systems, ensuring that data is always available. ITTIA DB SQL offers support for true in-memory data management. When an Android database is created in memory, ITTIA DB SQL uses algorithms that are specialized for memory tables, such as T-tree indexes. In this way, the database is able to take advantage of optimizations such as direct pointers to significantly improve performance. Transactions are used to protect incomplete changes from being accessed by other connections. Unlike Android's built-in database technology, ITTIA DB SQL can share data in-memory with concurrent connections.
Support for high availability in ITTIA DB SQL maximizes the protection and availability of data for Android developers. As a result, Android embedded developers benefit from features such as distributed transactions, table snapshots, synchronous commit, replication on commit, single-master replication, multiple master replication and online backup. ITTIA DB SQL offers High Availability solutions for Android developers so that mission-critical data is reliably accessible.
ITTIA DB SQL replication for Android devices is used to share information between redundant devices to improve reliability, fault-tolerance, or accessibility. The replication facilities in ITTIA DB SQL make it easy to keep devices up-to-date with each other, even when connectivity is intermittent. When replication is enabled, changes to the Android database – row insert, update, or delete – are stored in the log file as replication events. Each database file has a list of peer databases with which it can exchange replication events.