ITTIA DB SQL is a relational database management software library for embedded systems and intelligent Internet-of-Things devices. It is a full-featured robust data management technology that scales down to meet the constrained resource requirements of embedded systems. Products built with ITTIA DB SQL are fast and scalable, and run on modern operating systems such as Windows, Linux, INTEGRITY, QNX, ThreadX, Nucleus, μcOS-II, μcOS-III, and VxWorks – even with a custom file system and without an operating system. ITTIA DB SQL is cross-platform and applications embedded with it run on ARM Cortex-A, ARM Cortex-M, PowerPC, x86 and desired custom hardware platforms.
ITTIA DB SQL offers benefits in its modular architecture that enable customers to create highly optimized and reliable systems with low total cost of ownership. With ITTIA DB SQL, manufacturers build robust, high-value products, with no database administrator, to store, manage, analyze, connect, and distribute data.
ITTIA DB SQL is a solid database framework for the development of a variety of mission critical systems from consumer electronics, medical devices, robotics, industrial automation, and solar systems to many other markets.
ITTIA DB SQL is designed from the ground up to provide the most important relational database capabilities to C/C++ application developers for embedded systems and devices, without requiring the use of complex installation or administration tools. By combining SQL queries with low-level access to tables and indexes, ITTIA DB SQL is both familiar to experienced database application developers and approachable to embedded developers experiencing relational data modeling for the first time.
ITTIA DB SQL supports ARM Cortex-A, ARM Cortex-M, x86, and many other target platforms, to ensure that product designers are not locked in to a single platform. Powerful features, such as runtime SQL, dynamic schema alteration, isolation levels, database replication, hybrid memory/disk storage, and in-place encryption are both easy to use and streamlined for embedded applications.
To communicate with other devices and back-end services, ITTIA DB SQL uses a lightweight embedded server to support both remote SQL queries and database replication. A multithreaded ITTIA DB SQL application can be converted to a distributed application with only a few lines of code, synchronizing records between devices that can continue functioning even when disconnected. Replication settings are set by the application and stored in the database file. Each table can independently send, receive, or share records in both directions. Data conflicts are detected automatically, with multiple conflict resolution policy options.
Security in embedded systems requires a conscientious approach to application design and implementation. Critical security capabilities such as identity management, access control, and encrypted network communication must be understood and correctly deployed. When data is at rest on a device, ITTIA DB SQL database encryption efficiently hides data from malicious actors with physical access to the storage media. When data is in motion, SCRAM authentication and SSL/TLS communication prevent unauthorized access to and remote tampering with local database files.