|
|
| |
IBM Redbooks > IBM System z
 |
|
|
Enterprise Data Warehousing with DB2 9 for z/OS
 |
|
|
|
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:
- System z and Linux® on System z
- DB2 9 for z/OS
- InfoSphere™ DataStage® and InfoSphere QualityStage
- WebSphere® QReplication and WebSphere Data Event Publisher
- Cognos® 8 BI
This book provides the readers with an opportunity to look at satisfying the operational needs of the corporate users in addition to the longer term based needs. 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.
This book is dedicated only to the first step on implementing a BI solution and concentrate on the set up of the infrastructure. It does not intend to cover all the aspects of a BI solution. For instance, specific considerations on data sharing, very large databases, data mining, performance and capacity planning are intentionally excluded and will be the topic for future documents. |
|
|
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 8 BI
Chapter 14. Reporting with IBM DataQuant, QMF, and Alphablox
Appendix A. Index compression jobs
Appendix B. Schema definitions
Appendix C. Additional material |
|
|
These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors.
This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.
IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a customer responsibility and depends upon the customer's ability to evaluate and integrate them into the customer's operational environment. |
|
|
|
|
|
|
