DB2 Data Warehouse Center

 <  Day Day Up  >  

graphics/v7_icon.gif

As of V7, DB2 comes with a new data warehousing management tool called the DB2 Data Warehouse Center. Integrated into DB2 Control Center, the Data Warehouse Center can be used to design data warehouses, register and access data sources, define data extraction and transformation processes, populate data warehouses, automate and monitor Data Warehouse Center operations, and manage and exchange metadata using a DB2-based metadata store (see Figure 45.6).


Figure 45.6. DB2 Data Warehouse Control Center.
graphics/45fig06.gif

The DB2 Data Warehouse Manager makes it easier to use DB2 for data warehousing and business intelligence applications. Some of the predominant capabilities provided by DB2 Data Warehouse Manager include

  • The capability to control and govern 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, and regression

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

Data extraction from DB2, ODBC, and OLE DB data sources can be controlled using the Data Warehouse Center. ODBC drivers for Informix, Oracle, Microsoft SQL Server, and Sybase are included with the Data Warehouse Center. Of course, when used in combination with IBM's DataJoiner data can be extracted from many additional data sources (such as NCR Teradata, IMS, and VSAM).

In short, it can be significantly easier for technicians to deploy useful data warehouses on DB2 using the Data Warehouse Manager tool.

Other IBM Data Warehousing Solutions

IBM offers many other data warehousing products that work with DB2 for z/OS and facilitate the creation, management, and use of DB2 as a platform for data warehouses, data marts, and data mining.

One of IBM's main add-on products for DB2 data warehouse development is the DB2 Warehouse Manager, which extends the capabilities of Data Warehouse Center. Of course, products other than the basic Data Warehouse Center are not provided free-of-charge; they must be purchased at an additional cost from IBM.

Other IBM data warehousing products include

  • DB2 DataPropagator , or DPROP for short, which is used to populate and update data warehouse information. It does so by capturing data changes from the DB2 logs and applying those changes to a DB2-managed data warehouse.

  • DB2 OLAP Server , which provides financial, mathematical, and statistical functions and runs as an analytical engine in the middle tier of a three- tier client/server configuration.

  • DB2 Intelligent Miner Scoring , which enables in-house applications and third-party tools to use simple SQL statements to invoke a data mining model stored in a DB2 database.

  • DB2 Intelligent Miner for Data , which provides data mining algorithms, data visualization capabilities, and can be used to develop models for deployment into DB2 Intelligent Miner Scoring.

  • DB2 Intelligent Miner for Text , which provides the capability to extract, index, analyze, and categorize information from text sources, such as documents and Web pages.

IBM also partners with providers of query and reporting tools for business intelligence, as well as offering its own QMF for developing data warehouse queries. For a comprehensive overview of the data warehousing facilities offered by IBM, I recommend that you read Ralph Michael L. Gonzales' book, IBM Data Warehousing (2003, John Wiley & Sons, ISBN 0-471-13305-1).

 <  Day Day Up  >  


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net