ITTIA DB Features
- ACID transaction logging
- Automatic crash recovery using write-ahead logging (WAL). Supports high-performance commit modes such as group commit.
- Disk and Memory Tables
- Store performance-critical tables entirely in memory, and store large tables on disk with automatic page-based caching.
- Indexed search
- Fast, scalable B+ tree and T-tree indexes give applications fast access to data, whether it's 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.
- Portable C, C++, Java, C#, ADO.NET APIs
- All products in the ITTIA DB family utilize the same portable file format and programming interfaces.
- Cross-platform (Windows, Linux, etc.)
- ITTIA DB supports Linux, Windows CE, 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.
Feature Comparison
ITTIA DB is a family of products for high-performance relational data storage on embedded systems and devices. Each edition of ITTIA DB is specifically designed and developed to meet the requirements of a certain class of embedded systems and devices. ITTIA DB is available in both binary and source code packages.
| Feature | Compact | Standard | Plus |
|---|---|---|---|
| C API |
|
|
|
| C++ API |
|
|
|
| Transaction rollback | |
|
|
| Disk tables and file storage |
|
|
|
| Memory tables and storage |
|
|
|
| Strongly-typed tables | |
|
|
| B+ tree indexes | |
|
|
| T-tree indexes |
|
|
|
| Platform-independent file format | |
|
|
| SQL | |
|
|
| ODBC | |
||
| Java API |
|
||
| ADO.NET data adapter, C# API | |
||
| Client/server shared access | |
||
| Multi-threaded shared access | |
||
| Row-level locking and isolation | |
||
| Recovery logging | Optional* | |
|
| Dynamic schema alteration | * |
|
|
| Encryption callbacks | Optional* | |
|
| Change notification | Optional* | |
|
| Sequences | Optional* | |
|
| BLOB data type | Optional* | |
|
| Unicode data type | * |
|
|
| Automatic type conversion | Optional* | |
|
* This feature can be enabled or disabled in the ITTIA DB source code package. Optional features are not included in the binary package.
