Articles & Content

Archives

Terror by Design (G10)

Topic: 2011 NA

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2011-5-5 (09:45 AM - 10:45 AM)
SPEAKERS: Jorg Lueke (Blue Cross Blue Shield Minnesota)

I am rushing through LaGuardia airport my intestines threatening to gave way to the parasites inside. I need to find a bathroom but I also need to eat to settle my stomach. I pass a chili dog stand and things quickly become worse. This event was one of the many caused by terrible design. This presentation will talk about the types of design problems a DBA is likely to encounter, the reasons these designs get chosen and all the horrible consequences along with some remedies. The general topics covered will include normalization, clustering, bufferpools, parallel processing, performance versus availability, hierarchical models in relational tables and the importance of understanding the application. In addition the presentation will touch on how new features can be used for good and evil, these include partition by growth, RRF, index compression, adding and rotating partitions. To top it off you'll see real numbers before and after the designs of terror.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Gain a deeper understanding of precisely how database design and application design tie into database performance and availability through the use if real word examples and to show the interplay between high performance design and high availability design

See several types of very common design flaws, how to correct them, their impacts, and to know when a bad design can be good

Appreciate how configurable physical design parameters such as buffer placement, clustering, and partitioning can impact performance and availability.

Understand the types of normalization and when they can be useful

To see some real world examples for DB2 9 enhancements and how they impacted the database and applications.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.