Central Ohio DB2 User Group
(CODUG)
April 13, 2004 Agenda


Officers
Meeting Schedule
Meeting Minutes
Membership
Links of interest
DB2 Trivia
Hot Tips
Home

Meeting at NiSource - Formerly Columbia Gas
1600 Dublin Rd.* (Map, Directions) Just South of 5th Ave. on Rt. 33
*Lots of free parking.

12:30-1:00 Registration
1:00-1:15 Business Meeting. Announcements.
1:15-2:45 Presentation: DB2 Database Design: From Logical to Physical
Presented by Craig Mullins, BMC Software
Abstract
2:45-3:00 Break - Refreshments will be served.
3:00-4:30 Presentation: An Hour of DB2 Tips and Techniques
Presented by Craig Mullins, BMC Software
Abstract

DB2 Database Design: From Logical to Physical

Properly designed DB2 databases are critical to the usability and performance of the resulting databases and application that use them. This presentation covers the discipline of designing proper relational databases from initial specifications through the conceptual and logical data modeling phase and out to the final physical database structures. In other words - database design from inception to implementation. Topics covered will include:

  • Data Modeling
  • Conceptual and Logical Database Design
  • Critical Input to the Design Process
  • From Logical to Physical Design
  • Physical Database Implementation Issues

About the Speaker  -  Craig Mullins

Craig S. Mullins is a Director of Technology Planning for BMC Software, located in Houston, TX. Craig has extensive experience in the field of database management having worked as an application developer, a DBA, and an instructor with multiple database management systems including DB2, Oracle, and SQL Server. Previously, Craig worked as a Research Director with the Gartner Group covering the field of database administration. Craig is the author of DB2 Developer's Guide, the industry-leading book on DB2 for z/OS and OS/390 (which should be updated for V8 in the second quarter of 2004). He has also written a book titled Database Administration: Practices and Procedures, addressing heterogeneous database administration. Additionally, he is a contributing editor and regular columnist at www.dbazine.com, he writes the monthly DBA Corner column for Database Trends & Application magazine, the z/Data Perspectives column for z/Journal magazine, a regular column called The Buffer Pool for IDUG Solutions Journal, and the quarterly Database Report column for The Data Administration Newsletter. You can contact Craig via his web site at www.craigmullins.com.

An Hour of DB2 Tips and Techniques

This presentation runs the gamut covering tips and techniques on SQL, database design, programming, and more to help you improve your usage of DB2 for z/OS and OS/390. If you work with DB2 in any capacity, there will be something of interest for you in this presentation. Key topics covered include:

  • Performance management
  • SQL and trigger coding tips
  • Database administration effectiveness
  • Database design and implementation
  • ...includes some coverage of DB2 V8 features

About the Speaker  -  Craig Mullins

Craig S. Mullins is a Director of Technology Planning for BMC Software, located in Houston, TX. Craig has extensive experience in the field of database management having worked as an application developer, a DBA, and an instructor with multiple database management systems including DB2, Oracle, and SQL Server. Previously, Craig worked as a Research Director with the Gartner Group covering the field of database administration. Craig is the author of DB2 Developer's Guide, the industry-leading book on DB2 for z/OS and OS/390 (which should be updated for V8 in the second quarter of 2004). He has also written a book titled Database Administration: Practices and Procedures, addressing heterogeneous database administration. Additionally, he is a contributing editor and regular columnist at www.dbazine.com, he writes the monthly DBA Corner column for Database Trends & Application magazine, the z/Data Perspectives column for z/Journal magazine, a regular column called The Buffer Pool for IDUG Solutions Journal, and the quarterly Database Report column for The Data Administration Newsletter. You can contact Craig via his web site at www.craigmullins.com.

Announcements

All in attendance must have either paid in advance or be prepared to pay the dues at the meeting. Please review the Membership page. Our Officer of Dues and Membership is Sharon Hamilton. She can be reached at  membership@codug.org or (614) 854-5219. Contact her with any questions regarding your company's membership status.

Directions

Building is located on the Southeast corner of Dublin Rd. and W. Fifth Ave. Enter the main building at the front door. Check in at the desk in the lobby.

North I: 315 S. to Kinnear/Olentangy, exit right on Kinnear Rd., left (S) on Kenny Rd., right (W) on W. Fifth Ave.,

North II: I-71 S, I-670 W, exit Grandview Ave, right on Grandview, left on Dublin Rd.

North III: Riverside Dr. south, becomes Dublin Rd.

South: I-71 N to 315 N. exit Long St./Dublin Rd. Turn left.

East: I-70 W, to 315 N, exit Long St./Dublin Rd. Turn left.

Airport: I-670 W, exit Grandview Ave., right (N) on Grandview, left on Dublin Rd.

Downtown: W. on Spring St., becomes Dublin Rd.

From the West: I-70 E to Grandview Ave. exit right (N) on Grandview, turn left on Dublin Rd.


 

Created: March 17, 2004 / Updated: March 17, 2004
Send changes and corrections to webmaster@codug.org