Five Physical Database Design Blunders and How to Avoid Them


Presenter: Karen Lopez

Session Details


What’s going on in your physical data model? How many people can or will update it to match the reality of what’s going on in your databases? Who actually decides what goes into the database design?  How do you choose your primary keys? How do you implement them? Are your datatypes the right ones for the data?

In this presentation we discuss five physical data modeling mistakes that cost you dearly: performance snags, development delays, bugs, and professional respect. Data Architects are often tasked to prepare first cut physical data models, yet these skills usually overlap those of DBAs and Developers and this overlap can lead to contention, confusion, and complacency. In this presentation, you’ll learn about the five blunders, how to find them as well as many tips on how to avoid them.


About the Speaker


Karen Lopez is a principal consultant at InfoAdvisors. She specializes in the practical application of data management principles and is an active blogger, speaker and social networker. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at, dm-discuss, and other online communities.



Copyright 2013 by PASS | Terms of Use | Privacy | Login