SOURCE: Encirq

March 18, 2008 08:40 ET

Encirq Releases Major Upgrade to DeviceSQL

DeviceSQL™ 4.0 Release Can Reduce Embedded Storage Requirements by Over 50% and Offers Numerous Enhancements for Increased Performance, Efficiency and Developer Control

BURLINGAME, CA--(Marketwire - March 18, 2008) - Encirq® Corporation, a leading provider of software and services for high-performance embedded data management and low-latency event processing, today announced the release of DeviceSQL 4.0, a major upgrade to its award-winning SDK for building efficient embedded databases and data manipulation code for embedded device applications.

DeviceSQL 4.0 provides many new features and enhancements to allow developers to embed high-performance, high-efficiency data management functions into their applications. New features and enhancements in DeviceSQL 4.0 include:

--  Compression Adapters that can reduce data storage requirements by 50%,
    allowing applications to make more efficient use of available storage
--  Two new indexing services: MPHash Lite and MPAVL. MPHash Lite
    increases the performance of applications that store large amounts of data
    by enabling creation of extremely efficient in-memory hash indexes against
    tables that might otherwise have exceeded available memory space. MPAVL
    indexing allows applications to perform efficient range scans of paged
    table data, boosting performance for applications that store data in flash
    memory or disk.
--  Index Open / Close functionality for dynamically opening and closing
    indexes as needed by the application to optimize performance and memory
--  Lite Storage Service for performing fast writes for paged data, making
    DeviceSQL even better for data logging applications or any other
    applications where the data can be re-broadcast.
--  An In-Place Update capability that improves performance by allowing an
    UPDATE to replace an existing row of data rather than perform a DELETE and
    then an INSERT.
--  Iterative Search Results for faster, more memory-efficient queries.
--  Database Handle Service to allow an application to access multiple,
    discrete DeviceSQL databases within the same application.
--  Data Encryption for encrypting table and index data for enhanced
--  Recovery Callback functionality that allows for a developer-defined
    function to execute when a data file needs recovery. This function can
    determine whether to continue with recovery (open the database) or halt the
    application (close the database), enhancing developer control.
--  Compact row headers that reduce persistent file sizes by 4 bytes per
    row, significantly reducing the file size for tables that contain a large
    number of rows.
--  A new Fixed-Size Paged Storage Service that reduces persistent file
    sizes by 2 bytes per row and can eliminate fragmentation.
--  File size usage threshold limits that enable developers to restrict
    the size of a paged data file to ensure that hardware and/or application
    constraints are not exceeded.

DeviceSQL 4.0 also features a number of new tools and capabilities for probing DeviceSQL databases and the effect of transactions. These include:

--  SQL Probe Tool. This tool allows developers to access data in a
    DeviceSQL data file by enabling reading and writing directly from the file
    without the need for a separate application. It also allows tables to be
    loaded from, or saved to, a .CSV file.
--  Remote DB Query Tool. This tool allows for remote updates and queries
    on DeviceSQL data files.
--  View Number of Rows Affected. This new function allows developers to
    determine the number of rows affected after an UPDATE or DELETE operation.

Another major new capability available with DeviceSQL 4.0 is operation as a "stand-alone" embedded database. For the first time, a DeviceSQL database can be started, accessed, manipulated and closed exclusively with DeviceSQL's Dynamic C or Interpreted SQL interfaces. This new capability allows developers to embed a compact, high-performance embedded database into their applications without requiring any compiled DeviceSQL language code. Developers of packaged run-time platforms, reference designs and evaluation boards can now easily embed and offer the many advantages of DeviceSQL data management functionality to enhance their offerings for customers.

"There is an almost insatiable need amongst embedded developers to get better performance and reduce the memory usage in their designs," said Deb Goslin, CEO of Encirq. "This fourth-generation release of DeviceSQL marks a major advance to our industry leading advantages in these areas while giving developers even greater control. Together with Encirq Professional Services, Encirq is providing customers with an unbeatable combination for demanding design constraints and development schedules."

About DeviceSQL

Encirq DeviceSQL is a software development kit (SDK) for building optimized embedded databases and high-performance code for manipulating data. It consists of the DeviceSQL programming language, the DeviceSQL Compiler for compiling SQL statements into optimized ANSI C source code, and modular runtime services that provide an ultra-efficient runtime environment for virtually any target operating system and CPU. DeviceSQL works together with most popular development environments and integrates easily with existing software applications via three different types of application programming interfaces (APIs).

About Encirq

Encirq Corporation is a leading provider of software and design services for ultra high-performance, low-latency event processing and embedded data management. With its DeviceSQL SDK and Encirq Professional Services, Encirq helps electronic device OEMs build reliable software for efficient management and processing of data so they can deliver better products in less time. For enterprise applications, Encirq's ultra high-performance Event Processing Platform and Encirq Professional Services make it possible for customers to process, monitor and act on large volumes of data and real-time events faster than with competing solutions. Encirq is headquartered in Silicon Valley and partners with companies around the globe to improve their competitiveness.

Additional information is available at

Contact Information

  • For Media Inquiries:
    Jan Liband
    Encirq Corporation
    650-292-3535, Ext 906
    Email Contact