Business Intelligence Data Warehouse Special Interest Group:

Business Intelligence/Data Warehouse Special Interest Group

Workload management in data warehouses

Presenters

Paul McInerney, IBM, DB2 LUW Development
Shelley Perrior, HBC, Data warehouse team lead (Teradata environment)
Sorina Faur, BMO, Data warehouse team lead (DB2 LUW environment)

Abstract

Effective workload management is a key enabler of several data warehouse goals including:

providing freer access to power users to perform ad hoc analysis,
consolidating data marts into a single physical database, and
meeting service level objectives for query response times.

A holistic approach to workload management involves:

using DBMS and OS workload management controls,
using BI platform workload management controls, and
business user management - training, policies, etc.

This presentation examines all these aspects by presenting perspectives of leading data warehouse system DBAs from two companies and from a product developer of workload management product features.

Bios

Paul McInerney is a product developer for DB2 LUW at the IBM Toronto Lab. Experience relevant to workload management includes working with customers to optimize their use of workload management features, writing best practices, and contributing to the development of features including DB2 workload manager (DB2 9.5) and Query Patroller (DB2 version 8).

Shelley Perrior has over 20 years of experience in a broad spectrum of financial, retail, and insurance fields, including 16 years as a DBA with DB2, Oracle and Teradata. She is currently the supervisor of the database admin group at Hudson's Bay Company and the lead for the Teradata Database. Shelley has worked with Teradata since 1998 and is a certified Teradata Master. Shelley has been involved in the implementation on Teradata of the real time Fraud Control application and the new Enterprise Data Warehouse at Hudson's Bay.

Sorina Faur is the Database Development Manager of a team of 12 DBAs responsible for the design, development, implementation and support of Data Warehouse/Datamarts for BMO Financial Group. The Business Intelligence environment varies in size from hundreds of GB to many TB and Sorina's area of expertise includes performance tuning and database design of very large databases.
Paul.

References

Paul McInerney, WLM Methodology
Shelley Perrior, Workload Management: HBC Case Study
Sorina Faur, Workload Management: BMO Financial Group Case Study

Time and Location of Meeting

Meeting Details: Tuesday, January 29, 2008

Location: Northern District Library, room 224BC. This library is located a short block north of the Eglinton and Yonge subway station (just past the Eglinton Centre) at 40 Orchard View Blvd, Toronto. There is parking at several nearby lots.

5:45 pm: Registration for prompt 6:00 pm start
7:30 pm. Expected Finish

No need to pre-register - just show up!

No charge for IRMAC members. Non-members: $20.

Questions please contact

Bill Chadwick at