Re: Informix Data Warehouses

Naomi Walker <naomi@anasazi.com> wrote in article <6nbtb8$c6k$1@orthanc.anasazi.com>... > > > We have been an Informix OLTP shop for many years, and are now in the > process of deciding on a database engine for our data warehouse (on a > Sun E10k). I have heard through the grapevine that there are > considerable problems with Informix that cause data to be lost, and > problems with its general administration (like lots of broken indicies). > > Is anyone out there running a data warehouse using Informix care to offer > me some feedback? I'm not sure where your grapevine information is comming from or what version(s) of Informix it may be refering to, but we have several clients running both datawarehousing and OLTP applications (somtimes on the same machine/instance of Informix -- not a good idea for performance, but it works) without experiencing any of the problems you mention above. The Informix versions involved are generally ODS/IDS 7.1x and greater. There are many well documented cases of Informix being used on multi-gigabyte and tera-byte plus datawarehouses with record setting performance. From a purely technical stand point, Informix is very solid choice for a datawarehouse. Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com