Re: [Fwd: [Fwd: Re: [Gusdev-gusdev] GUSdev schema]]

[Pjm <pj...@sa...>]

Jonathan,

thanks for putting the file gusdev-sql-jul-25-2002.tar.gz on the download site. 
Since we have to put bootstrap/dictinary data into the rows of our schema I was 
wondering how we could share some of these things. For example, the taxon table 
could easily be shared (does this relate to NCBI Ids at all?).

Another reason for doing this is so when we (and others..) install GUS we can 
run our parsers straight away and populate the schema with our favourite data. 
Could the bootstrap data be added to the install script please?

Paul.

Jonathan Crabtree wrote:
> On Sun, 4 Aug 2002, Paul Mooney wrote:
> 
>>hi all,
>>
>>I have finally got back on to a computer - no more cold turkey...
>>
>>Arnaud has told me the java layer makes some calls to perl which try to query
>>tables that do not exist in our schema because it is a couple of months older.
>>Rather than try to patch the schema and to avoid any other problems like this
>>it seems a good idea to get a point-in-time snapshot of GUSdev.
> 
> #
> 
>>1st we need the schema - we are develping the EMBL parser with what we have
>>running now. The java layer will be needed once we are happy we have loaded a
>>good range of data so we can run the query servlet stuff. We will want to
>>modify this (hack :) so we can point to GeneDB gene pages in the prototype.
>>
>>Arnaud might be able to give time scales on when the data loading is in a good
>>enough state for a web interface but I imagine we will need the web stuff
>>within 2 weeks. Is this do-able?
>>
>>Does this help at all?
>>
> 
> 
> Paul-
> 
> Yes, thanks.  I think 2 weeks is doable.  So basically the plan is to
> start with an empty snapshot of the latest GUSdev schema and use the EMBL
> parser to populate it?  It might also help if I could have a quick look at
> the EMBL parser, or at least just find out which tables it's loading.
> Anyway, I should have an updated set of schema creation scripts ready in
> the next day or two.
> 
> Jonathan
> 
>