Version 3.2 Release of ITTIA DB SQL Relational Database

ITTIA has unveiled the version 3.2 of its relational database, ITTIA DB SQL, for application developers of embedded systems and devices. This release introduces transaction savepoints and two new ways to share data on a device, with support for shared memory communications and a low-overhead storage-level locking model.

ITTIA DB SQL already features multi-user capabilities that enable applications on an embedded device to share data safely between different threads and processes. This new release uses shared memory areas to improve the performance of on-device communications. Shared memory is fully compatible with the existing TCP/IP transport, allowing data to be shared between both local and remote connections with the best possible performance.

In addition, this new release supports storage-level locking, an efficient way to protect the database when concurrency requirements are low. With this locking model, any number of threads and processes can read from a database, but exclusive access is obtained automatically before writing any changes. Storage-level locking provides the same ACID guarantees as row-level locking, the default locking model for ITTIA DB SQL, but with very little overhead. For applications where concurrent writes rare, storage-level locking can greatly improve performance without compromising safety.

Transactions are a fundamental database feature that give application developers full control over how data will be recovered when a critical error occurs. In version 3.2, ITTIA DB SQL extends its existing transaction support with the introduction of savepoints. Savepoints can be used to perform rollback within a transaction, so that minor errors can be handled quickly without canceling an entire transaction. Savepoints can also simplify application code because they are easily nested in a function call heirarchy.

write your comments about the article :: 2010 Computing News :: home page