Archive - Aug 2011

Date

August 31st

bweed's picture

1 to 40 Trillion, those are large numbers!

Somewhere over a trillion gallons of water fell from Hurricane Irene.  I even heard numbers quoted as large as 40 trillion. So, how are we doing in the aftermath of Irene, and how did we do leading up to the storm?  Let’s start with SCM (supply chain management), since it was non-existent.  I went looking for D-cell batteries one night several days before the storm, none in stock. 

 

August 30th

jroy's picture

Talking TimeSeries part 3

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 3

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.

 

August 22nd

Informix Warehouse Accelerator: Clarification of some Requirement


Icon: IWA Logo TruckThe information provided applies to the Informix Server Version
11.70.xC2 and later.

The Informix Warehouse Accelerator Admin Guide states as
requirement that the "telnet command" must be available.
This means:

 

eherber's picture

Informix Chat with the Lab - All about Informix Private Server and Mapped Users

Title: All about Informix Private Server and Mapped Users
Date: Thursday, August 25, 2011
Time: 11:30 AM - 13:00 PM (Central Time), 17:30h Germany
Presented By: David Desautels, IBM Informix Developer (IBM)
Registration: All about Informix Private Server and Mapped Users

Description:

 

August 21st

fnunes's picture

10 years of IBM / 10 anos de IBM

This article is written in English and Portuguese

Este artigo está escrito em Inglês e Português

English version

 

August 19th

aford's picture

User Defined Aggregates

Until recently I had no use for User Defined Aggregates, that was until I was ridiculed by my MySQL counterparts over the fact that Informix does not have a group_concat aggregate function.

This will not stand, ya know, this aggression will not stand, man.

 

August 16th

eherber's picture

Informix Timeseries: Oninit and Traak Systems Partnership

There seems to be an interesting partnership evolving:

Oninit and Traak Systems partner to help transform real-time data into actionable insights

Congratulations to my friend John Baker from oninit in the UK that has established this partnership !

 

August 15th

eherber's picture

Bull Data Booster powered by Informix

(german content)

Neue Warehouse Appliance von Bull mit Geld-Zurück-Garantie

Die Firma Bull GmbH verspricht mit dem neuen Produkt Bull Data Booster extreme Performance im Datawarehouse Umfeld. Es handelt sich bei diesem Produkt um eine Warehouse Appliance - ein Bundle aus Hard- und Software -, das in drei unterschiedlichen Konfigurationen (Small, Medium, Large) angeboten wird.

 

August 10th

jroy's picture

Talking TimeSeries part 2


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);