Raw Flash Storage Data managed by ITTIA DB SQL Embedded Database Architecture

In order to retrieve data, an EEPROM requires each write operation to begin at an aligned offset, which necessitates batched writes to avoid excessive ware.

ITTIA DB SQL eases this process by supplying raw storage flash media with robust data management capabilities through SPI. This is made possible through the creation of an ITTIA DB database on EEPROM or flash media by the embedded application; therefore, data is stored in table rows that will be efficiently queried, with or without SQL. ITTIA DB SQL also combines data with a journal to protect it from corruption in case of unexpected power loss or other failures. Data and journal can be mixed in the same region of storage, and ITTIA DB SQL always writes in blocks of uniform size to accommodate alignment restrictions.

Storing database directly to SPI device can also eliminate the need for a file system. Rather than rewriting an entire file whenever changes need to be saved, the application can atomically modify one or more rows by grouping operations into database transactions. Even images and music can be stored in the database as binary large objects. Unlike editing a file, database access is protected by the ACID properties: atomicity, consistency, isolation, and durability.

ITTIA DB SQL offers significant advantage even without an operating system. When an operating system is available to provide multitasking, an application can safely and efficiently share database among different tasks. ITTIA DB SQL supports common desktop operating systems such as Windows and Linux, plus many real time embedded operating systems such as ThreadX, QNX, VxWorks and ucOS-II.

Embedded systems and mobile devices run on a broad array of parallel NOR, serial NOR, and NAND flash memory solutions with various memory landscapes, from a few kilobytes to several gigabytes. Now developers creating software for these devices can benefit from ITTIA DB SQL to manage data effectively on storage media accessed through SPI. ITTIA DB SQL storage provides the required technology so application developers can select a data management solution that meets the diverse demands of their customers.