Moving Forward with the On Demand Real-time Enterprise

112 Moving Forward with the On Demand Real-time Enterprise

4.1 DB2 Data Warehouse Edition

Business intelligence (BI) is a critical business advantage. Most businesses have

some level of BI capability, but must continue to grow their capabilities to remain

competitive. DB2 Data Warehouse Edition is a powerful set of products that

rapidly enables enterprises to develop robust BI solutions, such as those with

data mining techniques, in-line analytics and an integrated design tool.

The DB2 Data Warehouse Edition (DWE) is a suite of products that combine the

strength of DB2 Universal Database™ (DB2 UDB) with the powerful business

intelligence infrastructure from IBM. DWE provides a comprehensive business

intelligence platform that contains products with functionality to build and deploy

a robust business intelligence solution.

With the DWE, you can build and deploy a data warehousing environment that

includes a highly scalable relational database, integrated information gathered

from numerous heterogeneous data sources, business intelligence analytics,

and front-end financial analysis tools.

With DWE V8.2, there are three editions available to satisfy the requirements of

any particular business enterprise. We now take a look at those.

4.1.1 Data Warehouse Edition V8.2

DWE V8.2 includes DB2, federated data access, data partitioning, integrated

online analytical processing (OLAP), advanced data mining, enhanced extract,

transform, and load (ETL), workload management, and spreadsheet integrated

BI for the desktop. DWE works with and enhances the performance of advanced

desktop OLAP tools such as DB2 OLAP Server™, and others from IBM partners.

Specifically, this version includes:

򐂰 DB2 UDB Enterprise Server Edition, V8.2

򐂰 DB2 UDB Database Partitioning Feature, V8.2

򐂰 DB2 Cube Views™, V8.2

򐂰 DWE Intelligent Miner™ Modeling, Scoring and Visualization, V8.2

򐂰 DB2 Office Connect Enterprise Web Edition, V4.0

򐂰 DB2 Query Patroller, V8.2

򐂰 DB2 Warehouse Manager Standard Edition, V8.2

򐂰 WebSphere Information Integrator Standard Edition, V8.2

Note: This redbook is being published at a time when DWE is evolving. That

is, the existing version is DWE V8.2, but DWE V9.1 has just become available.

As it is a time of transition, we have used both versions at times. Providing

information about both versions offer a degree of continuity in understanding.

Chapter 4. IBM technologies supporting real-time 113

DB2 Data Warehouse Standard Edition, V8.2, is a complete data warehouse

infrastructure package that includes DB2, integrated OLAP, advanced data

mining, ETL, and spreadsheet integrated BI for the desktop. DWE works with

and enhances the performance of advanced desktop OLAP tools such as DB2

OLAP Server and others from IBM partners. Specifically, it includes:

򐂰 DB2 UDB Workgroup Server Unlimited Edition, V8.2

򐂰 DB2 Cube Views, V8.2

򐂰 DB2 Intelligent Miner Modeling, Scoring and Visualization, V8.2

򐂰 DB2 Office Connect Professional Web Edition, V4.0

DB2 Data Warehouse Base Edition, V8.2 provides mid- to large-scale

enterprises with a data warehouse and data mart infrastructure that includes

DB2 and integrated OLAP capability that can support departmental warehouses

or lines of business, or enterprise data warehouses where there is a need for

scalability and performance. This edition includes:

򐂰 DB2 UDB Enterprise Server Edition, V8.2

򐂰 DB2 Cube Views, V8.2

In the following sections, we provide a brief description of the components of the

DB2 data warehouse editions.

DB2 UDB Enterprise Server Edition

DB2 UDB Enterprise Server Edition is a highly scalable, multi-user relational

database management system that can manage data warehousing, online

analytical processing (OLAP), online transaction processing (OLTP), and data

mining.

DB2 UDB Database Partitioning Feature

DB2 UDB Database Partitioning Features allows you to create and manage

partitioned databases. Partitioned database systems can manage high volumes

of data with near-linear scalability while providing benefits such as increased

performance and high availability. The data from a particular database is

partitioned across a number of database instances, as depicted in Figure 4-1 on

page 114.