[Open-bio-l] Schema for genes & features & mappings to assemblies

[Matthew Pocock]

Thomas Down wrote:
> On Mon, Apr 22, 2002 at 02:36:18PM -0700, Hilmar Lapp wrote:
> 
>>	- biosql is for sequences and features, not mappings to 
>> assemblies (is that intended to be added, too, or is it beyond its scope? )
> 
> 
> Hi...
> 

> But does mean
> that all the `assembly-munging' code will probably need
> to be put in your object layer, rather than handling
> the assembly directly in the SQL queries.
> 

If Oracle is your target database then you may well be able to use the 
oracle tree-fetching queries to pull out entire assembly trees in one 
hit rather than performing multiple requests. Failing this, a little bit 
of server-side script can be convinced to walk the tree for you (if your 
db admin allows this kind of thing).

Matthew

> 
>     Thomas.
> _______________________________________________
> Open-Bio-l mailing list
> Open-Bio-l@open-bio.org
> http://open-bio.org/mailman/listinfo/open-bio-l
>