Extending the Reach of SQL to IoT Microcontrollers, ITTIA and Cypress Release SDK


In a latest push launch, ITTIA, a maker of embedded databases software for World wide web of Matters (IoT) units and Cypress Semiconductor Corp declared a collaborative IoT product and data administration capability. The new capacity integrates SQL into the WICED SDK and unlocks the electric power of flash media on Cypress wi-fi microcontrollers (MCU). A person of the positive aspects of employing this method is, SQL queries let brands to stream, evaluate and distribute data, at scale, on edge units employing a preferred knowledge question strategy.

InfoQ a short while ago had the possibility to job interview Sasan Montaseri, president of ITTIA, to improved recognize the influence of these investments. In this article is what Montaseri had to say:

InfoQ: Your organization has just lately shared: “ITTIA DB SQL unlocks the energy of flash media on Cypress wireless MCUs and can operate standard SQL queries versus knowledge stored on that media.” What options does this unlock in contrast to standard approaches?


Montaseri: The Web of Points is changing the way we stay. From automobiles and properties to roads and cities, every little thing around us is more and more becoming managed by devices that appear together to automate and make improvements to our life. Advanced laptop chips are embedded in objects that each individual gather and transmit info, and these integrated devices interact and review a wealth of knowledge originating from sensors growing into community of related objects.


By silently embedding ITTIA DB SQL into gadget applications, facts that would if not be discarded, these kinds of as owing to bandwidth restrictions, can be captured to regional flash media. The database tends to make it quick to evaluate or distribute information at any time, at the time it is captured, even if it is tricky to predict which details factors will be useful later on. Considering that flash media has decreased latency than most world wide web expert services, equipment are far more responsive when presenting information and facts from a regional databases, although also creating extra successful use of available bandwidth. Equipment can even perform absolutely autonomously, applying offline queries to strengthen person engagement.


When developing an embedded process, developers require to get ready in-dwelling knowledge to pick out and validate confirmed hardware and data administration alternatives, which generally normally takes numerous months or additional. With our solution, we have released relational database computer software which started off its evolution from common techniques for embedded programs and IoT devices. Ease of use, simplification in maintainability and knowledge interoperability are among few values which regular devices gain when integrate and embed ITTIA DB SQL with their system.


InfoQ: How important is it to assist SQL queries for IoT Developers? Does this decrease the barrier of entry for developers to construct IoT remedies?


Montaseri: IoT is all about details and the initial problem is to make feeling of the collected data and offer you a gadget the tools to attain intelligence from it, though ensuring secure and fault‐free habits to the system. A lot more than merely streaming data and getting instructions from other nodes and sensors, these equipment operate complex, substantial stage application systems and should work with or with out a community or cloud relationship. Meanwhile, gadgets embedded in the IoT methods ought to deal with substantial transactions for many duties and will need to be equipped to link to each other on several networks. Critical choices are designed in microseconds, working with a continual steam of knowledge coming in and likely out of the technique. In small, gadgets require to stream, gather and manage a massive volume of information, even when they choose to go offline.


A relational databases administration technique is confirmed software program that presents developers the ability to shop and look for as much facts as they can healthy on a system.  The Structured Query Language, recognized as SQL, is the regular way to access the databases on servers all through the environment, and now SQL is out there on MCUs and MPUs for community knowledge processing.  SQL has confirmed over the yrs to be the core elementary software for facts administration and with ITTIA DB SQL, look for and queries are utilized to swiftly retrieve information from in a big quantity of product knowledge.


When builders embed ITTIA DB SQL, they gain from normal SQL at just about every stage in the progress life cycle:


    • Growth scheduling: SQL significantly simplifies the design and style and conceptualization of details management complications


    • Initial improvement: swift prototyping in C/C++ or with scripting languages these kinds of as Python and Lua can help builders get began promptly


    • Late in advancement: programs can transition from SQL to lower-level table cursors wherever important to support platforms with confined computing assets


    • Right after deployment: builders make much more strong information models when they have SQL to conveniently blend and correlate information and facts from different tables. As a consequence, adding new information-driven features to deployed devices with around-the-air updates is much easier to put into practice and poses significantly less danger of details loss.



