Re: Modeling question...

From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Fri, 25 Jul 2008 16:05:47 +0200
Message-ID: <g6cmjq$9s9$1_at_nntp.fujitsu-siemens.com>

Bob Badour schrieb:
>>> Ooooh! Reinventing EAV with levels...
>>
>> Possibly. I had a look at
>> http://ycmi.med.yale.edu/nadkarni/eav_CR_contents.htm and didn't find
>> anything exciting.
>> All my attributes (key value pairs) are (for the purpose of this
>> discussion) strings, so the Data tables hierarchy ends with
>> EAV_Objects in the first image of that link.
>> My problem is that, that I haveTest three different "Objects_1"
>> tables and I'd like to avoid having to replicate the EAV_Objects-Table
>> for each "Objects_1"-Table.
>> OTOH, I could have the "level" entities all be children of an id table
>> and
>> put the key value pairs into a child of that table. I need to try this
>> out.
>>
>> Thanks for providing the pointer!
>> Volker

> 
> Just to be clear, I was more than offering a pointer. I was also 
> ridiculing the idea of EAV.

I got that. :-)
But "we want to be able to create and delete attributes" is a customer requirement. I think it's different from "I am too lazy to do a proper data model". There are plenty of "normal" attributes left to model ERD like.

Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.

Received on Fri Jul 25 2008 - 16:05:47 CEST