Patterns For Relational Database Design
I'm looking for patterns (no matter if web-site or a book) for how to design a relational database. Some "patterns" (like normal forms) are well known and practiced but I'm looking for patterns that go beyond normalisation. Especially in terms of designing a database that's easy to map to OO.
So do you want how to model data such that it produces the 'correct' database?
There's a great .NET show where Terry walks you through how to do this with Visio - Enterprise Architect. One of my favorite .NET shows.
ORM is a very interesting (and with Visio surely applyable - been there, done that :)) technique but what I'm searching for something more like GoF design patterns format for "low level" relational database design (with consideration of later O/R mapping and DAL's).
(Ahhh... those pesky typos and grammar errors... sorry.)
You mean something like this:
Ummm, the pattern is the data. That's the point of ORM, just the facts ma'am, oh and the constraints...
Although not a pattern book per se, Designing Quality Databases with IDEF1X Information Models is an excellent relational DB design book. Someone well-versed in pattern-based programming should be able to read the text and translate the ideas into patterns for your problem domain.
What you are looking for is david hay's data model patterns.
Karel van der Walt
Brian, I feel your pain.
Fog Creek Home