Re: Generalised approach to storing address details
Date: 8 Dec 2006 03:26:20 -0800
Message-ID: <1165577180.296252.190430_at_79g2000cws.googlegroups.com>
Huhh...The comment posted was purely ironical. EAV is pure crap....
Neo a écrit :
> > I want to set up a generic way of entering names and address details...
> > It is quite possible that it is a well-known 'bad thing
> > to do' (it feels a bit like EAV).
>
> Some advantages of using EAV design in RMDBs (also pointed out by
> Cimode):
> 1) Flexibility to handle data, including that which is unknown at
> design time.
>
> Some disadvantages of using EAV design in RMDBs:
> 1) Loss of SQL support resulting in more and complex code.
> In addition, more constraints have to be implemented via user code.
> 2) Decreased performance due to increased joins.
>
> In general, pure EAV is possible but mostly impractical in RMDBs. You
> can begin to see the complexity of managing EAVs in recent thread
> titled "How to find Brothers and Sisters?"
>
> Experiences with EAV in RMDBs led me to develop dbd, a small
> experimental database. It has the advantages of EAV while replacing SQL
> with a LISP-like interface. See following examples:
>
> Persons with Varied Attributes:
> www.dbfordummies.com/Example/Ex121.asp
>
> Baseball Team Members with Varied Attributes:
> www.dbfordummies.com/Example/Ex102.asp
Received on Fri Dec 08 2006 - 12:26:20 CET