Platform Description
ITTIA DB SQL and μC/OS
Software developers for embedded devices face many unique challenges. Systems can run for years, and, with no easy way to perform maintenance, must be very reliable. Resources, such as memory and storage space, are usually very limited. Since the exact hardware specifications are known during design, it is possible to build fail-safe software that efficiently utilizes limited resources. To accomplish this, all software on the device must be selected carefully.
Micrium develops low-level software for embedded developers, including the µC/OS™ real-time kernel and file system. ITTIA DB SQL leverages Micrium technology to safely and efficiently share files on internal and external storage media in multitasking applications. By focusing on the features that embedded developers need, these products offer the most control and accountability for mission-critical applications. A small footprint design and careful attention to memory usage make devices more reliable and better prepared for the test of time.
With support for both standard SQL queries and low-level access to tables and indexes, ITTIA DB SQL is easy to use and optimize. Database transactions protect data integrity. ITTIA's training program will bring developers up to speed on advanced techniques, such as AES storage encryption to secure data on removable media. Companies seeking certification and compliance with industry-standard development guidelines will benefit from ITTIA and Micrium products.
Development Environments and Target Processors
Micrium supports many popular embedded systems, microcontrollers, and DSP devices. Micrium's code is standard C and can be used with any C or C++ compiler that follows normal conventions, including IAR™ Embedded Workbench, Keil™ MDK, and CrossCore Embedded Studio. Both internal memory and external memory configurations are available, and applications can run from RAM or flash.
ITTIA DB SQL and Micrium support a wide variety of 32-bit and 64-bit processor cores, including ARM Cortex-M, ARM Cortex-A, ARM9, XScale, Blackfin, and x86/x64. ITTIA and Micrium software has been tested on hardware from Freescale, Analog Devices, and many other vendors, and both companies work with customers to support their exact development and hardware requirements.
Storage and Software Stacks
With the µC/OS file system, ITTIA DB SQL can create database files on a variety of storage media, including:
- MSC
- NAND flash
- NOR flash
- RAM disk
- SD cards via SPI or SDIO
With µC/TCP-IP, ITTIA DB SQL can communicate with remote systems to replicate data and execute SQL queries.
Developer Utilities
The ITTIA SQL application provides a console interface to open, inspect, and modify database files stored on an embedded device with a serial terminal.
The ITTIA SQL Browser is a desktop application that can connect to ITTIA DB SQL on an embedded device with µC/TCP-IP.
ITTIA DB Sync is a network service and configuration utility that enables database replication between ITTIA DB SQL and a back-end RDBMS product, such as Microsoft™ SQL Server™ or Oracle™ Database.
ITTIA IoT Data Management Platform Highlights
- Stream data processing in real-time
- First class time-series data management platform
- Secure protection from data cyber threats
- Security strategy through system development and deployment
- High-performance concurrent read/write
- Distribute embedded data across heterogeneous devices
- Developer freedom to remotely access data in a cockpit
