Re: Terabyte + Data Warehouses Using Informix & SUN...

Lloyd J. Tribley wrote: > > We're looking for your advice, experience, and recommendations. We plan to > develop a data warehouse, decision support system, initially utilizing > medical claims data and then adding a number of smaller external data set. > The question we have is whether or not SUN and Informix can handle a data > warehouse which will start out at about 500+ GB scaling quickly to over 1 > Terabyte and upwards of 3 to 4 Terabytes within a 24 to 36 month time frame > (if it works we're probably exceed this size). It is expected that the > system would start out averaging between 15 to 20 simultaneous users, but > could peak at upwards of 50 to 75 users. It's not unusual with data like > this to require between 7 - 10 table joins. What are the critical technical > and administrative issues to overcome? A SUN/Oracle solution has also been > proposed as an alternate to Informix. Should we be looking at other > solutions? > > I have not been able to locate anyone or any cases of a SUN/Informix data > warehouse of this size. Any case study and organizational references you > have would be appreciated. > > The data warehouse combination I see most frequently cited for data > warehouses this size uses NCR DB Servers and their Teradata DB. > > Pros/Cons? Ideas? Problems to take into consideration? Questions for us to > ask? Recommendations? > > Thanks for your advice and feedback. > > Lloyd... > > -- > Lloyd J. Tribley > tribley@vistech.net If you are going into the terabyte territory, you are better off with Informix XPS 8.2 on either an SP2 or a Sun Ultra cluster. XPS has lot more features and can address memory beyond 2GB, should you require. A 16 node SP2, each node with 1 GB of memory is a great start. OnLine is alright for upto 500GB, you'll start seeing glitches beyond that limit, although somebody from Informix will shoot me for saying so. Just my opinion... Good luck, Arun