Difference between revisions of "Precompiled Chado Databases"

From GMOD
Jump to: navigation, search
(removed old instructs to changed db/user name)
m (Editing to make it sound a bit more formal.)
Line 1: Line 1:
I'm not aware of how many of you regularly have to configure and deploy chado databases, however over time I've found that a significant portion of my time was spent waiting on ontologies to load.
+
[https://cpt.tamu.edu/~docs/chado/ Chado database dumps of precompiled ontologies are publicly available] to save Chado users the time and hassle of downloading and compiling the ontologies themselves.
  
To this end (and in support of some other projects), I set up a jenkins job to
+
Go to the [https://cpt.tamu.edu/~docs/chado/ download site].
  
* clone chado from SVN
+
The ontologies currently available are:
 +
 
 +
*Chado Feature Properties
 +
*Gene Ontology
 +
*Plant Ontology
 +
*Relationship Ontology
 +
*Sequence Ontology
 +
 
 +
These are updated weekly; the workflow is as follows:
 +
 
 +
* clone Chado from SVN
 
* build
 
* build
 
* load ontologies
 
* load ontologies
* dump database as sql
+
* dump database as SQL
 
* upload to a publicly accessible webserver
 
* upload to a publicly accessible webserver
  
This is done on a weekly basis. I'm making the compiled databases with all 5 ontologies loaded available to the community. They're trivial to use if you're just trying to install chado. This process takes ~10s-5m, compared to the 1.3 hours (according to my jenkins job) for regular ontology loading.
+
Note that none of the Chado-related scripts are installed, and the GMOD conf files are not created in GMOD_ROOT. For remote access (e.g., via Artemis), and tools that do not make use of GMOD_ROOT locally, this is not a problem.
 
+
The databases can be found here: [[https://cpt.tamu.edu/~docs/chado/ https://cpt.tamu.edu/~docs/chado/ ]]
+
 
+
The ontologies currently installed are:
+
 
+
# Relationship Ontology
+
# Sequence Ontology
+
# Gene Ontology
+
# Chado Feature Properties
+
# Plant Ontology
+
 
+
If anyone is interested in this, and would like:
+
 
+
* other builds with different (sub)sets of
+
* archived copies of schemas over time
+
 
+
please feel free to [[mailto:rasche.eric@yandex.ru request]] them and we'll add them to the jenkins job/make them available.
+
 
+
NB: The caveats of this method are, of course, that none of the scripts are installed, and the gmod conf files are not created in GMOD_ROOT. However, for remote access (e.g., via Artemis), and tools that do not make use of GMOD_ROOT locally, this seems to be fine.
+
  
[[Category:Chado]]
+
These database dumps are kindly provided by Eric Rasche and the [https://cpt.tamu.edu/ Center for Phage Technology at Texas A&M University]. Please [mailto:rasche.eric@yandex.ru contact Eric] if you are interested in having other ontologies added to the dumps, other builds with different (sub)sets of ontologies, or archived copies of schemas over time.
  
 
[[Category:Chado]]
 
[[Category:Chado]]

Revision as of 20:57, 20 February 2014

Chado database dumps of precompiled ontologies are publicly available to save Chado users the time and hassle of downloading and compiling the ontologies themselves.

Go to the download site.

The ontologies currently available are:

  • Chado Feature Properties
  • Gene Ontology
  • Plant Ontology
  • Relationship Ontology
  • Sequence Ontology

These are updated weekly; the workflow is as follows:

  • clone Chado from SVN
  • build
  • load ontologies
  • dump database as SQL
  • upload to a publicly accessible webserver

Note that none of the Chado-related scripts are installed, and the GMOD conf files are not created in GMOD_ROOT. For remote access (e.g., via Artemis), and tools that do not make use of GMOD_ROOT locally, this is not a problem.

These database dumps are kindly provided by Eric Rasche and the Center for Phage Technology at Texas A&M University. Please contact Eric if you are interested in having other ontologies added to the dumps, other builds with different (sub)sets of ontologies, or archived copies of schemas over time.