[MOBY-l] MOBY Central database schema

[Mark Wilkinson]

Hi all,

Just got power back to my office - we're undergoing major construction here
at the moment.  In any case, that has put me a couple of days behind...

Jas - do I understand from your sql that you want to put the Service ontology
and the Object ontology into a single table?

I'm building a MOBY_Central database right now which should have a public
login soon.  I'll have to give special permissions to those who want to go in
and modify it - let me know if this is you :-)

Sorry for the delays - the construction is getting on my nerves!

M



> Just so we don't tramp on each other's feet to much, here's the schema
> I've built for Postgres, let's standardize it, check it into CVS and
> work on it together.
>
> I prefer verbose column names and not mixing case - because different
> DBMS handle case differently.
>
> Also I had made a dedicated InputParameter table and a dedicated
> OutputParameter table, but there isn't any point really, the type
> should do that for us.
>
> Instead of a Service table and an Object table I used a single
> Ontology table.
>
> Also, I'm including the skeleton of a Perl Module that I wrote to test
> it all out.
>
> Cheers,
> jas.

--
--------------------------------
"Speed is subsittute fo accurancy."
________________________________

Dr. Mark Wilkinson
Bioinformatics Group
National Research Council of Canada
Plant Biotechnology Institute
110 Gymnasium Place
Saskatoon, SK
Canada