Secondary menu

You are here


Database in a new era of application development

A new age is dawning for the development of applications on embedded systems and devices. This era is about connecting billions of devices, each containing a wealth of information. How can you prepare to design and build the connected, data-driven applications of the future?

Developers and manufacturers are seeking new alternatives to improve performance, reduce cost, and keep up with growing data. In this new article, discover the aspects of embedded data management that will be most important for the development of your next product.

Securing embedded applications

Data security is most effective when it is built-in to applications, rather than relying on system-level security measures alone. An application can protect data by storing it in an encrypted database file, which can either be opened directly or accessed through a separate database server process. If data is replicated or accessed remotely, network communications must also be encrypted with a secure protocol that prevents eavesdropping and session hijacking. ITTIA DB SQL provides these important security features in an embedded database library.

Machine to Machine

ITTIA's M2M solution offers embedded system developers an easy way to connect applications and communicate information. For example, a home automation application can monitor the cycle of a washing machine, schedule a coffee machine to finish brewing at a specific time, and check that lights are off when away from home. Residents need to access and control information on these devices through multiple interfaces, whether mounted in the home or on a personal smart phone or tablet. A database for such devices must provide a framework for communication within the M2M infrastructure.

Analyzing and Querying Big Embedded Data

Developers of embedded applications such as medical devices, industrial automation, automotive software, etc. often need to deal with serious data management issues in which a large amount of data needs to be analyzed with typical queries by end users of the applications that they are building. These embedded ecosystems are composed of devices that divide up Big Data problems.

Some data is isolated to each device, while other data is shared with select peers. ITTIA DB SQL's unique replication and synchronization features offer to efficiently

Big Data and Embedded Database for Devices

Applications for embedded systems – including medical devices, industrial automation, automotive software, and mobile tablets – often encounter serious data management challenges in which a large amount of data is collected and accumulated at different locations. Typical queries required by end users of these systems are not easily met.

With ITTIA DB SQL a large data set can be distributed across a wide array of devices, with the potential to store millions of rows per device.

Table cursors

Data management and query analysis are important criteria for interacting with embedded data. ITTIA DB SQL offers embedded developers two independent methodologies for managing and running queries: SQL and direct low-level access. Benefits include performance tuning, speedy query execution, code simplicity, and reduced overhead when detouring around SQL. These rich APIs provide flexibility for embedded developers.

Benefit of Database for Embedded Systems and Devices

ITTIA DB SQL is designed to aid developers of applications for embedded systems and devices to store persistent data with three important factors in mind: reliability, scalability, and shared access. Our database meets these important principals through transaction logging, indexed search, and row-level locking.

In-Memory vs. On-Disk

Developers of applications for embedded systems and devices often ask us whether they should consider On-Disk or In-Memory database engines. My answer is: select a Hybrid database, which offers the best of the both worlds. With In-Memory, you use memory tables for high-performance including frequent updates and small-table select. On the other hand, with On-Disk, you can use disk tables to insert at high throughput and effeciently select from very large tables. ITTIA DB SQL is a hybrid database; memory and disk tables are interchangeable and you benefit

Big data and little devices

Managing "big data" is an interesting challenge. When data becomes too large to fit on a single system, characteristics such as volume, throughput and variety become important. On the other hand, consistency and isolation become more difficult to accomplish, especially as data is often replicated to different physical locations.

Animal health care

Finding ways to decrease health care cost is a real problem and an interesting political topic. While thousands are scratching their heads to determine how to reduce cost of healthcare for humans, one of our customers in Europe has already done so for livestock. Using robots to monitor and manage animal health care, vital information about feeding habits is stored and managed in an ITTIA DB SQL database embedded in the robot. Administrators analyze this data to significantly increase yields and/or reduce inputs through programmable animal feeding strategies.