Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Modelling objects with variable number of properties in an RDBMS

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

From: VC <boston103_at_hotmail.com>
Date: Wed, 2 Nov 2005 20:09:27 -0500
Message-ID: <FYCdnbLsvMug_vTeRVn-uQ@comcast.com>

"Roy Hann" <specially_at_processed.almost.meat> wrote in message news:79Sdne2dw4Hv0fTeRVnysQ_at_pipex.net...
> "VC" <boston103_at_hotmail.com> wrote in message
> news:xpednZGpW5rOofTeRVn-pQ_at_comcast.com...
>> > I hope this is not a side-track here, but could you clarify this a bit?
>> > It sounds like you are saying you have a drug entity, some stable
>> > information about that drug, and then the results of multiple
>> > tests/experiments done against that drug (e.g. test1, test2, test3,
>> > test4,..., test750).
>> >
>> > Should these tests really be considered attributes? Wouldn't the act
>> > of presenting them as a two-tuple relation <test#, test result> simple
>> > be an wise step of normalization - not an example of an EAV
>> > decomposition? Am I totally missing the boat on this?
>>
>> It's a single test with ~6000 measurements.
>
> That much I get, but is it really an EAV design? Are the values of these
> 6,000 measurements from one domain or many?

Let's say they are all double precision real numbers. I vaguely remember there were some variables whose values were members of a two element set(1/0, yes/no), but the majority were real numbers.

>
> Roy
>
>
Received on Wed Nov 02 2005 - 19:09:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US