Disasters are in the news, and it is easy to recognize the value of having the right insurance, Data Insurance.
The Informix Dynamic server implicitly provides you with some basic insurance by automatically maintaining physical and logical logs to provide data integrity should something abruptly stop the server. But that may not be enough when there is a disk failure, corruption, or a flooded server room. While Informix support can help solve many problems, some problems can only be resolved by restoring from a backup.
The Internet of Things (IoT) has taken off and we now see it everywhere. Open Source software packages have been around for many years but recently we have also seen Open Source hardware take off. Now I find myself playing with hardware again after too many years of doing just software development. Open Source hardware has made it so much easier and inexpensive to build electronic gadgets and especially IoT devices. It also comes with a big fun factor.
In this blog, I am going to discuss my first project that was not out of some Arduino or Raspberry PI project cookbook. Here we are going to combine some Open Source hardware along with the Informix database server to collect and analyze GPS data from a vehicle using a homemade IoT gateway.
One of the main objectives of the Informix team is to continuously enhance the user experience of our product. This includes product quality improvement, new features and enhancements, transparency, continuous delivery, and easy access to our offerings. In this post, let us introduce you to a new set of open source database drivers available to you. Please visit us at https://github.com/OpenInformix and get involved.
The Informix Warehouse Accelerator (IWA) is a software appliance for the Informix database server, using in-memory, columnar data storage for business intelligence applications doing OLAP. For such workloads IWA typically can achieve a query acceleration of 10 - 100 times faster than running the workload within the Informix database server. With this post we start a casual series of articles on IWA in general as well as specifics for its deployment in cloud environments like Bluemix.
This is the second part of this multi-part series. In this part we will take a closer look at setting up, configuring, and inserting data into Informix TimeSeries.
Create Database Structures
We’ll start by creating a database executing the following SQL statement to create a working database. To keep things simple, we will create everything in the default dbspace (rootdbs).
Security features fall into three categories that are important to IoT.
We need to concentrate on how each of these is important to IoT concerns.
Informix has best of the breed technology to deploy a fault tolerant, production-grade cluster with turn-key deployment support.
Kubernetes is an open source cluster management software for automating deployment, scaling and management of containerized applications. Kubernetes is quickly becoming the universal interface to deploy production-grade container based applications in both private and public cloud environments.
SQL databases have supported the LIKE operator for a very long time and it will allow you to compare a string to a pattern and has wildcard characters to match any single character or zero or more characters. Informix also supports the MATCHES operator that give you some more wildcard matching options. Similar to the LIKE predicate, MATCHES has support for wildcard characters to match any single character or zero or more characters. It also has the ability to match single character from a set or range of characters or match a single character that is not in a set or range of characters. These are both examples of simple regular expressions.
With the advent of micro services architecture and DevOps model, enterprise architects expect database servers to operate in real-time environment, push data and events to clients rather than clients polling for data, scale linearly, enable zero downtime deployments, and easy integration with other middleware services like enterprise message bus.
Databases are historically a great place to store data and retrieve data. However, they are not always the easiest to process events and receive alerts from, especially in real time or near real time. You can use a specialized software for this, but what if you wanted the best of both worlds? An enterprise level database for storage and security, but with the ability to process events and alerts as they happen.