Data storage in yMGV
The yMGV database is constructed on the PostgreSQL software running on Unix system. The web page interface is constructed using PHP as script program to query the database, organize the results and draw interactive online graphics. Publication data storage is organized around a mother table and one inherited table for each publication dataset.
Building one table per publication greatly speeds up access to specific dataset
while it is still possible to query all the datasets via the mother table.
The data table contains a unique identifier for each publication, the name of
the experiments, and the filtered normalized Cy5/Cy3 ratio and significance
value for each ORF in all experiments. Another table contains all the information
concerning publication description such as the complete reference, links to
pubmed and to the associated web site, the experimental methods used and statistical
data (refer to Marc et al., 2001 for details). Some other useful information
are connected to this central core such as general data concerning yeast ORF
(using SGD definitions) or article assignation to pre-selected biological groups.
We are currently working on yMGV design to integrate the information described
in the MGED MIAME version
1.0.