Re: [Gusdev-gusdev] GBParser

[MICHAEL L. <lu...@cs...>]

I think I can take the second question:
> 2) --db_rel_id : As the documentation describes,
this is external database id. Do I create this id on my own?
Do I need to keep this entry in any other table?
Does this id has one to one correspondence with the project
I am working on (and the one I described in my .gus.properties file?)

Yes, you need to create this ID on your own.  Almost every piece of
biological data that you put into GUS has an external_database_release_id.
This helps keep track of versions, and could help you to be able to
compose some really complex queries if you knew something really complex
to look for(I don't necessarily).  There is a table called
SRes.externaldatabaserelease which needs an entry in it.  Check out all
the tables at the cool tool www.gusdb.org/cgi-bin/schemaBrowser
If you look at SRes.externaldatabaserelease you will notice that it has a
foreign primary key(not sure necessarily of the appropriate jargon on
this, but I mean something that cannot be null, and should have a
representation in another table) of external_database_id.  So first you
must make an entry into the table SRes.externaldatabase, also available
for viewing at the above stated location.  The recursion bottoms out here.
Put in the information for where you get the data--Sanger, TIGR, etc. and
then put a release in the release table.  This is helpful if you get new
data, then you can just make a new entry into SRes.externaldatabaserelease
and state your queries so that they only fetch the data with the
appropriate release number.


>
>
> Any help will be really appreciated
>
>
> thanks
> --Jinal
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: SourceForge.net Broadband
> Sign-up now for SourceForge Broadband and get the fastest
> 6.0/768 connection for only $19.95/mo for the first 3 months!
> http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>