Components of DB2 Warehouse

Descriptions of key DB2 Warehouse components

The key components of DB2 Warehouse are described as follows.

DB2 Warehouse Design Studio

The Design Studio provides a common design environment for creating physical data models, OLAP cubes, SQL data flows, and control flows. The Design Studio is built on the Eclipse Workbench, which is a development environment that you can customize,

DB2 Warehouse Administration Console

The DB2 Warehouse Administration Console is a web application from which you can deploy and manage applications, control flows, database resources, and system resources. You can do the following types of tasks in the Administration Console:

Common configuration

Create and manage database and system resources, including driver definitions, log files, and notifications.

SQL warehousing

Run and monitor data warehousing applications and view deployment histories and execution statistics.

Mining

Run and monitor data mining applications.

Cognos Dynamic Cubes

You can use DB2 Warehouse with Cognos Dynamic Cubes to leverage substantial in-memory data assets as well as aggregate awareness in order to achieve high performance interactive analysis & reporting over terabytes of warehouse data.

For more information, see the IBM Cognos Dynamic Cubes FAQ webpage.

Cognos® 10 Business Intelligence For Reporting

IBM® Cognos 10 Business Intelligence For Reporting lets organizations implement a rich set of business intelligence capabilities. It is an ideal solution for companies that want to consolidate data marts, information silos, and business analytics to deliver a single version of the truth to all users. It allows easy creation of reports and quick analysis of data from the data warehouse.

IBM Optim™ Performance Manager Extended Edition

Optim Performance Manager Extended Edition is a follow on to DB2 Performance Expert. Optim Performance Manager Extended Edition helps optimize the performance and availability of mission critical databases and applications.

Intelligent Miner®

DB2 Warehouse includes the following mining features:

• Intelligent Miner Easy Mining
• Intelligent Miner Modeling
• Intelligent Miner Scoring

These features provide rapid enablement of data mining analysis in Data Warehousing, eCommerce, or traditional Online Transaction Processing (OLTP) application programs. While previously available as separately priced products, they are now available as an integrated part of DB2 Warehouse.

Text Analysis

With DB2 Warehouse, you can create business insight from unstructured information. You can extract information from text columns in your data warehouse then use the extracted information in reports, multidimensional analysis, or as input for data mining.