[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