e-Business Intelligence: Data Mart Solutions with DB2 for Linux on zSeries
An IBM Redbooks publication
Note: This is publication is now archived. For reference only.
Abstract
This IBM Redbooks publication explains the benefits of Business Intelligence solutions using DB2 for Linux on zSeries. We discuss several studies done at IBM zSeries Teraplex Integration Center to demonstrate how the latest features of the zSeries hardware and z/VM 4.2 operating environment extend the value proposition for consolidating data marts on DB2 for Linux for zSeries.
The book describes fast data transfer using HiperSocket connections, investigates scalability and performance issues in the context of data mart population, data mart refresh, data mart joins, intelligent resource management of zSeries under z/VM, and application deployment. We evaluate DB2 V7 latest utilities and DB2 federated database distributed queries.
The book also includes functional tests of OLAP tools such as Dimensional Insight.
Table of Contents
Chapter 1. Introducing BI solutions using Linux on zSeries
Chapter 2. Test environment infrastructure
Chapter 3. Test scenarios and measurement methodology
Chapter 4. Data population
Chapter 5. Data refresh
Chapter 6. Distributed data mart access
Chapter 7. z/VM resource allocation across Linux guests
Chapter 8. BI solutions for Linux on zSeries
Appendix A. Linux guests on z/VM
Appendix B. DB2 for Linux scripts to create the data mart
Appendix C. Networking definitions
Appendix D. Federated database setup
Appendix E. Data population scripts
Appendix F. Data refresh scripts
Appendix G. Distributed request scripts
Appendix H. Dimensional Insight - Atlantis Installation