Watching TV, I see Jeff Jonas from IBM talking about corporations looking at snapshots versus continuous flows of data. Reading various industry magazines, I understand more corporations are looking to build business intelligence and data warehouse systems to gain competitive advantage. . . . → Read More: A DB2 Business Intelligence Data Warehouse That Provides Value
Turbo-Charged DB2 Data Warehousing
2004 DB2 Magazine article shows how DB2 8 supports DB2 data warehousing with a specialized DB2 materialized query table (DB2 MQT), DB2 CTE, and DB2 partitioning enhancements.
Autonomic DB2 MQTs in DB2 8
2005 DB2 Magazine article by DB2 consultant, Dave Beulke, shows how a new form of DB2 table in DB2 8 (DB2 MQT) will improve DB2 performance.
DB2 Materialized Query Tables (MQTs) are really great for DB2 data warehousing situations and also for all types of reporting applications. Combining multiple DB2 MQTs is one technique that is good for providing all types of reporting capabilities and answers. By combining multiple DB2 MQTs, the DB2 SQL optimizer can sometimes automatically rewrite the queries . . . → Read More: Combining Multiple MQTs to Improve SQL Optimization and DB2 Performance for Data Warehousing