Skip to main content

Leveraging DB2 Data Warehouse Edition for Business Intelligence

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 29 November 2006, updated 10 September 2007

  1. .PDF (35.3 MB)

Share this page:   

ISBN-10: 0738496685
ISBN-13: 9780738496689
IBM Form #: SG24-7274-00

Authors: Chuck Ballard, Angus Beaton, David Chiou, Janardhan Chodagam, Meridee Lowry, Andrew Perkins, Richard T. Phillips and John Rollings

    menu icon


    In this IBM Redbooks publication we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business intelligence infrastructure for analytics and Web-based applications, and best practices for deployment. DB2 DWE integrates core components for data warehouse construction and administration, data mining, OLAP, and InLine Analytics and reporting. It extends the DB2 data warehouse with design-side tooling and runtime infrastructure for OLAP, data mining, InLine Analytics, and intra-warehouse data movement and transformation, on a common platform based on DB2 and WebSphere. The platform pillars are based on the technology of DB2, Rational Data Architect (for physical data modeling only), the SQL Warehousing Tool, Intelligent Miner, DB2 Cube Views, and Alphablox. DWE includes an Eclipse-based design environment, DWE Design Studio, that integrates the DWE products (with the exception of Alphablox and Query Patroller) with a common framework and user interface. The new SQL Warehousing Tool enables visual design of intra-warehouse, table-to-table data flows and control flows using generated SQL. DB2 Alphablox is the tool for developing custom applications with embedded analytics-based visual components. DWE enables faster time-to-value for enterprise analytics, while limiting the number of vendors, tools, skill sets and licenses required.

    Table of Contents

    Chapter 1. Information warehousing for business insight

    Chapter 2. DB2 DWE - A technical overview

    Chapter 3. The DB2 DWE Design Studio

    Chapter 4. Developing the physical data model

    Chapter 5. Enabling OLAP in DB2 UDB

    Chapter 6. Data movement and transformation

    Chapter 7. DWE and data mining

    Chapter 8. InLine Analytic Applications

    Chapter 9. Deploying and managing DWE solutions

    Chapter 10. DB2 UDB Data Warehouse features

    Chapter 11. Managing SQL queries with DWE

    Appendix A. IBM data warehousing - complementary software

    Appendix B. DWE Admin - Problem Determination Example


    Others who read this also read