[Gusdev-gusdev] New files for GUSdev schema.

[Jonathan C. <cra...@sn...>]

Paul-

I've just placed a new .tar.gz file with the GUSdev/GUSwww create database
scripts on our download site:

<http://www.cbil.upenn.edu/downloads/GUS/schema/gusdev-sql-aug-12-2002.tar.gz>

There are a number of improvements over the last set of files, not least
of which is the fact that I tested everything before tar'ing it up this
time around!  As you requested I've also included the contents of the
following tables:

Taxon
Taxon3
TaxonName
GeneticCode

The latter three will replace the first one in GUS 3.0 (with Taxon3
getting renamed to Taxon.)  And, as I mentioned in my previous e-mail,
"Taxon" came from GSDB, whereas "Taxon3" (and the two tables associated
with it) was loaded from flat files downloaded from NCBI.  I think
everything should be explained in the accompanying README file, but let me
know if you have any questions.  The next step will be to package up (and
test) the Perl object layer and Java servlet code, although I'm
contemplating making some changes to the part of the database schema with
which the servlet code interacts (the "guswww-" files in this release.)

Note that there are a couple of problems with loading the Taxon tables
this way (using INSERT statments through SQL*Plus); the first is that it's
probably slightly slower than using the Perl object layer and the second
is that (at least how I currently have it set up) you lose the tracking
information (i.e., an informative entry in AlgorithmInvocation.)

Jonathan