[BioSQL-l] sequence cluster support

Hilmar Lapp hlapp@gnf.org
Thu, 7 Nov 2002 23:12:35 -0800


I had to support sequence clusters, for which the base interface is 
Bio::ClusterI is bioperl (not entirely true because Bio::ClusterI 
doesn't really define the type of member).

To capture the cluster membership relationship I needed a typed 
bioentry-bioentry association, and hence added an according table 
with parent_bioentry_id and child_bioentry_id FKs to bioentry, and a 
FK to ontology_term.

Does anyone have a problem with me committing this? It could go into 
a separate DDL file, but I'm not convinced it is worth the effort to 
separate it out.

BTW bioperl-db fully supports storing and retrieving sequence 
clusters now, especially UniGene clusters. I heavily expanded the 
object-relational mapping code to be able to cope with multiple 
references to the same entity in one table.

	-hilmar
--
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------