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
|