Re: Database Design Patterns?

On Apr 2, 1:01 pm, aj <ron..._at_mcdonalds.com> wrote:
> I'm sure some (maybe many) of the folks in the group are familiar
> w/ the Gamma/Helm/Johnson/Vlissides Design Patterns book (often
> call Gang of Four or GoF).
>
> My question: Is there any such thing for databases? I don't mean
> simple normalization, but higher-level stuff.
>
> Anyone have pointers to any books, papers, ideas, etc??
>
> TIA
>
> aj

AJ:

The closest you'll probably get in the database world are domainoriented  analysis patterns, as opposed to the more abstract GoF stuff. Check out the following resources:

1. _Data Model Patterns: Conventions of Thought_, by Dave Hay
2. _Data Model Patterns: A Metadata Map_, also by Hay (may be an update to 1)
3. The Data Model Resource Book, Vol. 1_, by Silverston, et al.
4. Check out the back-issue columns of Terry Moriarty's "Metaprise" column in Intelligent Enterpise magazine: http://www.intelligententerprise.com/ports/search_metaprise.jhtml
5. Some of Scott Ambler's database refactoring work might also apply here.

--Jeff Received on Tue Apr 03 2007 - 19:53:35 CDT