The new ITTIA DB SQL hybrid memory and disk database is ideal for application development on embedded systems and devices. ITTIA DB SQL hybrid combines the fast, predictable performance of an in-memory database with the robust storage caching of a disk database. ITTIA DB SQL hybrid is a compact, self-managing package for development of applications in consumer electronics, medical devices, portable media players, network appliances, telecommunication systems, and other embedded systems.
An ITTIA DB SQL hybrid database can contain related data that is divided into memory and disk tables. Memory tables are optimized to minimize CPU cycles, while disk tables emphasize throughput when data is saved to block devices such as flash media or a hard disk. By using a solid relational model foundation, relationships are easily navigated with SQL queries or accessed directly with low-level functions.
All tables share the same transactional database kernel, whether they are stored in memory or on disk. Data is always accessed through common APIs and can be shared between threads and processes. Transactions ensure the integrity and consistency of the data, but, because the data is managed within a single database, without the complexity of distributed transactions. Modular devices can extend their functionality dynamically by adding new tables and fields to the database.
The hybrid model used by ITTIA DB SQL is ideal for devices that log events occurring at a very high frequency. The event log itself may be stored temporarily in memory, and related data such as event types, critical events, and thresholds can be stored in disk tables that are automatically and continuously saved to flash media. The device can monitor and store the maximum values for each type of event. Both the event log and associated data can be shared between the logging task, reporting mechanism, user interface, and any other components.
More info: ITTIA