ITTIA DB Lightweight Relational Embedded Database

ITTIA DB is a lightweight embedded database for application developers requiring high-performance relational data storage. Ideal for dedicated embedded systems, intelligent devices and mobile hand-held systems, ITTIA DB is a next-generation ACID-compliant transactional library designed to be embedded directly into device applications. Developers enjoy ITTIA DB’s easy of use, portability and reliability.

ITTIA DB Product Family

Each product in the ITTIA DB family is specifically developed for a certain class of embedded systems and devices. ITTIA DB provides special-purpose systems and devices with complete built-in data management capability, and application developers are able to customize the database to best fit their requirements. All editions of ITTIA DB employ a common API and file format so that applications are easily migrated when requirements change.

  • ITTIA DB-SQL Plus – A multi-user, multi-threaded, client/server database library, ITTIA DB-SQL Plus enables applications to share database files between threads, processes, and devices using ITTIA's lightweight data server, designed to support a high level of concurrency even in low-memory environments.
  • ITTIA DB-SQL Standard – A standalone database library to store mission-critical data with minimum overhead, ITTIA DB-SQL Standard incorporates high-performance data indexing with ACID-compliant crash recovery and optional run-time SQL queries.
  • ITTIA DB Compact – A table-based storage engine with high-performance indexing, the ITTIA DB Compact database library offers systems and devices direct low level access to ITTIA DB files with minimum code footprint.
ITTIA DB Product Comparison

Features and Benefits

ACID transaction logging
Automatic crash recovery using write-ahead logging (WAL). Supports high-performance commit modes such as group commit.
Indexed search
Fast, scalable B+tree indexes give applications fast access to data, whether its 100 records or 100 thousand.
Run-time SQL query engine
ITTIA DB implements ANSI SQL-89 and much of SQL 2003.
ODBC
ODBC is a standard interface for executing SQL queries from practically any programming language. ODBC also enables access to ITTIA DB database files by numerous ODBC-compliant applications. Current available through ITTIA's beta program.
Portable C, C++, Java, C# APIs
All products in the ITTIA DB family utilize the same portable file format and programming interfaces.
Cross-platform (Windows, Linux, vxWorks, etc.)
ITTIA DB supports Linux, Windows CE, vxWorks, is easily ported to custom operating systems, and can even be used with no OS.
No database administration
The database is deployed with an application, so it is invisible to end-users.
Small run-time footprint, high performance
Bounded run-time memory, configurable at run-time, gives applications predictable resource utilization with minimum overhead.
Excellent support for flash media
Data is buffered in memory to automatically reduce flash wear.
Multi-threaded and client/server shared access
Row-level locking and isolation levels, features typically found in enterprise databases, enable high-performance concurrency without manual locking.
Strong data type support
Store numbers, text, dates, and times without risk of read errors.
Internationalization support
Support for UTF-8, UTF-16, and UTF-32 Unicode strings. Store text in the database in compact UTF-8 format with automatic conversion to UTF-16 wchar_t type in the API.
Dynamic schema alteration
Create tables and add columns at run-time - no need to recompile.
Learn More

Stand-Alone Embedded Library

Client/Server Shared Access