SQL is a confirmed language with which most developers are common. SQL eases details interoperability among other embedded devices and IoT units though critically easing information maintainability.


InfoQ: Another capacity ITTIA is offering is a management system that other embedded systems producers can leverage. How can manufacturers leverage this capacity in their options?


Montaseri: We supply gadget details management value for embedded devices and gadgets and give a details management system, which consists of created-in knowledge distribution and remote SQL queries, that can be fully embedded into other frameworks or immediately into product applications. In the meantime, our associates provide several frameworks for unit management and growth, and we operate with them to integrate our databases into their frameworks.


We not too long ago introduced a joint webinar with our partner, NXP. Data about this celebration is offered at our world-wide-web web site. In individual, I would like to invite you to observe our dwell demonstration which relates to device data administration and several IoT products.


For this demonstration we disclosed ITTIA DB SQL cross system capabilities as we offer you facts administration to wanted, able MCUs and MPUs presented by our associates, to collect, store, control and assess details for final decision producing purposes.


InfoQ: How are your clients utilizing edge technological innovation to further more organization? Can you share any exciting options that your customers have created on your edge engineering?


Montaseri: An exciting scenario to share is one the place robots are employed to handle animal health treatment. Devices keep an eye on feeding functions for cattle, horses, and other livestock to establish the most productive milk generate, body weight command, and ideal wellbeing treatment practices. These devices look for for feeding directions for distinct animals and keep track of feeding record, details that may be communicated with a central cloud details management area, but which have to be indexed and obtainable on every single individual process. The guidance offered by the Cloud apps need to be communicated with quite a few locally embedded databases. The databases software program must be sturdy enough to catalog and retrieve facts, and to prepare the process for community details administration challenges this kind of as electrical power decline and concurrent data accessibility.


InfoQ: What industries do you see staying the most well prepared to undertake IoT options?


Montaseri: Developments in computing drastically influence the way we will go about our life. From agriculture making use of robotics to control the day-to-day care of livestock to rapid food dining establishments acquiring approaches to lessen waste, IoT alternatives are revolutionizing each business. Due to the fact intelligently used automation improves high-quality, consistency, and efficiency, lots of marketplaces will profit from the IoT revolution, specially automotive, industrial automation, and overall health care.



The Internet of Issues (IoT) continue on to be a transformational technological innovation that is driving new small business opportunities. ITTIA is leveraging the Structure Question Language (SQL) as a usually means to lower the barrier of entry for developers to create IoT purposes. Another opportunity that ITTIA is getting benefit of is offering the ability for gadget suppliers to choose benefit of flash memory to retail outlet details on local flash media. By employing this storage sort, businesses can lessen data entry latency as opposed to other strategies like internet companies. They can also leverage a low-price info retail store for microcontrollers and microprocessors.

ITTIA is not making use of this solution in isolation, but extending it to companions as well. They are extending the ability to give created-in info distribution and remote SQL queries, that can be thoroughly embedded into other frameworks or specifically into product apps. Meanwhile, ITTIA companions give numerous frameworks for device administration.

Edge computing proceeds to be an significant deployment model for IoT remedies. Some apps cannot endure the latency of command and control instructions being presented by a cloud alternative. Not only is latency a problem, but obtaining the info indexed regionally in an embedded databases allows for fast conclusions to be made, but also enables concurrent knowledge obtain and resilient facts obtain that can stand up to intermittent energy outages.

Autonomous IoT is no longer deemed science fiction. ITTIA is viewing opportunities exactly where robots are utilized to take care of animal wellbeing care. Units observe feeding routines for cattle, horses, and other livestock to establish the most productive milk produce, weight control, and finest wellbeing treatment tactics. These systems research for feeding guidance for different animals and track feeding heritage, facts that may be communicated with a central cloud data management place, but which have to be indexed and available on every particular person procedure.


Previous articleAs the Fallout 1st disaster hits mainstream headlines, Fallout 76 players head in-game to protest
Next articleSuper Powered: Charting The Lasting Legacy Of The Super NES