Database software includes snapshot transaction isolation

The recent explosion of readily-available data, made possible by the IoT paradigm and related technologies, has led to an increasingly connected world in which data must be rapidly stored and delivered over distributed networks. The advanced algorithms in ITTIA DB SQL 7 beta provide application developers with the fundamental tools necessary to access data quickly, reduce memory overhead and efficiently share data between concurrent threads and applications.

Reducing development time and cost, managing data with constrained resources and delivering a product to market on-time are all important concerns for manufactures of embedded systems. Many of these manufacturers recognise the full impact that a high-performance embedded database can have on the long-term success of a product as data accumulates over many years of deployment. The IDC predicts that the total number of 'Connectable Smart Things' will exceed 200bn by the year 2020.

The software introduces a file storage model to improve performance and reduce software overhead in embedded applications. Records stored on flash media can be accessed through high-level SQL queries and low-level table cursors, which read directly from the file system page cache. By sharing memory resources with the operating system, overall memory requirements are reduced and latency is minimised.

Snapshot transaction isolation, another new feature, provides readers with full access to the database in applications with a single writer, to prevent blocking and deadlocks. Applications with many concurrent writers can instead benefit from pessimistic locking, which is resilient against update conflicts. This flexibility provides a wide variety of multi-threaded applications with the best performance under real-world workloads. For IoT applications, shared access to locally stored data is essential to seamless communication between devices.

ITTIA DB SQL is a cross-platform software library that is designed to run seamlessly across various embedded and mobile operating systems, such as Linux, Windows, Android, μC/OS-II, μC/OS-III, QNX, Nucleus, and many others. Supported hardware platforms include x86, x64, ARM and custom development boards. Whether an application is storing a few kilobytes of configuration data or querying millions of records with SQL, ITTIA DB SQL 7 beta provides the best performance possible.