In order to minimize the costs and negative load of schema evolution we propose the Multi-Version metadata technology.
This schema is loaded with a filtered version of the GFF annotations and DNA sequences in FASTA format from WormBase [ 21].
For data warehouses that load data directly to star schemas, changing the variables that trigger updates to Type 2 slowly changing dimensions and altering the grain of its fact tables lead to similarly expensive reengineering efforts.
In constructing P-POD we made use of the database schema, installation and loading tools, and various software components from the Generic Model Organism Database (GMOD) project (www.gmod.org), The goal of GMOD is to develop an open and generic genomic database environment, including database schemata and required software tools.
The latter were loaded into a two-table schema in the postgreSQL software system, whilst the rest are available for download as described below.
Once the schema has been loaded, the GS is presented in a tree representation on the left panel, showing ISA (Is-a) relationships among the classes.
The Osa1 GFF database uses the BioPerl Bio::DB GFF schema and is loaded with GFF-formatted annotation from the current version of the Osa1 Genome Annotation database [ 24].
Furthermore, an overview of the database schema is provided, the loading infrastructure introduced, and the library of analysis tasks presented.
This design enables new variables to be appended to the database as new datasets are loaded, without altering the underlying database schema.
Only the loading of one or more FASTA files is mandatory, thereafter zero or more annotation and alignment files may be loaded into GDAV's small MySQL schema using the supplied Perl scripts.
Canto can export in JSON format for loading into databases that use the Chado schema (Mungall et al., 2007), or for archiving or other applications.
