Upgraded software simplifies home automation system interoperability

The IoT will result in billions of connected devices, making discovery of proximate devices a key component in emerging applications. The 6.0 version of ITTIA DB SQL enables embedded systems, appliances, and personal devices to distribute locally stored data whenever a wireless connection is detected. The application software simply stores records in a replication-enabled database, with nearby authorized devices automatically receiving a copy of the changes. This makes it easy for applications on diverse operating systems to interoperate and provide a seamless user experience.

The updated ITTIA DB SQL features improvements from utilities down to the core transactional storage kernel. The ITTIA SQL Browser provides provision back-end RDBMS servers such as Microsoft SQL Server and Oracle Database to synchronize with ITTIA DB SQL. This makes it easier than ever to connect device applications on Android, QNX, and more to existing infrastructure. Mobile applications can even use the back-end RDBMS to relay information to other devices when they join the network. Efficiency has also been incresead with the 6.0 version, with optimizations for shared access that significantly reduce latency and network overhead. Even multi-process applications benefit from accelerated bulk record retrieval. The SQL engine has also been retooled with many new query-specific optimizations. Developers can request a query plan to verify the scalability of each query and page through query results with the standard FETCH FIRST and OFFSET keywords.

ITTIA DB SQL 6.0 has strengthened transactional storage by relying less on the file system during an unexpected power failure. Support for Unicode data types has been improved, with automatic type conversion even in UTF-encoded SQL statements, and new data types are supported in back-end RDBMS products.