Book description
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
- Notices
- Preface
- 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
- Implementing OLAP
- DWE OLAP
- Modeling OLAP with OLAP Center
-
Modeling OLAP with DWE Design Studio
- Database Explorer
- Properties view
- Data Project Explorer view
- Creating the CVSAMPLE sample database
- Preparing a DB2 UDB database for DWE OLAP
- Creating a new data project
- Creating a new physical data model
- Quick Start Wizard
- Defining cube models
- Defining the fact table and measures
- Defining dimensions
- Defining joins
- Defining attributes
- Defining levels
- Defining hierarchies
- Defining cubes
- Analyze OLAP objects for validity
- Deploying objects to DB2 UDB databases
- DWE OLAP optimization cycle
- Metadata exchange
-
Chapter 6: Data movement and transformation
- DWE SQL Warehousing Tool (SQW)
-
Developing data flows
- Defining a data flow
- Data flow editor
- Data flow operators (1/9)
- Data flow operators (2/9)
- Data flow operators (3/9)
- Data flow operators (4/9)
- Data flow operators (5/9)
- Data flow operators (6/9)
- Data flow operators (7/9)
- Data flow operators (8/9)
- Data flow operators (9/9)
- Subflows
- Validation and code generation
- Testing and debugging a data flow
- A complete data flow
- Developing control flows
- Variables in data flows and control flows
- Preparing for deployment
- Integrating with IBM WebSphere DataStage
-
Chapter 7: DWE and data mining
- Data mining overview
- The data-mining process
- Embedded data mining
- DWE data-mining components
-
Data mining in the DWE Design Studio
- Mining flows
- Database enablement
- Data exploration (1/2)
- Data exploration (2/2)
- Data mining operators (1/3)
- Data mining operators (2/3)
- Data mining operators (3/3)
- Building a mining flow (1/3)
- Building a mining flow (2/3)
- Building a mining flow (3/3)
- Validating and executing a mining flow
- Visualizing models and test results (1/4)
- Visualizing models and test results (2/4)
- Visualizing models and test results (3/4)
- Visualizing models and test results (4/4)
- Scoring with other PMML models
- Managing data mining models
- Chapter 8: InLine Analytic Applications
-
Chapter 9: Deploying and managing DWE solutions
- The DWE Administration Console
- Deploying the physical data model
-
DWE SQL Warehousing
- An overview of the SQL Warehousing components
- Runtime architecture of DWE SQL Warehousing (1/3)
- Runtime architecture of DWE SQL Warehousing (2/3)
- Runtime architecture of DWE SQL Warehousing (3/3)
- Managing warehouse resources
- Deploying and managing warehouse applications (1/2)
- Deploying and managing warehouse applications (2/2)
- Warehouse processes (1/4)
- Warehouse processes (2/4)
- Warehouse processes (3/4)
- Warehouse processes (4/4)
- Warehousing diagnostics (1/2)
- Warehousing diagnostics (2/2)
- Managing the OLAP functionality
- Data mining
- Managing DB2 Alphablox within DWE
- 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
- Glossary (1/2)
- Glossary (2/2)
- Abbreviations and acronyms
- Related publications
- Index (1/3)
- Index (2/3)
- Index (3/3)
- Back cover
Product information
- Title: Leveraging DB2 Data Warehouse Edition for Business Intelligence
- Author(s):
- Release date: November 2006
- Publisher(s): IBM Redbooks
- ISBN: None
You might also like
book
Data Warehouse Technologien
Dieses Lehrbuch behandelt Konzepte und Techniken von Data-Warehouse-Systemen, die eine wesentliche Komponente in betrieblichen Entscheidungsprozessen darstellen. …
book
The Microsoft® Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft® Business Intelligence Toolset, Second Edition
Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse …
book
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
IBM® InfoSphere® Warehouse is the IBM flagship data warehouse platform for departmental data marts and enterprise …
book
Business Intelligence For Dummies®
You're intelligent, right? So you've already figured out that Business Intelligence can be pretty valuable in …