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.

thumbnail 

Published on February 28, 2002, updated March 12, 2002

  1. .PDF (2.3 MB)


Share this page:   

ISBN-10: 0738423890
ISBN-13: 9780738423890
IBM Form #: SG24-6294-00


Authors: Viviane Anavi-Chaput

    menu icon

    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

     

    Others who read this also read