Data Warehousing Designs for Performance

DB2 Training Abstract

Does your DW and BI system need a refresh or are you wondering about the latest DW and BI techniques? The Data Warehousing Designs for Performance presents the DB2 training that covers design architectures, performance implications and advanced topics. DB2 consultant, Dave Beulke, is experienced building a state of the art data warehouse and business intelligence system.

Learn how to design your DW and BI architecture and your overall infrastructure strategy for maximum effectiveness, performance and overall return on investment during this DB2 training.

This DB2 training class highlights the critical design considerations for analyzing large amounts of data by many concurrent users. It also helps you understand the different performance impacts of database designs, ETL strategies index options, MQTs and the many new technology options. DW and BI strategies have evolved and you need to learn how to design your system for the latest advanced real-time techniques and predictive analytic capabilities.

Through this DB2 training class, you will learn about the best performing architectures, the advanced design options, the latest techniques for maximizing performance and getting the fastest return-on-investment from your data warehouse and business intelligence solution.

Attendees at this class will gain:

  • Knowledge of 22 years of experience building high performance DB2 data warehouses on DB2 LUW, DB2 DPF and DB2 z/OS platforms.
  • Extensive information on data warehouse designs and performance techniques for improving query response time and application performance
  • Detailed instructions on how to build data warehouse Materialized Query Tables-MQTs, partitioning architectures and segmentation strategies for processing billions of rows within your data warehouse.

Length: 1 day


  • System Architects
  • Business Intelligence Architects
  • Data Warehouse Administrators
  • System Administrators
  • DB2 Database Administrators
  • Technology Evaluators


To see a sample syllabus for DB2 Training 2012: Data Warehousing Designs for Performance, click here.