Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Named Mistakes and Questionable Practices

Re: Named Mistakes and Questionable Practices

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 10 Jun 2006 10:48:51 -0700
Message-ID: <1149961731.443535.323440@m38g2000cwc.googlegroups.com>


>> Has anybody here made a list of canonical mistakes that DB practitioners make? <<

Not really, but we do have a few:

  1. EAV = Entity-attribute-vaue
  2. OTLT = One True Lookup Table aka MUCK (Massively Unified Code Keys)
  3. Integrity in the Apps
  4. Denormalized tables
  5. Auto-increment methods for keys
  6. No keys at all
Received on Sat Jun 10 2006 - 12:48:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US