Re: Named Mistakes and Questionable Practices
Date: 7 Jun 2006 15:57:56 -0700
David Fetter wrote:
> Has anybody here made a list of canonical mistakes that DB
> practitioners make?
> One example mistake is the One True Lookup Table aka the
> Entity-Attribute-Value table, as in this article:
> <http://www.dbazine.com/ofinterest/oi-articles/celko22>. Doubtless
> people have run across others. Ideally, such references would:
> * Name the mistake,
> * Describe the mistake's implementation, and
> * Show how and under what circumstances it's a mistake, as the above
> article does.
> Thanks in advance for any hints, tips, or pointers :)
In the past, we've called these "stupid database tricks" after Letterman.
Rough consensus of the winner, IIRC, was "we manage integrity in the application!"
Marshall Received on Thu Jun 08 2006 - 00:57:56 CEST