Design

Ease data analysis with new SQL planner

28th November 2013
Staff Reporter
0

A new SQL planner aiming to ease data analysis and management for developers of intelligent device applications has been announced today by ITTIA. Provided in ITTIA's database engine, the SQL planner calculates critical data statistics efficiently with cost-based optimization. This allows applications to utilize complex queries and make precise decisions.

Providing support for a broad range of SQL queries to express complicated joins, grouping, and query expressions, ITTIA is driving the embedded data management arena. Advantages of embedding an advanced SQL planner in an application include greater concurrency through row-level locking, reduced memory overhead, and high performance.

An important tool in which to gain intelligence in M2M frameworks that produce Internet-of-Things ecosystems, ITTIA's advanced SQL planner allows applications to use more sophisticated queries and make accurate decisions due to utilizing indexes effectively. 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.

Product Spotlight

Upcoming Events

View all events
Newsletter
Latest global electronics news
© Copyright 2024 Electronic Specifier