User Community for HCL Informix
  • Home
  • Blogs
  • Forum
  • About
  • Contact
  • Resources
  • Events

Regular Expressions with HCL Informix

7/26/2017

2 Comments

 
Picture
                                                                                                            Updated: 8/30/18
​
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.  HCL 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.

Read More
2 Comments

Push Data to Client

7/24/2017

3 Comments

 
Picture
                                                                                                            Updated: 8/30/18
​​
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.

Read More
3 Comments

Introducing HCL Informix Smart Triggers

7/17/2017

25 Comments

 
Picture
                                                                                                            Updated: 8/30/18
​
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.

Read More
25 Comments

HCL Informix Timeseries Part 1 - Introduction

7/6/2017

1 Comment

 
Picture
                                                                                                            Updated: 8/30/18

This is the first part of a multi-part series on HCL Informix TimeSeries, going into greater detail on how to setup, configure, and use the HCL 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. HCL  Informix TimeSeries provides a method of storing and analyzing data that goes beyond the capabilities of traditional relational databases. HCL Informix TimeSeries provides storage savings and better query speeds when compared to a relational database.

Read More
1 Comment

    Archives

    November 2019
    September 2019
    May 2019
    April 2019
    February 2019
    January 2019
    October 2018
    July 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

    Categories

    All
    Business
    Technical

    RSS Feed

Proudly powered by Weebly
  • Home
  • Blogs
  • Forum
  • About
  • Contact
  • Resources
  • Events