Android and ITTIA DB SQL
ITTIA DB SQL is compatible with the interfaces and classes in the android.database package from Android API level 3 onward. ITTIA DB SQL value add for Android developers includes:
Replication: When a mission critical data becomes unavailable, then the entire system can be threatened. Support for high availability (HA) in ITTIA DB SQL maximizes the protection and availability of data. Backup, replication and recoverability are three characteristics of a highly available solutions. ITTIA DB SQL for Android supports database replication which is used to share information between redundant resources to improve reliability, fault-tolerance, or accessibility. The replication facilities in ITTIA DB SQL make it easy to keep Android devices up-to-date with each other, even when connectivity is intermittent.
Concurrency: Device applications usually perform many different tasks on data stored in the database. Some tasks perform best when run in parallel, allowing long-running tasks such as synchronization to happen without completely stopping normal operations. Tasks on Android devices can be performed by a single application with multiple threads or instances, multiple applications on a device, or even remote applications across a network.
ITTIA DB SQL also uses a lightweight data server to negotiate shared access. The server is self-contained, requiring little or no configuration so that it is straightforward to use on an Android device, and can even run in the background of an application process.
Row-Level Locking: ITTIA DB SQL for Android uses automatic row-level locking with isolation levels to protect shared access. Whereas Android's built-in database will lock the entire database whenever it is modified, ITTIA DB SQL allows multiple threads to concurrently access and modify different rows in the same database. Locks are automatically released at the end of each transaction.
In-Memory Storage: Android applications often store temporary data that must be accessed and modified with maximum performance. ITTIA DB SQL uses algorithms specifically tailored for high performance, such as T-tree index, when tables are created in memory storage. Like disk tables, memory tables are shared between threads and can participate in replication.
Security: Android devices that store sensitive information must use encryption and authentication to prevent malicious access. ITTIA DB SQL supports file storage encryption that protects data on internal and removable media from theft. When replication exchanges data with a back-end system, the connection can be protected by SSL/TLS encryption and SCRAM authentication. This prevents eavesdropping, the unauthorized interception of communication, and uses certificates to prevent session highjacking.
Recognized Technical Support: When you select ITTIA DB SQL for Android, you will benefit from a dependable, world-class support. Whether you are a small company or a Fortune 500 organization, your success with ITTIA DB SQL is our number-one priority. Continuous access to software patches, enhancements, upgrades, and experienced risk management advice are all part of the value offered by the ITTIA technical team.
Synchronization: In an system where independent Android devices share data with one or more back-end servers, information must be continuously broadcast, fragmented, and retrieved to keep all components synchronized. ITTIA Synch bridges the gap between Android devices and back-end relational database management system (RDBMS) technologies.
Oracle®: Whether an application developed on Android is meant for use in tablets, embedded systems or mobile devices, many seek data synchronization capabilities with Oracle back-end enterprise databases. In particular, many companies are looking for ways to leverage tablet computers for greater workforce mobility while maintaining a secure, reliable connection to the corporate data center. Developers can avoid this limitation by synchronizing the back-end Oracle® database. ITTIA DB SQL for Android offers this bidirectional synchronization ability to your application.
SQL Server®: ITTIA DB SQL empowers developers to share and communicate data stored in ITTIA DB SQL on the Android environment with a back-end Microsoft® SQL Server database. This allows applications to not only distribute data between devices based on Android and Microsoft® SQL Server®, but also benefit from the replication environment necessary for high availability.
Replication: When a mission critical data becomes unavailable, then the entire system can be threatened. Support for high availability (HA) in ITTIA DB SQL maximizes the protection and availability of data. Backup, replication and recoverability are three characteristics of a highly available solutions. ITTIA DB SQL for Android supports database replication which is used to share information between redundant resources to improve reliability, fault-tolerance, or accessibility. The replication facilities in ITTIA DB SQL make it easy to keep Android devices up-to-date with each other, even when connectivity is intermittent.
Demonstration: Storing, organizing, and sharing data on Android while also synchronizing with SQL Server can enable great data management freedom and add a competitive edge to your application. A device application can accumulate data on Android and periodically deliver data to SQL Server. Similarly, data modified in the SQL Server database is distribute to the Android device over the same connection.
In this demonstration, you will learn how ITTIA DB SQL on Android enables synchronizing data with a SQL Server database.