|
Data Modeling for 24x7 Availability
Presentor: James Surber (http://www.dstsystems.com/)
Slides: click
here  
Description:
There are database design choices and
operational techniques that can reduce outages. We discuss designing
tables and structures with 24x7 in mind with the following concepts: rule
base table structures, segregate tables to maintain table information
(partition keys etc.), flexible code table design, and referential Integrity
and constraints.
- Tablespace and Table Design
- Flexible code tables
- Rule Base Tables
- Indexes
- Views with UNION ALL
- Constraints and RI
- Partitioning
- Views and Aliases
- Triggers, UDF and Stored Procedures
(from the DAMA side)
- Misc structures for 24x7
- Questions and Answers
James Surber has been a database administrator
on several DBMS's for over 15 years. He is currently a Senior DBA at DST Systems, Inc, a leading data
process for the financial services
industry. He currently works
on DB2 OS390, DB2 Windows and Unix in a 24x7
environment. James has been
in the computer industry for over 25 years
where he has taught computers, been a programmer, network administrator,
project lead and database administrator. Presented “F13: Maintaining Near 24x7
During Table Changes” and "Designing Tables, Structures and Coding for 24x7"
at IDUG 2002 and 2004 North America He presented both of the presentations
at the IDUG 2003 and 2004 EU (Europe in Nice, France and Lisbon, Portigal)
as was choosen BEST USER SPEAKER in Nice.
- IBM DB2 Certified § Specialist
- DB2 UDB V6/7 User § Solutions Expert
- DB2 V7.1 Database Administrator for
OS/390 § Solutions Expert
- DB2 UDB V7.1 Database Administrator
for UNIX, Windows and OS/2
Details
When:
Noon - 4:00 p.m.
Thursday, July 15th 2004
Where:
'A' Building (main)
American Family Insurance
6000 American Parkway
Madison, Wisconsin 53783-0001
Phone: (608) 249-2111
http://www.amfam.com/
Click
here for MapQuest.
Agenda:
Noon - 1:00 p.m.
- Lunch
- Education Center Cafeteria
- On your own
- $8.95 all you can eat buffet includes sandwich bar, soup, salad,
main entree as well as a beverage and dessert.
1:00 p.m. - 4:00 p.m.
- Presentation in Auditorium
|
