ITTIA updates DB SQL database software

  • June 25, 2015

June 25, 2015 - ITTIA released DB SQL version 7 beta, tailored to the performance requirements of today's intelligent applications for embedded systems and devices. Enhancements include snapshot transaction isolation, a high-performance file format, and numerous optimizations for embedded systems.

The recent explosion of readily-available data, made possible by the Internet of Things 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 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 recognize 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 200 Billion by the year 2020.

ITTIA DB SQL 7 beta introduces a new 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 minimized.

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 Internet of Things 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. 

Go to ITTIA website
Learn More