e-Business Intelligence: Data Mart Solutions with DB2 for Linux on zSeries

An IBM Redbooks publication

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

Profile

Publish Date
28 February 2002

Last Update
12 March 2002


Rating: Not yet rated


Author(s)

ISBN-10
0738423890

ISBN-13
9780738423890

IBM Form Number
SG24-6294-00

Number of pages
164