How Smart Embedded Just Got Smarter

Smart and embedded device software specialist ITTIA has released new DB SQL capabilities specifically designed to help embedded developers achieve large volume data management and analytics.

ITTIA DB SQL is a cross-platform embedded database for Android, Linux, Windows, QNX, ThreadX, VxWorks, Nucleus, and generic ARM targets with no operating system.

As Dr. Dobb’s readers will know, a so-called “smart device” is one that can work (to some degree) interactively and autonomously via communication and connectivity protocols such as Bluetooth, NFC, WiFi, 3G, etc.

As a company, ITTIA states that there is a growing scale of data being produced from embedded systems. The firm (we looked it up, we don’t know what ITTIA stands for either) says that its ITTIA DB SQL addresses critical statistical analysis for precise decision making — and, most interestingly, this has advantages such as high performance queries, reduced memory overhead, and more effective use of row-level locking.

The ITTIA DB SQL architecture is presented in a choice of on-disk, in-memory, or hybrid storage options — data is organized and continuously indexed for multiple levels of analysis.

Applications can filter data in different ways; for example, to request data captured over a certain time range and also to search for measurements that exceed a safe tolerance level.

“The development and implementation of new embedded solutions produces a demand for large volume data management on devices that would have been stand-alone in previous hardware generations. Now, as these devices become part of a networked and connected ecosystem, the complexity of data management and system connectivity makes it difficult to find and query data that originates from another system. Data distribution features in ITTIA DB SQL help applications to proactively collect data where it is needed most, whether that is on another embedded system or in a back-end RDBMS product,” said the company.