By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,526 Members | 2,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,526 IT Pros & Developers. It's quick & easy.

Database Design Patterns?

P: n/a
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
Apr 2 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Apr 2, 1:00 pm, aj <ron...@mcdonalds.comwrote:
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

Apr 3 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.