Advanced SQL Planner Offers Data Analysis Intelligence to Embedded Devices

Dec. 2, 2013
ITTIA, the leader in modern database software for embedded systems and smart devices, today announced the availability of a new SQL planner to significantly ease data analysis and management for developers of intelligent device applications.
ITTIA, the leader in modern database software for embedded systems and smart devices, today announced the availability of a new SQL planner to significantly ease data analysis and management for developers of intelligent device applications. ITTIA provides an SQL planner in its database engine, an exciting 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.
ITTIA is driving the embedded data management arena by providing 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.
ITTIA's 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.
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.
>>For more information on this product, click here

Sponsored Recommendations

Shorten project timelines with these hidden-gem Ignition efficiency tips for designing HMIs, provided by Inductive Automation Sales Engineer Reese Tyson.
Get ready for that “where has this been all my life?” moment—over 25 hidden Ignition features await in our webinar. Our experts show how to boost your productivity and streamline...
Advanced software solutions, like those built in the Ignition platform from Inductive Automation, can provide a crucial means to navigating electrical grid challenges.
Unlock seamless data flow across your manufacturing sites with MQTT and Ignition—turn siloed operations into a connected, data-driven enterprise. Discover how standardization,...