Re: Informix and Oracle in the same shop

"Ian Sparkes" <sparkes_at_sprintmail.com> wrote:

:In can be done but why would you want to ?
:
:As a database Informix is a good product but if you are an Oracle shop
:already I can't see any reason to switch, as Informix doesn't bring any
:benefits over Oracle.

Although I am not yet a data warehouse spesialist it does seem like Informix bring some significant benefits over Oracle if your datawarehouse grows big (hundreds of GB to TB range).

:And before anybody who is in love with Informix flames me .... For the
:purposes of this question I think it reasonable to work on the premise that
:both are reasonably equivalent.

I wouldn't do that. Even though they haven't yet deploied to many of their Universal Server it is a product far in front of anything Oracle have or will have for quite some time. It's fasilities are very usefull both in OLTP and datawarehouse environements. True Informix have mostly emphazised it's ability to handle new and fancy datatypes. However new ways of handling existing datatypes are at least as interesting. As a big shop these people should be able to get their hands on the Universal Server to try it out.

:My answer would be different if you were asking which RDBMS to buy starting
:from scratch.

Nils.Myklebust_at_idg.no
NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company
The Informix FAQ is at http://www.iiug.org Received on Sat May 31 1997 - 00:00:00 CDT