About the Presentation

Database Design Patterns

Beyond database design fundamentals (for example, Normalization) lies the area where you have to create "real" solutions. In this session, I will cover a good number of patterns that we commonly find useful to try to apply to the problem of building a database solution. Ideas like generalization, subclassing, single table domain tables, optional data, and more will be discussed, some of them good, some not so good (don't assume which will be which), but all that are common and/or useful for your database implementations.

Session Level: Intermediate

Download Database Design Patterns .zip

Louis Davidson

I have been in the IT industry for 16 years as a corporate database developer and architect. I have been a Microsoft MVP for 5 years and have written 4 books on database design. Currently I am a Senior Data Architect for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee. I have a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics.

Contact URL: http://drsql.org