A new SQL planner from ITTIA eases data analysis and management for developers of intelligent device applications. ITTIA provides an SQL planner in its database engine to calculate critical data statistics efficiently with cost-based optimization. This allows applications to utilize complex queries and make precise decisions.
ITTIA supports 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.
The advanced 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 important 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.
By embedding the SQL planner in embedded systems and intelligent mobile devices, manufacturers reduce overall development time and time to market, while lowering costs. The SQL planner provides a smart query optimizer that determines the most efficient way to execute a given query by considering possible query plans, accelerating SQL query execution and reducing the time to access data.