ITTIA DB-SQL, a lightweight database management system for embedded systems and mobile devices, version 2.5 has been released for general availability. New features in version 2.5 include a lightweight SQL engine, support for the VxWorks operating system, and language bindings for Java and C#. With this release, more mobile and embedded products will benefit from the robust data management facilities of ITTIA DB-SQL to improve stability and scalability without increasing the cost of hardware.
ITTIA DB now includes a lightweight SQL engine that developers will find familiar and easy to learn. SQL queries are executed dynamically at run-time, providing great flexibility to developers. ITTIA DB-SQL implements a rich selection of SQL features, including alter table statements, conditional expressions, sequence generators, table set operations (union, except, and intersect), and complex table joins. Any combination of inner, outer, and full outer joins is possible, and multiple syntaxes are supported, including the USING keyword that is utilized by certain enterprise databases. ITTIA DB truly brings the power of SQL to mobile devices and embedded systems.
Wind River VxWorks is a family of software development platforms, including a commercial-grade real-time operating system (RTOS), for small-footprint devices. In addition, with this release ITTIA adds the reliability and scalability of database technology to Wind River’s offering.
A new API for ITTIA DB provides Java applications direct access to ITTIA DB database files through the standard JNI interface. Java applications can execute SQL queries, or access tables directly with indexed search. The ITTIA DB-SQL Java API is fully integrated with the Java type system, making it easy to share database files between Java applications and C/C++ software. Unicode strings are converted to the correct format automatically and binary large object (BLOB) fields enable storage of arbitrarily-large byte arrays.
Support for C# and other .NET languages has also been added using the P/Invoke interface. The same ITTIA DB-SQL API is used in .NET as in Java, with minor changes to accommodate the .NET type system and syntax.
“The increase in customer awareness and adoption for embedded databases is a evidence to our commitment to embedded developers building the next generation of embedded and mobile applications,” said Sasan Montaseri, ITTIA President. “Our goal is to offer developers the option of selecting quality embedded database software at a very reasonable cost. We continue to innovate and position our ITTIA DB product, so that our customers can avoid the cost, time and risk of building database software themselves.”
ITTIA offers database solutions for platforms where limited memory, storage, and processing power make software development a challenge. ITTIA develops fast, high performance database products and tools with the goal of providing excellent data management software for embedded systems and devices. ITTIA products are designed to be suitable for application development and deployment at significantly reduced cost. ITTIA customers include GlaxoSmithKline, VNU, Boeing, Moodys, Sandia National Laboratory, Puget Sound Energy and others.