Re: Attribute-value approach for table design

From: "Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 12 Nov 2006 05:24:28 -0800

Jamie

Can you offer some pointers to arguments both against and for EAV? A
cursory Google search suggested that there are performance issues in this
design, but that for something like a medical tests database, EAV offers a
practical solution.

Any additional evidence, or are we in the realm of opinion?

Thanks!

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

"Jamie Collins" <jamiecollins@xxxxxxxxxx> wrote in message
news:1162889532.808374.17220@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Ming wrote:

I am thinking to put the new fields into a new table, which will has
Attribute Name, TextValue, DateValue, NumberValue, and BooleanValue

column.

I don't think you'll find much support for the notorious EAV
(Entity-Attribute-Value) 'design flaw' around here :(

Jamie.

--

Follow-Ups:
- Re: Attribute-value approach for table design
  - From: Jamie Collins

References:
- Re: Attribute-value approach for table design
  - From: Jamie Collins

Prev by Date: Set up Due Date
Next by Date: Re: Training records
Previous by thread: Re: Attribute-value approach for table design
Next by thread: Re: Attribute-value approach for table design
Index(es):
- Date
- Thread

Relevant Pages

Re: Problem with views switching columns
... This is called EAV design. ... Design for Generic Clinical Study Data Management Systems" by Prakash ... Similarly, most analytical programs, such as ...
(microsoft.public.sqlserver.programming)
Re: Modelling objects with variable number of properties in an RDBMS
... EAV tables. ... I cannot provide more detail than above since the design ... I can think of lots of reasons why ... In fairness it was a saying that summed up an important point. ...
(comp.databases.theory)
Re: Suggestions for refactoring unusual tables
... Throw away the idiot who did the EAV. ... it is not a design at all. ... Dining Room verbal aggression 0 ... courtyard verbal aggression 0 ...
(comp.databases)
Re: Noob needs polymorphism
... >>Don't use an RDBMS. ... This design flaw is called EAV ...
(comp.databases)
Re: Attribute-value approach for table design
... The intent of my post was to give a name to the design, ... the chances of EAV being a newbie error, ... Bear in mind that 'database' and 'SQL DBMS' are different concepts. ...
(microsoft.public.access.tablesdbdesign)