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

hecker@panix.com (Jared P. Hecker) wrote: >What is so impressive about that? I have personally loaded 45GB/hr into an >SMP Oracle RDBMS. On an MPP box - e.g., an RS/6000 SP - I think I can >triple that. Take a look at the dbIntellect paper. They worked with Oracle 7.1 and found that it took some 120 hours to load and index a 200GB database. >I agree with Dave here as far as keeping distributed joins in the engine >wherever possible. There is, however, another solution - stick an >applications server layer in the middle to act as a traffic cop and client >to the two DB servers. This would a) minimize the load on the DB server >(minimizing pinging), b) permit greater scalability among the user base, >c) permit integration of additional data sources with minimal >maintenance and d) implement a simplistic failover mechanism. If you >happen to use an RS/6000 as the platform, even with something as >constricting as CICS/6000 as the tp monitor (this is not a >recommendation, just an example), you will get quite speedy connections >to both DB/2 and the RDBMS of choice, since both connections will be more >or less 'native'. The problem with the App Server, CICS/6000 or any other TP Monitor/RPC approach is that most ad-hoc tools do not generate CICS calls. Most DSS applications use off the shelf query tools. Some are even starting to use the Web. I don't think you can expect end-users to write CICS/COBOL applications!