Re: [Gusdev-gusdev] Relation between tables

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

I think I will all the relation in one table... sort of EnzymeRelations...

Thomas
Thomas Otto wrote:

> Okay, an example:
> To every enzyme are several reaction associated. i.e. Enzymea, has 
> reaction1, ..., reaction n.
> (1) I could be to save the name of the reaction in the table 
> EnzymeClassAttribute
> (2) would be, to save nothing of this in the EnzymeClassAttribute, but 
> in a table (to create) EnzymeReactionRelation.
>
> This will mean a lot of new table, because just for the enzymes there 
> are pathways, reaction, compound, substrate, product...
>
> But indeed, I also prefer #2, who is less redundend.
>
> Thanks,
> Thomas
>
> Angel Pizarro wrote:
>
>> In the absence of an example of data a definite schema, definitely #2 
>> as the data model of choice. You can always implement materialized 
>> view to speed-up/ease  queries.
>>
>> Cheers
>> Angel
>>
>> Thomas Otto wrote:
>>
>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>> -------------------------------------------------------
>> 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
>>
>
>
>
>
> -------------------------------------------------------
> 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
>