Database Design Patterns?

[aj]

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
simple normalization, but higher-level stuff.

Anyone have pointers to any books, papers, ideas, etc??

TIA

aj

[jefftyzzer]

On Apr 2, 1:00 pm, aj <[e-mail]:

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
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 domain-
oriented 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 columns of Terry Moriarty's "Metaprise" column
in Intelligent Enterpise magazine: http://www.intelligententerprise.com...etaprise.jhtml
5. Some of Scott Ambler's database refactoring work might also apply
here.

--Jeff