Re: Noob needs polymorphism

In <1124630094.434037.22860@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> "--CELKO--" <jcelko212@xxxxxxxxxxxxx> writes:

>Don't use an RDBMS. This design flaw is called EAV
>(Entity-Atrribute-Value) in RDBMS;

Thanks, this is very helpful.

I'm having a surprisingly difficult time finding a good
description/analysis/critique of EAV online. I get a lot of Google
hits, but none of the sites I visited seemed particularly useful.
(I'm looking something not only for myself, but also to point other
members of my team to. It will be a challenge for me to convince
them that we should abandon the RDBMS strategy.)

Also, my RDBMS textbook (Elmasri & Navathe, 3d ed) does not make
mention of EAV. (I figure that if anyone is going to analyze EAV
and tear it to bits if necessary, it would be EJ Data, but I'm away
from my copy of his book ATM, so I have not checked it yet.)

Do you by any chance know of a book or journal article that discusses
EAV at length, and explains why it is a "flaw"? (Incidentally,
FWIW, many of the pages on EAV that I found through Google advance
it as a good thing...)

kj

--
NOTE: In my address everything before the first period is backwards;
and the last period, and everything after it, should be discarded.
.

Relevant Pages

  • Re: Noob needs polymorphism
    ... >>Don't use an RDBMS. ... This design flaw is called EAV ...
    (comp.databases)
  • Re: Attribute-value approach for table design
    ... I think everyone agrees query performance is slower with EAV but what ... Constraints will involve a lots of conditional code ... the two big design mistakes all beginners make" ... "The design flaw you are calling a vertical model is actually known as ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Attribute-value approach for table design
    ... I've used it Jeff. ... We needed to capture periodic measurements on trees. ... Do you also have any leads on folks who've found the EAV ... "The design flaw you are calling a vertical model is actually known ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Attribute-value approach for table design
    ... Do you also have any leads on folks who've found the EAV model to ... I think you'll find that EAV is a common newbie error, ... "The design flaw you are calling a vertical model is actually known as ... about why it is a stupid, ...
    (microsoft.public.access.tablesdbdesign)
  • Qs re EAV
    ... the data I'm working with is a poor fit for RDBMSs, ... captured with an Entity-Attribute-Value (EAV) model. ... In my address everything before the first period is backwards; ...
    (comp.databases)