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,AdvancedOBJECTIVES: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 designSee several types of very common design flaws, how to correct them, their impacts, and to know when a bad design can be goodAppreciate 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 usefulTo see some real world examples for DB2 9 enhancements and how they impacted the database and applications.