Redbook Enterprise Data Warehousing with DB2 9 for z/OS
Hi DB2 User,
IBM just published a draft version of a new Redbook, "Enterprise Data Warehousing with DB2 9 for z/OS, SG24-7637-00 " :
Enterprises look more and more to business intelligence to gain a competitive edge. Today’s business intelligence systems incorporate large data warehouses that are consolidated with near-real-time operational data stores (ODS) and continuously updated from multiple sources. An increasing number of users in the enterprise want to access the data warehouse with business intelligence applications with real-time needs.
Due to the inherent characteristics of security, availability, performance, mixed workload management, and the growing portfolio of data warehousing tools and functions provided by IBM, there is a renewed interest in the ability to implement a data warehouse solution on DB2 for z/OS and System z.
In this IBM Redbooks publication we focus on today’s software components on System z and show how they can be leveraged to realize the infrastructure for a full data warehouse solution.
Using a retail business scenario loosely based on the TPC-H benchmark, we guide you through the warehouse implementation steps highlighting the available methods, techniques, and technologies for the deployment of this solution.
This book can be used by business decision makers, architects, implementors, DBAs, and data acquisition specialists to gain a better understanding of how a data warehouse can be designed, implemented and used
Table of Contents
Part 1. Data warehouse today
Chapter 1. Definitions
Chapter 2. Evolution of business intelligence
Chapter 3. Why data warehouse on z
Chapter 4. The architecture for the BI solution on System z
Part 2. Design and implementation of our warehouse scenario
Chapter 5. The business scenario and data models
Chapter 6. The system environment
Chapter 7. Functions in DB2 for z/OS for data warehouse
Chapter 8. QReplication and Event Publishing
Chapter 9. Setting up ETL components for data warehouse
Chapter 10. Full load using DataStage
Chapter 11. Incremental update with DataStage
Chapter 12. An Operational BI implementation
Chapter 13. Reporting and Analysis with Cognos BI
Chapter 14. Reporting with IBM DataQuant, QMF, and Alphablox
Part 3. Appendixes
Appendix A. Index compression jobs
Appendix B. Schema definitions
Appendix C. Additional material