Building VLDB for BI Applications on OS/390: Case Study Experiences

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

thumbnail 

Published on February 03, 2000

  1. .PDF (2.5 MB)


Share this page:   

ISBN-10: 0738415359
ISBN-13: 9780738415352
IBM Form #: SG24-5609-00


Authors: Seungrahn Hahn

    menu icon

    Abstract

    This IBM Redbooks publication documents our experiences in building very large databases (VLDBs) for Business Intelligence (BI) applications through case studies with customers’ real-life data, as well as from our work in the laboratory and the Teraplex Center. This book replaces DB2 for OS/390 V5 Terabyte Database: Design and Build Experience, SG24-2072.

    This book describes the general considerations for each area of data warehousing and the approaches for addressing these considerations. Based on the results of case studies, it explains the various methods used and summarizes the pros and cons of each.

    This book is written for anyone who is working on very large databases on OS/390 for Business Intelligence applications, including data warehouse architects, database administrators, performance administrators for data warehouses, storage administrators and system programmers who support data warehouses, and DB2 support teams.

    Some knowledge of data warehouse concepts, DB2 for OS/390 V5 or later, and OS/390 V2.5 or later is assumed.

    Table of Contents

    Chapter 1. Introduction to VLDB

    Chapter 2. Database design for VLDB

    Chapter 3. Data warehouse population

    Chapter 4. VLDB utility maintenance

    Chapter 5. Data mart on S/390

    Chapter 6. End-user access methodologies

    Chapter 7. Workload management in data warehouse environment

    Chapter 8. Scalability

    Chapter 9. S/390 strengths for BI applications

    Appendix A. System settings

    Appendix B. Query information

    Appendix C. Case study test scenario

    Appendix D. Introduction to piping

    Appendix E. Reasons for choosing S/390

     

    Others who read this also read