Software:ITTIA DB

From HandWiki
ITTIA DB
Developer(s)ITTIA
Initial release2007; 17 years ago (2007)
Stable release
8.6 / August 15, 2022; 22 months ago (2022-08-15)[1]
Operating systemLinux, Microsoft Windows, RTOS
PlatformIA-32, x86-64, Arm
LicenseProprietary
Websitewww.ittia.com/products or {{{1}}}

ITTIA DB is an embedded database developed as proprietary software by ITTIA. First released in 2007, ITTIA DB is designed for time series data processing and data management in embedded systems and Internet of Things devices. It is used in industries such as medical devices, industrial equipment, energy, environmental monitoring, and consumer electronics.

ITTIA DB supports AMD/Intel architecture and Arm architectures on 32- and 64-bit processors and 32-bit microcontrollers. ITTIA DB supports Windows, Linux, and various real-time operating systems, including QNX, VxWorks, Integrity (operating system), FreeRTOS, and Azure RTOS ThreadX.

History

  • 2007: ITTIA DB launched for embedded systems
  • 2011: High Availability and SQL
  • 2017: ITTIA DB Console web front-end
  • 2019: ITTIA DB SEAL, Security Expert Agent Library
  • 2020: Introduction of HTAP capabilities
  • 2021: ITTIA DB IoT for microcontrollers
  • 2022: ITTIA SDL, conformant to the principles of IEC/ISO 62443

Technology

ITTIA DB is an embedded time series database for autonomous systems and Internet of Things (IoT) devices.[2] Sensor data arrives as IoT streams, which may be filtered, down-sampled, windowed, or joined through real-time materialized views. Processed data is stored in standard SQL tables and time series columns, which are oriented toward long-term performance and analysis for timestamped values.

ITTIA DB is deployed as either a stand-alone executable with the ITTIA DB Console web front-end, or as a library for C, C++ and Python applications. ITTIA DB queries follow the hybrid transactional/analytical processing (HTAP) model. ITTIA DB runs continuous analytical queries over IoT streams with SQL statements issued over a web services interface.[3] Standard transactional SQL queries are used to safely modify the current state of a table or time series column.

Developed according to the ITTIA Secure Development Lifecycle (SDL), ITTIA DB is conformant to the principles of IEC 62443.[4] Security capabilities include AES storage encryption, SCRAM authentication, and SSL/TLS connectivity. The ITTIA DB Security Expert Agent Library (DB-SEAL) also monitors database activities to mitigate common database attacks, such as SQL injection.[5]

References