ITTIA DB SQL
ITTIA DB SQL ist eine Relationale Datenbank geeignet für den Einsatz auf Embedded Systemen. Ihre Verwendung ist plattform-unabhängig, wodurch der gleichzeitige Zugriff von einem beliebigen Betriebssystem mit einem beliebigen Prozessorkern möglich ist. Je nach Anforderungsprofil gibt es die Software in unterschiedlichen Leistungsklassen als Libraries oder als Source-Code.
Anwendungen, die mit ITTIA DB SQL erstellt wurden, sind sehr robust, äusserst zuverlässig und schnell, unabhängig davon, ob auf die Daten direkt in einer lokalen Datei oder über eine Client/Server-Verbindung zugegriffen wird.
|
|
Embedded: Die Datenbank kann auch ohne Betriebssystem eingesetzt werden.
Fast: Die Datenbankzugriffe (Insert, Select, Update und Delete) sind bei kleinen wie auch grossen Datenmengen immer äusserst performant.
Reliable: Automatisches Crash-Recovery und CRC-Integritychecks stellen sicher, dass ein Stromausfall nicht zu einem Totalausfall führt.
Compatibility: Auf die Datenbank kann mittels SQL, ODBC und ADO.NET zugegriffen werden.
Support: Nutzen Sie das Fachwissen der ITTIA Datenbank-Experten
|
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 and/or 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 |
|
|
|
Storage-level locking |
* |
|
|
Row-level locking and isolation |
|
|
|
Optimistic online backup |
* |
|
|
Hot online backup
|
* |
|
|
Replication through file sharing |
* |
|
|
Network replication |
* |
|
|
Recovery logging |
* |
|
|
Dynamic schema alteration |
* |
|
|
Encryption callbacks |
* |
|
|
Change notification |
* |
|
|
Sequences |
* |
|
|
BLOB data type |
* |
|
|
Unicode data type |
* |
|
|
Automatic type conversion |
* |
|
|
* This
feature can be enabled or disabled in the ITTIA
DB source code package. Optional features are disabled in the binary package.