Users request: Convert ontology download file... (PR#44)

[Shuly Avraham]

Hi Henry,

For the plant ontology database, we adopted the gene ontology schema.

In order to parse the flat files and load them into a relational database, we
use gene ontology tools which we checkout from go cvs or if that's not
available, you can get it from go's monthly releases. You can find instructions
here: http://www.godatabase.org/dev/

Basically, use the go-dev package, which include the go-perl and go-db-perl
libraries. There you can find all the scripts to create the database, parse the
files and load into the database.

You can find description of the schema here:
http://www.godatabase.org/dev/database/

We are using the MySQL RDBMS for our database. As far as I know go tools support
MySQL and PostgreSQL. In order to use SQLSERVER 2000 you may need to start with
a 
MySQL database, if you have that available, and convert it to your RDBMS. There
should be several ways to do so. 

In the future we will provide users with MySQL dumps of our database, as well as
tab delimited text files in the scructure of the tables. Unfortunately, this is
not yet available.

I hope the information is useful to you.
Please let me know if you have further questions.

Shuly.