[Open-bio-l] biosql schema in Oracle

Hilmar Lapp hlapp@gnf.org
Sat, 10 Aug 2002 14:45:59 -0700


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?

	-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