IDS Forum

Re: v11.70 warehouse infrastructure

Posted By: Fernando Nunes
Date: Wednesday, 19 January 2011, at 12:29 p.m.

In Response To: v11.70 warehouse infrastructure (Norma Jean Sebastian)

On Wed, Jan 19, 2011 at 5:00 PM, Norma Jean Sebastian <njiiug@gmail.com>wrote:

> Informix v11.70 has "warehouse infrastructure features".
>
> general questions:
>
> does this mean IN the v11.70 download which i traditionally use for OLTP
> there now exists warehouse features regarding warehouse query optimization,
> etc?
>

Yes. But you should think on specific features. Don't tell anyone that I
wrote this :) but keep the marketing message separate from the technical
perspective.
Yes, there are a lot of new functionalities that are traditionally useful
for DW environments that are now included in the engine. But your "etc." can
mean a lot of things...
Some things that pop up to my mind at this moment:
- star schema optimization (push down hash joins)
- multiple index for one query
- skip scan optimization
- fragmentation improvements (more fragmentation schemes, more table
availability....)

> does this mean that i do NOT need to install a different flavor of Informix
> (such as warehouse edition) in order to get better warehouse type
> performance from my traditional OLTP database?
>

Yes.

> does this mean i don't need a warehouse at all because my Informix v11.70
> is
> so blazing good it can do both my OLTP and DW in one package (at least if i
> am not expecting to build a huge warehouse)?
>

No. It means you can use Informix for your DW. 11.7 will be much better
fitted for this kind of work. But please keep in mind that the data
organization in a DW is completely different
from OLTP.
Yes, v11.7 is blazing good! :)

>
> what happened to the "Informix Warehouse" ... is that still around or made
> rather obsolete due to v11.70 enhancements?
>

If you're referring to Informix Warehouse Featurew it's still around and
included in the Ultimate Edition. Note that this is completely different
from the technical features above.
Informix Warehouse Feature is a simple ETL tool. So it does not replace the
features above and it's not replaced by them. It can use the features to
make a better work...
Eventually this is an example where the marketing message can cause some
confusion. The term "warehouse" is used in very different contexts.

thank you for your insight and thoughts,
> Norma Jean
>

No problem. By the way, it would be nice to allow comments in your blog (I
couldn't find a way to write them... Am I missing something?)

Regards.
-----------------------
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--0015174c3d0485bcaa049a365cc4

Messages In This Thread

• v11.70 warehouse infrastructure
  Norma Jean Sebastian -- Wednesday, 19 January 2011, at 12:00 p.m.
  • Re: v11.70 warehouse infrastructure
    Alexandre Marini -- Wednesday, 19 January 2011, at 12:25 p.m.
  • Re: v11.70 warehouse infrastructure
    Fernando Nunes -- Wednesday, 19 January 2011, at 12:29 p.m.
  • Re: v11.70 warehouse infrastructure
    Art Kagel -- Wednesday, 19 January 2011, at 8:08 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.