50 TB Data Warehouse Benchmark on IBM System z

An IBM Redbooks publication

Published 27 May 2009

cover image

ISBN-10: 0738432741
ISBN-13: 9780738432748
IBM Form #: SG24-7674-00
(336 pages)

More options

Rate and comment

Authors: Mike Ebbers, Nin Lei, Manoj Agrawal, M. Leticia Cruz, Willie Favero, Juraj Hrapko, Shantan Kethireddy, Cristian Molaro, Frank Neumann, PS Prem


Customers have a strong interest in the scalability of data warehousing solutions on the IBM System z platform using DB2 for z/OS. Because BI environments continue to grow, this IBM Redbooks publication explores the scaling and management of data in sizes beyond 50 TB. We explore the architectural software components that enable us to manage a data warehouse of this magnitude, including the Cognos product set.
The objective of our 50 TB study was to test System z scalability in a BI environment and to develop the best practices of managing large data warehouses. The IBM System z was proven to scale to larger volumes, manage a mixed workload, lower the cost of a BI solution using zIIPs, and increase performance by using hardware compression.

Table of contents

Chapter 1. Introduction
Chapter 2. Data warehousing overview
Chapter 3. Why System z and IBM storage for Data Warehousing
Chapter 4. Configuration
Chapter 5. VLDB build tips and pointers
Chapter 6. Balancing a data warehouse
Chapter 7. Data and index compression
Chapter 8. Reporting and analysis with Cognos
Chapter 9. Scalability
Chapter 10. Using materialized query tables
Chapter 11. Workload management
Chapter 12. Extract, transform, and load
Chapter 13. Summary: observations and conclusions

Follow IBM Redbooks

Follow IBM Redbooks