Components of data warehousing in Db2

Descriptions of key components in data warehousing in Db2

The key components of data warehousing in Db2 are described as follows.

Data warehousing in Db2 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,

Data warehousing in Db2 Administration Console

The data warehousing in Db2 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 data warehousing in Db2 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®

Data warehousing in Db2 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 data warehousing in Db2.

Text Analysis

With data warehousing in Db2, 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.