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

Martin, what role is platinum playing in this implementation? Are you providing the repositiory or data migration tools? Or is the database vendor driving the project? just curious as to how these projects are coming together. On Tue, 19 Dec 1995 20:21:03 GMT "Martin Kallenbach, aka Kalli" <100732.511@COMPUSERV.COM> wrote: }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. } }Regards, Martin }----------------------------------------------- }kallm@platinum.com or 100732.511@compuserve.com }Opinions are mine etc. }Opinions are mine own, may be not Platinums } ====================================== Chuck Phillips, CFA, Esq. Software Industry Analyst Morgan Stanley & Co., Inc. 1585 Broadway, 14th floor New York, NY 10036 Phone:212-761-4450 (main office) ** or 1-800-MR CHUCK (roams with me) Fax: 212-761-9659 compuserve:73766,1630 Pager: 1-800-759-8352 pin# 1998158 (on 24x7) internet:chasp@ms.com