From: Curt Sampson

To: Editor

Date: 14 Jun 2005

 

It just occurred to me that I find myself using various patterns over and over again in different RDBMS schemas, and analyzing the tradeoffs of doing things one way over another in various circumstances. This is a classic meta-pattern for wanting some design patterns to document these ways of doing things. See: http://www.c2.com/cgi/wiki?DesignPatterns

 

Do you know of any web pages or books with RDBMS design patterns. I did a web search, and all I got was a sponsored link to mysql.com, which was pretty depressing.

 

Anyway, any leads would be appreciated. If there's nothing, perhaps a friend and I may try to document some.

 

 

From: Fabian Pascal

To: Curt Sampson

 

Not familiar with the subject, can't say anything without some concrete examples; the fact that they don't exist raises a question about the idea. This sounds similar to universal data models, which I debunked in one of my tdan.com columns. Some examples may help.

 

Besides, anything associated with object-orientation that's not about programming (read: application development) is highly suspicious and questionable. OO people are confused and fuzzy, no rigor.

 

 

Posted 8/26/05