Agenda - PITT DUG - November 14th - Sign Up Now!

Chris Straub

Agenda - PITT DUG - November 14th - Sign Up Now!

Greetings DB2 Pitt Dug-gers! Here's the agenda for the next Pitt DUG.

Please make note, that meeting will be at the Blattner-Brunner Building.

Pittsburgh Regional DB2 User Group
Date: Tuesday, November 14, 2006
Place: Blattner-Brunner Building (Multi-purpose room on the 8th
Cost: FREE
Reservations: Email or call: [login to unmask email]
[login to unmask email]

**** The Blattner-Brunner building is located at 11 Stanwix Street just
down the road from Highmark.

*Agenda for November 14, 2006
8:30 – 9:00 Welcome/Breakfast, Compliments of IBM

9:00 - 10:15 Null and Void? Dealing with Nulls in DB2
Presenter: Craig Mullins, Neon Enterprise Software

Nulls are one of the most controversial aspects of SQL database systems. On
the one hand they seem to be useful as means to record missing information;
on the other hand, they introduce three-valued logic and other
difficulties into our applications. This presentation will delve into the
various aspects of nulls, show some of the problems presented by
nulls, and give advice on how best to use/avoid them.

10:15 - 10:30 Break

10:30 – 11:45 Managing Data For Long Retention Periods: Requirements
and Challenges
Presenter: Craig Mullins, Neon Enterprise Software

Several events in recent years have changed the requirements for retaining
data from operational databases to long periods of time. Required retention
periods have ballooned to many years, and in some cases, to many decades.
This coupled with the rapid rise in data volumes and the importance of
providing archived data on demand many years after it is created, has
surfaced the need for companies to build a solid practice for archiving and
managing business data from their online operational databases. The
presentation covers the basics of an archiving methodology and a number of
topics that require special consideration in building a database archiving
practice. Topics covered are application independence, metadata
independence, data authenticity, change management, storage management, and
access control.

11:45 – 12:00 Closing