Re: 1.5 TB Warehouse: Informix or DB2/MVS?

Peter Nolan <PNOLAN@ozemail.com.au> writes: >rharbus@rharbus (Bob Harbus) wrote: >> >> In <4b76n4$4ei@dub-news-svc-5.compuserve.com>, 100732.511@COMPUSERV.COM (Martin Kallenbach, aka Kalli) writes: >> >Hi, >> >One of my customers is planning to build a 1.5TB Warehouse containing >> >telecommunication data. They want to keep about 700 million 80 byte >> >record per day, summarize this in one month and have (probably) only >> >the last month as history to compare. >> >(1) Has anyone expierience with handling 50 GB added data per day - >> >there won't be much cleansing / reformatting but the data has to be >> >loaded / moved to DB2/MVS and/or Informix? >> >(2) They plan to query that data from about 30 region locations, >> >having "regional" data (50 GB per month each). Which of the three >> >scenarios would be recommended: >> >(a) Have one DB2/MVS copy and remote query access >> >(b) Have (a) and local copies in Informix >> >(c) Have local copies in Informix only >> >Any expieriences with these amount of data would be very welcome! >> >Their information need points very much to OLAP / MDDBs, but even 50GB >> >seems a bit too much for anything else but R-OLAP. >> >> Have you considered DB2/Parallel Edition? >> >> =========================================== >> Bob Harbus DB2 Technical Sales Support >> IBM Software Solutions Lab Toronto >> Internet: bharbus@vnet.ibm.com >> CompuServe: 72662,2565 >> >> >Hi Bob, > with these volumes you would be looking at a large server housing >the vast volume of the transaction level data and also preparing the >aggregated data in multiple fact tables. From there you would distribute >the data to regional servers. IBM has very good technology with Data >Propagator to do the propagation to regional servers for you. >We are testing dpropr now and will be moving to distributed servers >in s subsequent releases.... >Please feel free to mail me directly. >Peter Nolan >Data Warehouse Specialist This looks like something Informix would handle well, also. I'd suggest that you check with the Informix (Burlington, MA) data warehousing expert, JoAnne McMath. (I don't have their phone number handy since I'm home at the moment.) Mike Willett, Storage Computer Corp., http://www.storage.com/