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: What is this model technique called

Re: What is this model technique called

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 4 Jun 2003 16:56:14 -0700
Message-ID: <c0d87ec0.0306041556.2dc4bd2c@posting.google.com>


>> What is this technique called? <<

You will see it called EAV (entity-attribute-value) in the literature.  It is an attempt to put metadata into a RDBMS and it falls apart in about one year in production work. You cannot write any constraints, DRI is impossible and every typo becomes a new attribute. The simplest queries require huge resources and complex queries are unmaintainable.

If you are maintaining contracts, do not use an RDBMS. Get a textbase product which can track the contracts as text, log versions, link stock paragraphs, etc. Get the right tool for the job. Received on Wed Jun 04 2003 - 18:56:14 CDT

Original text of this message

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