Mimer Introduces Small Footprint SQL Front-end for Mobile DBMS

Mimer Information Technology announces a new small footprint SQL front-end for the Mimer SQL Mobile database management system (DBMS). This new SQL technology combines a full SQL feature set with an ultra small footprint, making this one of the most advanced DBMS development projects in recent years in the world. With the new SQL front-end, developers of mobile applications for all types of mobile phones have access to the full SQL language, including ad hoc, dynamic SQL statements.

The Mimer development team has a long experience in building advanced database software products. This experience is now used in developing a new small footprint SQL compiler and optimizer for Mimer SQL Mobile.

With the new small footprint SQL front-end the Mimer SQL Mobile product is extended with support for dynamic data manipulation SQL statements (select, insert, delete, update, call, and set) with an additional footprint of only 150 Kbytes.

An SQL front-end to a DBMS is a very complex component. It must correctly handle all the complicated constructions in the SQL language, and offer the best possible performance by optimizing all database access. To implement all this functionality for resource constrained mobile devices is a huge technical challenge.

“The development of the new SQL front-end to Mimer SQL Mobile is one of the most difficult and important projects we’ve accomplished in recent years. The challenge is to combine a 100% correct functionality with high performance and small footprint, and I’m very satisfied that we have met this challenge,” says Bengt Gunne, Development Director at Mimer Information Technology.

Facts on the new SQL front-end in Mimer SQL
The new SQL front-end to Mimer SQL consists of an advanced compiler for ISO SQL:2003. After a first syntactical and semantical analysis of each SQL statement, the SQL front-end creates an optimized execution plan for executing the SQL statement. The sophisticated execution plan optimization in the new SQL front-end is cost based.

This means that Mimer SQL Mobile with support for the full SQL feature set, including stored procedures, triggers, views, and advanced query optimization, is combined with a multi-user database server with a total footprint of less than 500 Kbytes.

The new SQL front-end will be available in Mimer SQL Mobile version 10 to be released in Q4 2007. It will also be included in future versions of the Mimer SQL Enterprise and Mimer SQL Embedded products.

About Mimer Information Technology
Mimer Information Technology is a world leader in the field of zero maintenance DBMSs with its Mimer SQL product. Mimer SQL is an easy-to-use, high performance and scalable DBMS available for Windows, Mac OS X, OpenVMS, Linux and other Unix platforms. With Mimer SQL Mobile, the Mimer SQL product range is extended to mobile phones and PDAs running Enea OSE, Linux, Symbian OS and Windows Mobile. Examples of customers using Mimer SQL for their mission-critical systems are Volvo Cars (Sweden), National Blood Service (England) and DJ Galvanizing (Canada).