Web supplement to 2002 NAR database issue:
yMGV: helping biologists for yeast microarray data mining
Le Crom S., Devaux F., Jacq C. and Marc P.

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.
 



Home
last updated: 14 august 2001
P. Marc