Home › Products › Key Features & Benefits

Features & Benefits

DeviceSQL has many unique features that provide important benefits and advantages to developers. Here are the key features developers have found important in their selection and use of DeviceSQL.

 

Feature

 

Benefits

 

3x-50x faster performance than pre-packaged database technologies

 
  • Makes it easier to meet stringent performance requirements
  • Faster, more responsive applications
 

Deterministic transaction times regardless of table size

 
  • Fast, deterministic performance even with exceptionally large data sets
 

Small memory footprint (24KB minimum, <100KB typical)

 
  • Leaves more memory for the rest of your application
  • Allows you to use DeviceSQL even in resource-constrained systems where no other data management software can be used
 

Services-based architecture with modular services and components

 
  • Yields the smallest possible memory footprint by including only those runtime services and components needed by your application
  • Provides superior reliability, design flexibility and developer control
 

SQL-based language for manipulating data, with procedural language and embedded development extensions

 
  • Saves time and effort by enabling you to manipulate data with simple SQL statements while still having low-level control
  • Cuts the amount of data management code to write and debug by 80% or more, slashing development time and improving software reliability and maintainability
 

Compiles DeviceSQL statements into ANSI C source code

 
  • Compiled operation provides you with the best runtime performance and determinism
  • Use familiar C/C++ development tools
  • Spend less time debugging
 

Native relational support for both in-memory and persistent tables

 
  • Provides the control and flexibility you need to manage data wherever you want
 

Three programmatic interfaces: Developer-Defined API, Dynamic C API, Interpreted SQL API

 
  • User-definable API allows you to easily upgrade/replace individual tables and functions within existing applications
  • Simplifies development by allowing you to use whichever interface works best
 

High-performance indexing services, including multiple forms of ordered (B-Tree and AVL) and non-ordered (Hash) indexes with user control over index services on a per-table basis

 
  • Makes it possible to optimize application performance and memory usage by matching the right index type to the location, size and type of data being queried
 

Concurrent data access support for multi-threaded, multi-process applications

 
  • Allows you to use DeviceSQL in applications that must access and protect shared data
 

Transaction processing with full ACID properties supporting crash recovery and rollback

 
  • Improves application reliability, particularly after unexpected hardware or power failures.
  • Enjoy  data integrity features yourself
 

Data compaction and compression

 
  • Allows you to store more data in available space and/or reduce data file sizes on persistent storage devices by approximately 50% 
 

Data streams services for inter-process, inter-thread, inter-core, inter-processor communications

 
  • Reduces the complexity and effort involved with building reliable, efficient communications between threads, processes, cores and discrete processors
 

Integrates with existing development environments and processes

 
  • Use DeviceSQL with your favorite editor or IDE and familiar C/C++ development tools
 

Supports virtually any target operating system or CPU

 
  • Allows you to use DeviceSQL in virtually any application across your product lines
 

Encirq’s unmatched embedded data management expertise and professional services

 
  • Reduce risk and get your projects done faster with Encirq expertise, design consulting and professional services

 

 

 

 

 
 
 
Copyright © 2008 Encirq Corporation • All rights reserved. | Legal & PrivacyCopyright