IBM Informix 14.10 - Overview / IBM Solution Brief

Just in time for the release of Informix 14.10, IBM has published a new data sheet for Informix. Read an introduction to performance, enterprise replication, security or smart triggers enhancements - and why Informix is the key database for IOT projects!

You can also download and view the data sheet here.

The high-performance, low-footprint database for analytics on the edge, in the cloud and on premises IBM Informix delivers: Powerful, optimized time series and geospatial data management Automated administration and self-management features Footprints under 100 MB for easy IoT gateway embedding IBM InformixHQ for collaboration and management across multiple instances Integrated in-memory warehouse accelerator (Advanced Enterprise)

Enterprise databases have always been strong when it comes to fast transaction processing and continuous data availability. Informix does this with minimal administration and the highest level of security - in a legendary way.

The Internet of Things (IoT) means new challenges, also for databases. In the future, companies will be confronted with a flood of different data and formats that can be used for analytical monitoring or as a controlling resource.

Many companies have chosen Informix, a solution capable of meeting all their transactional and analytical needs in the enterprise environment as well as in the Internet of Things context. IBM Informix is an easy to integrate, powerful database for processing SQL, NoSQL, JSON, time series or geodata as they occur in the IoT environment. Informix is up and running in minutes and accessible from virtually any desktop, laptop or mobile device. Even when deployed on thousands of devices worldwide, Informix is easy to install and manage. Minimal installation sizes - in some cases less than 100 MB - and the ability to run on distributed devices with a variety of automated management capabilities, make Informix ideal for integration into embedded systems or IoT edge gateways.

Download the IBM Informix 14.10 data sheet here!

In addition to detailed information on the new features, you will also find a table that compares the current editions, Express, Workgroup, Enterprise and Advanced Enterprise.

How to morph a Raspberry Pi into
a powerful Sensor Data Cache and IoT Gateway

Alexander Koerner (IBM Analytics Architect)
IIUG 2016 Session - 49 Pages

Alexander Koerner gives a short introduction in Raspberry Pi and sensor data communication and answers why is Informix is the perfect sensor data store for edge gateways based on the Raspberry Pi.

Introduction / Why a Raspberry Pi?

How to build a sensor data cache with a Raspberry Pi

• Choice of communication protocol(s)
• Sensor-to-Pi communication / Pi-to-Network communication
• Sensor HW considerations
• Operating System(s) / Additional Software requirements
• Sensor Data Cache (Informix)
• Flow / Streams Processing

 Sensor data analytics in motion and at rest

• In-Motion Sensor Data Analytics / Node-RED / Quarks / Spark Streaming (not covered)
• At-Rest Sensor Data Analytics / Informix 12.10

Informix 12.10 on Raspberry Pi

• Informix is the perfect sensor data store for edge gateways based on the Raspberry Pi
• Informix on the Raspberry Pi - How To
• Install and configure Informix on the Raspberry Pi

The cloud connection

• IoT Architecture Annotated with IBM Products
• The Watson IoT Platform – IBM's next generation IoT platform
• How to connect the Raspberry Pi to the IBM Cloud

Sensor data visualization

• JavaScript / Grafana

Summary / Contact information

Informix on ARM Architecture

Globally ARM is the most widely used instruction set architecture in terms of quantity produced. The low power consumption of ARM processors has made them very popular: over 50 billion ARM processors have been produced as of 2014, of which 10 billion were produced in 2013 and "ARM-based chips are found in nearly 60 percent of the world’s mobile devices". The ARM architecture (32-bit) is the most widely used architecture in mobile devices, and most popular 32-bit one in embedded systems. (Wikipedia)

What does it mean to Informix and the upcoming Internet of Things?

View the Advanced DataTools webcast replay. This webcast will explore some of the ARM-based computers that are available, and describe why ARM is such a good fit for an IoT solution. Tom Beebe will show how simple it is to install a full version of the IBM Informix database server on a low-power, affordable ARM-based Linux computer, and why the power and simplicity of Informix makes it ideal for an embedded IoT gateway.

Autonomic Tuning Informix 12

Scott Pickett
WW Informix Technical Sales

Overview & Problem Statement:

• We want the Informix database server to be as invisible as possible.
• After the initial install of IDS and uptime, we need the server to be able to adapt to any workload that comes its way.
• Prior to 12.10xC2, several key server resources were not dynamic. This could and did lead to artificial performance ceilings, and an increase in downtime to fix, or degradation in performance until the issue was detected by human interface.
• Not everyone knows how to detect ……. and if they do, getting the downtime from management is an issue …. always.
• The improvements are in several different categories….

Automate small footprint,
embedded Informix Server deployments

Sreeni Paidi
Advisory Software Engineer IBM

Overview:

This tutorial shows you how to automate IBM® Informix® Dynamic Server (IDS) small footprint deployments by using the IDS deployment utility and the IDS embeddability toolkit. An important requirement of an embedded database system is that it be invisible to end users and administrators.

IDS is a perfect database system for application environments that require an embedded database because you can install, deploy, and administer the database silently. It is transparent to users that there is a robust and reliable database system catering to the database requirements of the application.

IBM RedBook 
Embedding IBM Informix

Abstract:

In this IBM® Redbooks® publication, we discuss and describe the capabilities for embedding Informix® into applications and software. We introduce the technological architecture and describe several of the functions and features that support Informix as a robust and powerful embeddable DBMS. Many of these features are unique in the industry today, enabling clients to create a business advantage.

The Informix database server can support the requirements of an embeddable DBMS, and is doing so for many companies today. The low administration requirements of the Informix database server enable clients to deploy thousands of Informix instances, embedded in applications in locations where there are no technical resources to support the database. The real requirement is for applications with embedded databases that require little or no administration, take minimum storage resources, have excellent performance, and are highly reliable.

Cisco and IBM Informix Database Software
Enhancing Collaboration

Cisco chose to embed IBM Informix® database
software in their solutions because of the robust
embeddability, high reliability, and extreme
performance of Informix.

This white paper addresses a number of the features and techniques Cisco uses to embed Informix in its solutions, and why.
It also highlights some of Informix’s newer features. The white paper is divided into six sections, each corresponding to the different tasks involved in the embedding process.

Build an app to read sensor data and predict failure using Informix TimeSeries service

Michael Chris Golledge - Advisory Software Engineer IBM 

developerWorks article - 10 July 2014

IBM Bluemix provides an easy-to-use platform for developing a solution involving sensors, database storage (in the TimeSeriesDatabase), server-side analytics, and a monitoring application to warn the customer if trouble appears to be imminent. This demonstration is a simple simulation of a refrigerator, cloud-based storage and analytics, and monitoring software to alert the user if the device is approaching unsafe temperature limits. Use the tools described here to build a similar solution to solve a real problem you're facing.

Visit developerWorks and view article online ...

 IBM-developerWorks-Golledge-Informix-TimeSeries-Service-App-(2014-07)