Re: [Gusdev-gusdev] Relation between tables

[Angel P. <an...@pc...>]

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
>>
>>
>>
>>
>