Re: Modelling objects with variable number of properties in an RDBMS

From: Jonathan Leffler <>
Date: Wed, 02 Nov 2005 06:06:48 GMT
Message-ID: <YHY9f.4683$>

VC wrote:

> "Roy Hann" <specially_at_processed.almost.meat> wrote in message 

>>"vc" <> wrote in message
>>>Roy Hann wrote:
>>>>Actually no, let's not. What you have re-invented here is the tired
>>>>entity-attribute-value (EAV) design (much beloved of medical research
>>>>for some reason).
>>>Often they do that (EAV) not because they do not know any better but in
>>>order to overcome a specific database physical limitations. Their
>>>entities very often contain thousands of attributes (molecular
>>>biology/pharmaceutical research/drug discovery) [snip].
>>Always check the bath water for babies...
> I beg your pardon ?

There's an old saying "Don't throw the baby out with the bath water". In this context, it means (roughly) make sure you don't lose the benefits of the relational model by thowing away all the rules that help make it work.

Jonathan Leffler                   #include <disclaimer.h>
Guardian of DBD::Informix v2005.02 --
Received on Wed Nov 02 2005 - 07:06:48 CET

Original text of this message