[Genome] UCSC database design

[Kayla Smith]

Dear Hefh,

Thank you for your compliments on our genome browser!

Please see a previously answered mailing list question on the schema:
http://www.cse.ucsc.edu/pipermail/genome/2002-July/001131.html

On the details page for any track, there is a "view table schema" link.
 This takes you to a page which will show you which other tables are
related to the one currently in use and via which identifier, under the
section "Connected Tables and Joining Fields".

In the Table Browser ("Tables" on the blue bar on the top of the main
page) you can navigate through assemblies and tables to find the one(s)
you are interested in knowing the relationships for.  Clicking on the
"describe table schema" button takes you to a page that indicates which
relationships that table has.  These relationships are described in the
all.joiner file, which you can download here:
ftp://hgdownload.cse.ucsc.edu/apache/cgi-bin/all.joiner

I hope this helps to answer your question.  Please don't hesitate to
contact us again if you require further assistance.

Kayla Smith
UCSC Genome Bioinformatics Group


hefh wrote:
> Dear Prof.,
> 
> The UCSC database is very helpful and useful database for biologists to research genome, transcriptome and proteome.
> 
> UCSC genome browser is also a very wonderful and very convenient tool. But it is very difficult for us to use data from UCSC database due to so many tables.
> 
> Understanding relation among tables made us headache. Would you mind sending us a visible graph of database designing or relation among tables?
> 
> Any help will be very appreciated!
>  
> 
> 
> Best regards!
> 
> 
> Yours sincerely,
> hefh
> 
> 
> Fuhong He
> *****************************************************
> Beijing Genomics Institute
> Chinese Academy of Sciences
> 
> Airport Industrial Zone B10
> Shunyi, Beijing 101300, P.R. China
> 
> Tel: 86-10-80485492 (Office)
> Email:  hefh at genomics.org.cn
> *****************************************************
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Genome maillist  -  Genome at soe.ucsc.edu
> http://www.soe.ucsc.edu/mailman/listinfo/genome