Re: [Gusdev-gusdev] RAD3 Schema Questions

[Elisabetta M. <man...@pc...>]

Hi Paul,
thanks for your interest in RAD.

> 1. What are the differences between the xxxElementImp and xxxElementResultImp 
> tables?  What goes into each?  My understanding is that the xxxElementImp store 
> details about the array *layout* while the xxxElementResultImp store details 
> about the data from specific arrays.
> 2. If the above description is right, would that mean that for each 
physical array (each "chip") there are records in all four tables?  Is that 
> necessary for cases with repeated chip "layouts"?

The xxxElementImp tables indeed store information about arrays, that is 
what is spotted/synthesized at each location on the array. 
The xxxElementResultImp tables store the measurements output by image 
quantifications software for a given quantification.
Thus, for example, for a given array layout, you would store this once and 
for all using the xxxElementImp tables. Then,  for each image 
quantification of a hybridization done using such a chip, you would 
populate the xxxElementResultImp tables with the resulting data.

> 3. Are the Ontologies used in RAD3::OntologyTerm publicly available?  I 
> couldn't find them in the 3.0-Beta release tar, but perhaps I just missed them?

I guess you are referring to the RAD3.OntologyEntry table. The entries we 
store in this table typically point to entries stored in ontology tables 
which are in the SRes component of GUS. This includes the MGED Ontology 
which is available at http://mged.sourceforge.net/ontologies/index.php.

Elisabetta