ITTIA DB SQL 3.2 offers transaction savepoints and improved data sharing - Embedded.com

ITTIA DB SQL 3.2 offers transaction savepoints and improved data sharing

Bellevue, Wash. – ITTIA has unveiled version 3.2 release 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 features robust 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.

Version 3.2 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 are rare, storage-level locking can greatly improve performance without compromising safety.

Transaction support is a fundamental database feature that gives application developers full control over how data will be recovered after a critical error. In version 3.2, ITTIA DB SQL extends its existing transactions 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 hierarchy of function calls.

A free copy of ITTIA DB-SQL for evaluation is available at www.ittia.com/products/evaluation.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.