Business Intelligence Enhancements

The final broad category of DB2 V7 enhancements is to better enable creation, management, and access of DB2 data warehouses built on the mainframe. DB2 V7 supports a new management tool called the Data Warehouse Manager.

The DB2 Data Warehouse Manager makes it easier to use DB2 for data warehousing and business intelligence applications. It is integrated with DB2 Control Center. The predominant capabilities provided by DB2 Data Warehouse Manager include

• The ability to control and govern data warehouse queries

• Help for data cleansing, generating key columns , generating period tables, and inverting and pivoting tables

• Statistical transformers for business intelligence operations, such as subtotals, rollups, cubes, moving averages, regression, and so on

• Data replication to allow heterogeneous data movement between data warehouse sources and targets

The DB2 Data Warehouse Manager will make it significantly easier for technicians to deploy useful data warehouses using DB2 as the data store.