ITTIA DB SQL is now available for the Nucleus real-time operating system (RTOS). Nucleus provides the functions required for applications to be safe and efficient on single-core and multi-core systems. ITTIA DB SQL takes advantage of this to allow multiple application tasks to concurrently access a single database on separate processor cores.
ITTIA DB SQL can share and distribute data through the Nucleus networking components, giving applications built-in high availability and synchronization capability. When mission-critical data becomes inaccessible, the entire system can be threatened. Support for high availability in ITTIA DB SQL maximizes the protection and availability of data for Nucleus developers by leveraging 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 these High Availability solutions for Nucleus developers so that mission-critical data is reliably accessible.
To prevent race conditions, concurrent database transactions are protected by row-level locking. In this way, real-time tasks can safely share access to a database file, both reading and writing, with little interference. If a high priority task is blocked by a transaction in a less important task, it can force a roll back to prevent priority inversion.
ITTIA DB SQL offers several security measures to prevent tampering and protect confidential data from unauthorized access. Applications can encrypt the database file with an AES-128 or AES-256 key and require a database password for remote access and replication. Remote connections can also be secured with SSL/TLS.