[BioSQL-l] DB Schema question in the ontology section

[Hilmar Lapp]

Right.

Note that the foreign key to ontology is also in the unique key 
constraint; i.e., you may in fact have multiple relationships between 
the same subject and object terms, even using the same predicate, but 
with different ontology_id. The ontology foreign key may then indicate 
the axioms or knowledge you used to arrive at the relationship.

In other words, the ontology of a term relationship is the ontology 
that owns it, and therefore probably gave rise to it.

If you never compute or create relationships yourself you'll probably 
never have a need for discerning relationships based on their 
ontology_id.

	-hilmar

On May 19, 2005, at 10:15 AM, Aaron J. Mackey wrote:

> The reason is that the relationship between ontological terms may come 
> from another ontology entirely (imagine a mapping between SO and, say, 
> GAME-XML tags as defined by the DTD, in which case three ontologies 
> would be in play).
>
> Confusing, but there it is.  For the case where the two related terms 
> are from the same ontology, the extra ontology_id will most likely 
> point to the same ontology from which the terms arose.
>
> -Aaron
>
> On May 19, 2005, at 11:56 AM, Richard Cote wrote:
>
>> Hello all
>>
>> The term_path and term_relationship tables of the biosql schema 
>> contain an
>> ontology_id FK that references the ontology table. Why is this key 
>> present
>> in those tables? What's the rationale? Can't you link back to the 
>> ontology
>> through the term table itself?
>>
>> Thanks for any info and regards,
>> Rc
>> --
>> Richard Cote
>> Software Engineer - PRIDE Project Team (Sequence Database Group)
>>
>> European Bioinformatics Institute
>> Wellcome Trust Genome Campus            RCote at ebi.ac.uk
>> Hinxton
>> Cambridge CB10 1SD                      Phone: (+44) 1223 492610
>> United Kingdom                          Fax  : (+44) 1223 494468
>>
>> _______________________________________________
>> BioSQL-l mailing list
>> BioSQL-l at open-bio.org
>> http://open-bio.org/mailman/listinfo/biosql-l
>>
>>
> --
> Aaron J. Mackey, Ph.D.
> Dept. of Biology, Goddard 212
> University of Pennsylvania       email:  amackey at pcbi.upenn.edu
> 415 S. University Avenue         office: 215-898-1205
> Philadelphia, PA  19104-6017     fax:    215-746-6697
>
> _______________________________________________
> BioSQL-l mailing list
> BioSQL-l at open-bio.org
> http://open-bio.org/mailman/listinfo/biosql-l
>
-- 
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------