Baltimore / Washington DB2 Users Group
Archived
BWDB2UG LUW Quarterly Meeting

When? Wednesday, March 6, 2009, 10:00AM-2:00PM (registration at 9:30)

Where? IBM TEC, 8401 Greensboro Drive, McLean, VA, 22102, 703-761- 4426

Meeting Fees:
This session is free for all.

Registration:
Registration is required for attendance as the meeting is in a secure IBM facility. Please email kim.may@thefillmoregroup with your name, company name, and phone number, if you plan to attend.

Meeting Schedule:

  9:30- 10:30 Registration
 
  10:00 - 11:30 An In-depth Look at DB2 Active Data Features - Constraints and Triggers
 
 

A DB2 Active Data Feature allows an SQL statement to invoke an action that is not explicitly specified by the SQL statement. Such features are generally used to verify data integrity and to trigger general-purpose automatic actions. We will take a look at the different types of DB2 constraints (check constraints, foreign key constraints, generated columns, etc.) and triggers, examples of how they are used in business contexts, and their pros and cons. We will also explore how constraints can be exploited by the DB2 Optimizer for semantic query optimization.

 
  11:30- 12:00 Customer presentation: DB2 Tuning
   
  12:00 - 12:30 Break & Lunch Served (A pizza lunch will be provided by The Fillmore Group.)
 
  12:30 - 2:00 A First Look at DB2 Materialized Query Tables (MQT)
 
 

In a data warehouse environment, users often issue queries repetitively against large volumes of data with minor variations in query predicates. Materialized Query Tables (MQT) can be used to improve performance for such queries. We will introduce the general concepts of MQTs, including the different types of MQTs and their design and maintenance considerations. We will also go through some examples of how MQTs can be used to improve performance of complex queries.

 

To be added to our email notification list for future events, please fill out our contact list form.

For more information, contact one of the Board Members or Volunteers.

(Board members and volunteers are employed by various companies. Their work and efforts to the BWDB2UG are strictly on a volunteer basis. They will respond to phone calls by the next business day, if possible. If you do not get a response, please contact another board member.)

Speaker Backgrounds
Petrus Chan is an advisory software developer specializing in the DB2 SQL Compiler for DB2 on LUW at the IBM Toronto Software Lab. Petrus has over 10 years of experience in the SQL Compiler area, with expertise in DB2 active data features such as constraints, triggers and materialized query tables. Petrus is a graduate of the University of Waterloo, where he earned a B.S. in Math and his Master's in Math and Computer Science in 1997. Petrus holds four data systems and methodologies patents.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.