ITTIA DB SQL Data Distribution Bridges QNX with SQL Server

This allows applications to not only distribute data between devices based on the QNX Neutrino RTOS and Microsoft® SQL Server®, but also benefit from the replication environment necessary for high availability.

ITTIA DB SQL is a relational embedded database for special-purpose systems that require self-contained data management software. Similarly, QNX® operating system technology is designed for embedded systems and powers many mission-critical applications. QNX application developers are now able to access data stored in a back-end Microsoft SQL Server®, even with limited connectivity. ITTIA DB SQL provides data distribution capabilities between an application embedded with ITTIA DB running on the QNX Neutrino RTOS and other back-end systems built with SQL Server®. This offering includes high availability, replication, and data synchronization between two different platforms: QNX and Windows.

In a typical ecosystem where data needs to be distributed, data is stored across multiple platforms, and each environment runs independently. For this reason, tools that bridge the gap between data stored in various devices or back-end relational database management systems (RDBMS) are critical to the success of future applications.

The combination of ITTIA DB SQL and the QNX Neutrino RTOS offers improved data distribution, maturity, and cost savings to embedded developers. The data distribution facility offered by ITTIA DB allows QNX developers to synchronize selected tables and rows in a back-end RDBMS, such as SQL Server®, with various devices. This flexibility is intended to allow applications to reduce overhead, protect access to data, and prevent conflicts. Conflicts are automatically detected whenever a shared row is modified both in the back-end and on the device, and can be resolved either through simple rules or custom stored procedures.

QNX developers also benefit from ITTIA DB SQL distributed data features, which enable them to keep data available at all times. Increased availability ensures that failures are isolated and prevent a failure of the entire system. Distributed access provides individuals with greater freedom in where and when they can access the system, especially when devices are used. Database logging allows QNX devices to record transaction history and exchange data bi-directionally both between devices and with the back-end.