 |
| 9:00 AM |
|
Opening - Intro |
| |
| 9:15 AM |
Topic: |
Managing Data For Long Retention Periods: Requirements and Challenges
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.
|
| |
Speaker: |
Craig Mullins, NEON Enterprise Software
Craig has more than two decades of experience in all facets of database systems development including developing and teaching DB2 and SQL Server classes, systems analysis and design, database administration and system administrator, and data analysis and modeling. He has worked with DB2 for z/OS and OS/390 since Version 1 and has experience working with Microsoft SQL Server, Sybase and IMS. Craig has worked in multiple industries including manufacturing, banking, commercial software development, education, research, utilities, and consulting.
Craig is the author of the book "DB2 Developer's Guide" published by SAMS Publishing. The book contains more than 1500 pages of in-depth technical information on DB2 for z/OS and OS/390 updated through DB2 Version 8.
Craig is also the author of "Database Administration: The Complete Guide to Practices and Procedures", published by Addison Wesley. This book offers the industry's only comprehensive guide to heterogeneous database administration. |
| |
Handout |
Download to View (PDF format - size: 370KB)
Download to Print 2-up (PDF format - size: 0KB) |
| |
| 10:15 AM |
Topic: |
Null and Void? Dealing with Nulls in DB2
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.
- What is a Null?
- How DB2 Implements Nulls
- Nulls in General Practice
- Some of the Problems with Nulls
- How to Use/Avoid Nulls
|
| |
Speaker: |
Craig Mullins, NEON Enterprise Software |
| |
Handout |
Download to View (PDF format - size: 600KB)
Download to Print 2-up (PDF format - size: 0KB) |
| |
| 12:00 PM |
|
Lunch |
| 1:00 PM |
|
Meeting end |
|
