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.
This is the first part of a multi-part series on Informix TimeSeries, going into greater detail on how to setup, configure, and use the Informix TimeSeries solution.
What is Time Series Data?
A time series is a set of time stamped data. There are many different types of time series data, for example, stock prices, smart meters, network performance metrics and any type of sensor data. It could contain raw data readings or aggregation of data over periods of time. Informix TimeSeries provides a method of storing and analyzing data that goes beyond the capabilities of traditional relational databases. Informix TimeSeries provides storage savings and better query speeds when compared to a relational database.
I was looking through my archives recently, and found an old project plan from some years ago. Hard to believe now, but back then, we planned to release the product 10 months after ‘code freeze’. Think about it -- code we implemented for our clients sat on the shelf for 10 long months AFTER it was written!
We discussed some of this at the recent 2017 IIUG conference. Many of the gathered Informix DBAs were not familiar with syslicenseinfo, and so hopefully this will be of general interest. My former colleague and mentor, John Miller, was instrumental in designing syslicenseinfo and was happy to provide some pointers on how to interpret the data. I’m happy to pass it on…
A quite important call is received in the oval office, on the phone sitting at the very Resolute desk, Informix is there. A transaction is processed at the biggest retail chain store in the world, Informix is there. You just checked in at many of big hotels in the globe, Informix is there. You chose your tools at the biggest home improvement retailer worldwide, Informix is there. You take a certain taxi in Paris and get your trip processed, Informix is also there. You buy some food at a French chain in Buenos Aires, and Informix is there. A utility company in Germany will offer flat rates and improve the use of energy at home with sensors, with Informix running on a little Raspberry Pi. A major global parcel system runs your shippings on Informix too. Have a Pilsener in Prague, and the bill tax information goes to Informix. We can go hours on this, the very same database running on a complex distributed MPP environment down to a Raspberry Pi in the palm of your hand. No one else can do that. We can say Informix is everywhere, and very much alive!
By now the users and the Informix community must be aware of the Informix on Cloud offering in the IBM Bluemix catalog. It is one of the most successful and widely talked about offering that came out in 2016. Since it was announced, the adoption has grown steadily and has become a popular choice for many Informix customers.
The Informix 4.10.JC8 Java driver is one of the largest updates to an Informix client in years. The number of improvements is pretty impressive. All of them around making the Java driver better, faster, easier to use.
Are you a developer looking for a free database to develop your application? May be you are an Informix user who is looking to try out some of the cool new features in the latest releases? May be your organization is looking for an easy way to incrementally develop and test a solution stack with a free hybrid SQL/NoSQL database offering? May be you are looking for a quick start, sandbox environment for the database newbies in your department? We’ve got you all covered!