November 26, 2013 — ITTIA announced SQL planner for embedded devices.The SQL planner provides a method of embedded device data analysis, to calculate critical data statistics efficiently with cost-based optimization. This allows applications to utilize complex queries and make precise decisions. It provides support for a broad range of SQL queries to express complicated joins, grouping, and query expressions. The advantages of embedding an advanced SQL planner in an application include high performance, reduced memory overhead, and greater concurrency through row-level locking.
SQL planner offers cost-based optimization that utilizes indexes most effectively. This allows applications to use more sophisticated queries and make accurate decisions. The SQL planner is an embedded data management tool for devices to gain intelligence in machine-to-machine (M2M) frameworks that produce Internet-of-Things (IoT) ecosystems. These devices gain the ability to analyze data and determine when objects must be replaced, repaired, or recalled. In addition, by embedding the SQL planner in embedded systems and intelligent mobile devices, manufacturers reduce the overall development time and are able to enter their products into the market much sooner, while lowering costs.
Developers are able to accelerate SQL query execution and reduce the time to access data. The SQL planner provides a smart query optimizer that determines the most efficient way to execute a given query by considering possible query plans. ITTIA DB SQL is a cross-platform leading-edge embedded database for Android, Linux, Windows, QNX, ThreadX, VxWorks, Nucleus, and generic ARM targets without an operating system.
