Subject: Database Makeover: Renovate Your Data Model
Start Time: Thursday, January 19, 2011 12:00 PM US Central Time (January 19, 2011 6:00 PM GMT)
End Time: Thursday, January 19, 2011 1:00 PM US Central Time (January 19, 2011 7:00 PM GMT)
Database Makeover: Renovate Your Data Model
You know the concepts of normalization, logical modeling, and physical implementation. But what happens when you’ve inherited a less than perfect data model? You need to renovate while keeping the production system humming. In this session, we’ll talk about how to evaluate an existing model, how to approach design when your system is up and running and how to incrementally apply database design changes in a fast-moving environment. Every database, even ones consisting of a collection of flat, unrelated tables, has the potential to become a beautiful database. All you need is an eye for design and a strategy to get you there.
Audrey Hammonds is a Database Developer for ista North America in Atlanta, GA and a SQL Server MVP. Fifteen years ago, she volunteered for DBA training to escape COBOL, and never looked back. A firm believer that good fundamentals and solid design can save a database professional’s sanity, she has devoted much of her career to designing (hopefully) elegant databases and straightening up others’ not-so-elegant databases. She blogs at http://datachix.com with her partner in crime, Julie Smith.