50 TB Data Warehouse Benchmark on IBM System z
An IBM Redbooks publication
Note: This is publication is now archived. For reference only.
Published on 27 May 2009
Order hardcopy
Share this page:
ISBN-10: 0738432741
ISBN-13: 9780738432748
IBM Form #: SG24-7674-00
Authors: Mike Ebbers, Nin Lei, Manoj Agrawal, M. Leticia Cruz, Willie Favero, Juraj Hrapko, Shantan Kethireddy, Cristian Molaro, Frank Neumann and PS Prem
Abstract
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