Re: [Gusdev-gusdev] Relation between tables

[Thomas O. <ot...@fi...>]

That's what I was thinking about. So I want to know, which 
representation of datas you prefer. (1 or 2, it is more a general question).

Thomas


Angel Pizarro wrote:

> OK, I don't see where you are getting EnzymCompoundRelation & 
> CompoundClassAttribute from. Our current version of GUS does not have 
> these tables. The SRes.EnzymeClass table is also looking very wacky to 
> me. Propose a nice structure for this and we can put it in the next 
> release of GUS.
>
> Angel
>
> Thomas Otto wrote:
>
>> Hello,
>>
>> I am uploading some kegg data in the GUS system...
>>
>> So I looked which tables are existing, and which we are needing i.e. 
>> for compound, reactions. Now I am not sure how is the convention to 
>> relate the data.
>>
>> Example:
>> The Enzymes are related to the compounds.
>> (1) In EzymeClassAttribute I write the names of the compound related 
>> to each enzyme. In CompoundClassAttribute I write also all 
>> EC-numbers, related to it.
>> (2) Other possibilty would be to utilize a thrid table 
>> EnzymeCompoundRelation, where I put the primkeys of the relations.
>>
>> (1) would be faster, easier to query, but redundend.
>> (2) Cleaner
>>
>> What are you thinking I should use?
>>
>> Thanks,
>> Thomas
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: IBM Linux Tutorials
>> Free Linux tutorial presented by Daniel Robbins, President and CEO of
>> GenToo technologies. Learn everything from fundamentals to system
>> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
>> _______________________________________________
>> Gusdev-gusdev mailing list
>> Gus...@li...
>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>
>
>