[Open-bio-l] biosql schema in Oracle

[Ewan Birney]

On Sat, 10 Aug 2002, Hilmar Lapp wrote:

> So, you're calling for a use-case document listing what gave rise to 
> the design?
> 
> Has something like that been written up by anyone of the original 
> hackathon participants?

not that I know of.


> 
> 	-hilmar
> 
> On Saturday, August 10, 2002, at 07:39  AM, Wiepert, Mathieu wrote:
> 
> > I want to suggest that you make it clear that the bioSQL schema was 
> > originally designed to support genbank data, and not anything 
> > more.  That gives you the advantage of reducing the ambiguity as to 
> > the purpose of the db design.  It may be clear to all that worked 
> > on the initial design, but I hadn't realized that till I heard it 
> > last week in person.  Or maybe I am just thick in the head...  Just 
> > something to put at the high level design description.
> >
> > -Mat
> >
> > -----Original Message-----
> > From: Hilmar Lapp [mailto:hlapp@gnf.org]
> > Sent: Friday, August 09, 2002 3:35 PM
> > To: OBDA BioSQL (E-mail); GMOD Devel (E-mail)
> > Subject: [Open-bio-l] biosql schema in Oracle
> >
> >
> > I'm going to release the entire suite of instantiation scripts of 
> > our biosql version to biosql-schema. Note that this is for Oracle 
> > as RDBMS. This will include PL/SQL packages encapsulating each 
> > table, and an initial set of insertable denormalized views.
> >
> > This is work in progress. Instantiation should pass without 
> > problems though, just the functionality in terms of views is 
> > limited at this point. Also, I haven't done the views mapping to 
> > the original biosql schema yet, but I'll do them at some time.
> >
> > There will also be an ERD in PDF format of the schema.
> >
> > If anyone wants to start working with it, I'm happy to write up the 
> > naming and coding conventions in case they aren't obvious. Maybe I 
> > should do so anyway as a proposal to the GMOD matrix?
> >
> > 	-hilmar
> --
> -------------------------------------------------------------
> Hilmar Lapp                            email: lapp at gnf.org
> GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
> -------------------------------------------------------------
> >
> > _______________________________________________
> > Open-Bio-l mailing list
> > Open-Bio-l@open-bio.org
> > http://open-bio.org/mailman/listinfo/open-bio-l
> 
> _______________________________________________
> Open-Bio-l mailing list
> Open-Bio-l@open-bio.org
> http://open-bio.org/mailman/listinfo/open-bio-l
> 

-----------------------------------------------------------------
Ewan Birney. Mobile: +44 (0)7970 151230, Work: +44 1223 494420
<birney@ebi.ac.uk>. 
-----------------------------------------------------------------