Software:ITTIA DB
| Developer(s) | ITTIA |
|---|---|
| Initial release | 2007 |
| Stable release | 8.6
/ August 15, 2022[1] |
| Operating system | Linux, Microsoft Windows, RTOS |
| Platform | IA-32, x86-64, Arm |
| License | Proprietary |
| Website | www |
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
- ↑ "ITTIA Launches Dual Engine Real-Time Embedded IoT Database". 15 August 2022. https://www.eejournal.com/industry_news/ittia-launches-dual-engine-real-time-embedded-iot-database/.
- ↑ Oliver, Tiera (7 October 2021). "ITTIA Embedded Time Series Database to Support STM32 Edge Devices" (in en). https://embeddedcomputing.com/technology/software-and-os/os-filesystems-libraries/ittia-embedded-time-series-database-to-support-stm32-edge-devices.
- ↑ Bill, Lydon (29 April 2021). "Industrial Digitalization: How an Edge Embedded Time Series SQL Database Delivers Performance" (in en). https://www.automation.com/en-us/articles/april-2021/industrial-digitalization-how-edge-embedded-time.
- ↑ "CIA Protects Embedded Data Across Connected Devices" (in en). 9 May 2022. https://embeddedcomputing.com/technology/security/cia-protects-embedded-data-across-connected-devices.
- ↑ "Essentials of IoT device data management | Industrial Ethernet Book". https://iebmedia.com/technology/iiot/essentials-of-iot-device-data-management/.
 |
