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

[Hilmar Lapp]

> -----Original Message-----
> From: Keith James [mailto:kdj@sanger.ac.uk]
> Sent: Tuesday, April 23, 2002 3:50 AM
> To: Matthew Pocock
> Cc: open-bio-l@open-bio.org
> Subject: Re: [Open-bio-l] Schema for genes & features & mappings to
> assemblies
> 
> 
> >>>>> "Matthew" == Matthew Pocock <matthew_pocock@yahoo.co.uk> writes:
> 
> [...]
> 
>     Matthew> If Oracle is your target database then you may well be
>     Matthew> able to use the oracle tree-fetching queries to pull out
>     Matthew> entire assembly trees in one hit rather than performing
>     Matthew> multiple requests. Failing this, a little bit of
>     Matthew> server-side script can be convinced to walk the tree for
>     Matthew> you (if your db admin allows this kind of thing).
> 
> Or you can represent the trees as nested sets. You can get a subtree
> in one hit then. The cost with this is that inserts/deletes of nodes
> becomes quite complex as you need to tweak lots of surrounding nodes
> (depending on how you store the nesting information).
> 

Interesting. I'm not familiar with these features yet but I'll check it out soon.

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