Feed items

jroy's picture

Did you know?

Submitted by jroy on September 15, 2011 - 07:49


In the last few blog entries, I've been talking about TimeSeries. This time, I'd like to diverge a little for a change. Still there is a tie to TimeSeries :-)

 
jroy's picture

Talking TimeSeries part 3

Submitted by jroy on August 29, 2011 - 23:31

We left off with an insert through the virtual table view. We created a container, a row type, a table, and a virtual table. What if we could simplify this? What if we could avoid creating a container?

One reason why you don't want to create containers could be that you have a lot of data to load and you would need a lot of containers. Would it be nice if Informix could help you with that? Informix can! In the Informix 11.70.xC3 release, we added a capability that does just that.

 
jroy's picture

Talking TimeSeries part 2

Submitted by jroy on August 10, 2011 - 16:37


Informix TimeSeries is a specialized storage and retrieval mechanism that optimizes the processing usually done on this type of information. For this reason, it includes specialized storage called "container". A container is created in a dbspace. In fact, multiple containers can be created in a dbspace. A container is created using the TSContainerCreate procedure:

EXECUTE PROCEDURE TSContainerCreate('meter_cont', 'datadbs','meter_data', 0, 0);

 
jroy's picture

Talking TimeSeries

Submitted by jroy on July 28, 2011 - 01:10

In 11.70.xC3, we added some new time series capabilities. Why would you care?

Time series are found everywhere. It is simply data that is collected over time. It could be changes in stock price and transaction volumes. It could also be reading of your house electric meter. Readings could be done every 15 minutes for example to provide a much more accurate picture of how electricity is being used. Other time series examples include weather information, network traffic, thermal readings in a large data center, and so on.

 
jroy's picture

11.70 xC3 features part 1

Submitted by jroy on July 14, 2011 - 19:15

Informix often adds features in fixpacks and xC2 and xC3 are no exception. I strongly suggest that you take a look at the list of new features that are listed in the release notice. You can find it at:

 
jroy's picture

Milestone

Submitted by jroy on July 2, 2011 - 15:00

 

July 1st was the 10 year anniversary of the IBM acquisition of Informix. Since the acquisition, Informix has releases version 9.3, 9.4, 10.0, 11.10, 11.15, and 11.70. A few days ago, we releases 11.70.xC3. Other recent addition include the Informix Warehouse accelerator that introduce game changing technology for the data warehouse/data mart area. Add to that the Informix-Genero for fast application development and mobile applications.

 
jroy's picture

Coming up for air

Submitted by jroy on May 6, 2011 - 15:55

Hello everyone, I've been buries in development activities for the last many months. That explains why I've neglected my blog lately. I think I see the light at the end of the tunnel. Hopefully it's not a train... :-)

 
jroy's picture

New Informix edition and feature

Submitted by jroy on March 29, 2011 - 21:26

It's hard to believe that we are already at the end of March. Seems like it should still be January. According to my blog, it still is January! I better get on with it!

Informix just came out with version 11.70.xC2. No big deal you may think. Wrong. It is a big deal! With xC2 we are making available a new edition: IBM Informix Ultimate Warehouse edition.

 
jroy's picture

Happy new year!

Submitted by jroy on January 4, 2011 - 19:19

2010 has been a great year with the release of Informix 11.70 and 2011 is lining up to be a busy year with plenty of activities and execution on the plans of v.next.
I also hope that in 2011 we'll see even more participation from the Informix community to continue to make Informix and the solutions around it better and more exciting.

 
jroy's picture

Keeping passwords safe in the database

Submitted by jroy on November 22, 2010 - 19:09

Someone asked me the following question:

"How do I keep passwords in the database so nobody can get them?"

It means that we cannot keep the the passwords in plain text in the database. Informix has a few functions that can be used for encryption: ENCRYPT_AES and ENCRYPT_TDS. It would be easy to create a table and encrypt the column that contains the passwords.

The next statement that came up was: "..but, if someone has the encryption password, he can get all the passwords. We need to protect the passwords from internal access".