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.
I n h a l t s ü b e r s i c h t
D o k u m e n t e :
