Re: Named Mistakes and Questionable Practices
Date: 8 Jun 2006 08:10:34 -0700
> David Fetter wrote:
> > Folks,
> > 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
> Rough consensus of the winner, IIRC, was "we manage integrity
> in the application!"
After reading some of the threads on the link all I can say is "OH, my God!" (No offense to anyone)
- Mark D Powell --