Skip to content Skip to navigation

ITTIA DB SQL Delivers Secure Data Distribution for Android

August 30, 2012 — Bellevue, WA — With Android's worldwide smart device market dominance, and thanks to inexpensive high-capacity SD Cards and comprehensive software development kit, it is easier than ever for software developers to build a distributed network of data-driven applications. While Android includes SQLite, a built-in database, applications handling mission critical data require capabilities not available in SQLite.

Important features where support is weak or non-existent in SQLite include:

  • Security
  • Data replication
  • Data synchronization-Concurrent shared access
  • Flexible storage
  • Performance

Eventually, such problems make migrating to a different embedded database inevitable. ITTIA DB SQL is a pure relational database suitable for Android-based developers. After a straightforward process of migrating from SQLite, an Android application will have access to a broad range of features, including:

  • Shared database access
  • High-performance memory storage
  • Replication
  • Distributed transactions
  • Table snapshots
  • Synchronous commit
  • Replication on commit
  • Single-master replication on demand
  • Multiple-master replication on demand
  • Online backup

Devices with sensitive information must secure data both at rest and when shared with other systems. Database file encryption protects data from media theft by encrypting each page before it is saved to flash storage. ITTIA DB SQL supports AES-128 and AES-256 encryption. With ITTIA DB's lightweight server, Android databases can also be accessed remotely for replication, synchronization, and shared access. These communications can be authenticated with a database password and also encrypted with OpenSSL.

Transactions provide full ACID protection, guaranteeing atomicity, consistency, isolation, and durability, with lower overhead than SQLite. Also, row-level locking with isolation levels allows the database to automatically track all rows that are read or modified in a transaction. At the highest level of isolation, known as "serializable," rows are locked in such a way as to prevent all possible conflicts.

Algorithms used for in-memory storage are different from those for on-disk. Since memory tables can be shared between activities and threads, they are a useful alternative to the Java collection classes. Hybrid in-memory/on-disk databases containing a mixture of memory and disk tables can also be created. When tables are stored on disk, ITTIA DB SQL provides safe, scalable on-disk file storage, and uses row-level locking for higher concurrency.

In addition, data can be easily shared between threads in an Activity, Activities in an app process, applications on a device, and devices on a network. By performing synchronous replication on designated tables, changes in the table are automatically applied to other database sites. When a transaction is committed, changes are sent to other participates using a distributed commit over all participating peers. As a result, committing a transaction will only succeed if all replication peers accept the changes.

Resources:

A free copy of ITTIA DB SQL for evaluation:

http://www.ittia.com/products/embedded/evaluation

A video demonstrating ITTIA DB SQL database architecture:

https://www.youtube.com/watch?v=svsnXuMGxq0

About ITTIA

ITTIA offers database solutions for embedded and mobile platforms where limited memory, storage, and processing power makes software development challenging. ITTIA develops fast, high performance database products and tools with the goal of providing excellent data management software for embedded systems and devices. ITTIA DB SQL is designed to be suitable for application development and deployment at a significantly reduced cost. ITTIA customers include GlaxoSmithKline, VNU, Boeing, Moodys, Sandia National Laboratory, Puget Sound Energy and others. You can obtain more information about ITTIA at: www.ittia.com.