DB2 Data Warehouse Edition (DWE) is a suite of products that combines the strength of DB2 Universal Database™ (DB2 UDB) with the powerful business intelligence infrastructure from IBM®. DB2 Data Warehouse Edition provides a comprehensive business intelligence platform with the that tools your enterprise and partners need to deploy and build next generation analytic solutions. 数据挖掘研究院
You can use DWE to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, business intelligence analytics, and front-end analysis tools. DWE integrates core components for warehouse administration, data mining, OLAP and inline analytics and reporting.
- DWE Design Studio, which includes a subset of IBM Rational® Data Architect.
- DWE SQL Warehousing Tool.
- DWE Administration Console.
- DB2 Universal Database™ Enterprise Server Edition, Version 8.2 Fix Pack 3 (Version 8.1 Fix Pack 10), which includes the DB2® Data Partitioning Feature.
- DWE Cube Views™, Version 8.2 Fix Pack 3 (Version 8.1 Fix Pack 10). The OLAP Center in Cube Views is the previous-generation user interface and is included in DWE Version 9.1 to provide continuity for existing customers who can transition to the DWE Design Studio and DWE Administration Console at their convenience.
- DB2 Query Patroller, Version 8.2 Fix Pack 3 (Version 8.1 Fix Pack 10).
- DWE Intelligent Miner™.
- DB2 Alphablox, Version 8.4, and its documentation.
- DWE Version 9.1 documentation, which is combined with the DB2 UDB documentation in an Information Center.
- WebSphere® Application Server Version 6.0.2.
- DB2 Universal Database Enterprise Server Edition, Version 8.2 Fix Pack 3 (Version 8.1 Fix Pack 10)
- DWE Cube Views, Version 8.2 Fix Pack 3 (Version 8.1 Fix Pack 10)
- DWE Design Studio, with plug-ins for Rational Data Architect and Cube Views™ only
- DWE Version 9.1 documentation, which is combined with the DB2 UDB documentation in an Information Center
In Version 9.1, the following components are not included in DWE:
- DB2 Warehouse Manager
- DB2 Information Integrator
- DB2 Office Connect
The following sections provide a general overview of the products that are included in the Enterprise and Standard editions of DWE. 数据挖掘研究院
DWE architecture
DWE has a component-based architecture with client and server pieces. 数据挖掘研究院
DWE components are arranged into three logical groups. Typically you install these groups on three different computers, but you can install them on two computers. For example, you can install the Warehousing Server components and Application Server components on the same computer, or on two different computers. Additionally, you can install the DWE documentation on any computer. The groups are shown in the following figure.
The groups are:
- Data Warehousing Server
- This group includes the server components of DB2® UDB, Query Patroller, Cube Views™, and Intelligent Miner™.
- Application Server
- This group includes WebSphere® Application Server and applications that run on WebSphere. These applications are the DWE Administration Console, runtime services for the DB2 Administration Client, runtime services for the SQL Warehousing Tool, and DB2 Alphablox. The Application Server requires DB2 UDB to be installed in your environment.
- Client
- This group includes the Design Studio, the DB2 Admin Client front-end, the OLAP Center for Cube Views™, and Query Patroller center.
Additionally, you can install the DWE documentation, including the DWE tutorial, with any of these groups.
