Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed2.scan-plus.net!news.germany.com!postnews.google.com!e65g2000hsc.googlegroups.com!not-for-mail
From: "jefftyzzer" <jefftyzzer@sbcglobal.net>
Newsgroups: comp.databases.theory
Subject: Re: Database Design Patterns?
Date: 3 Apr 2007 17:53:35 -0700
Organization: http://groups.google.com
Lines: 32
Message-ID: <1175648015.818521.260000@e65g2000hsc.googlegroups.com>
References: <1312o8q8p0fqf5@news.supernews.com>
NNTP-Posting-Host: 64.167.225.2
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1175648017 26828 127.0.0.1 (4 Apr 2007 00:53:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 4 Apr 2007 00:53:37 +0000 (UTC)
In-Reply-To: <1312o8q8p0fqf5@news.supernews.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 3.0.04506.30),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: e65g2000hsc.googlegroups.com; posting-host=64.167.225.2;
   posting-account=IHVlng0AAADL2EAqJdO8r4WgRxqMyTs1
Xref: news.f.de.plusline.net comp.databases.theory:43219

On Apr 2, 1:01 pm, aj <ron...@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 domain-
oriented 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