[Open-bio-l] biosql schema in Oracle

[Wiepert, Mathieu]

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