MeMo: a hybrid SQL/XML approach to metabolomic data management for functional genomics.
BACKGROUND
The genome sequencing projects have shown our limited knowledge regarding gene function, e.g. S. cerevisiae has 5-6,000 genes of which nearly 1,000 have an uncertain function. Their gross influence on the behaviour of the cell can be observed using large-scale metabolomic studies. The metabolomic data produced need to be structured and annotated in a machine-usable form to facilitate the exploration of the hidden links between the genes and their functions.


METHODS
MeMo is a formal model for representing metabolomic data and the associated metadata. Two predominant platforms (SQL and XML) are used to encode the model. MeMo has been implemented as a relational database using a hybrid approach combining the advantages of the two technologies. It represents a practical solution for handling the sheer volume and complexity of the metabolomic data effectively and efficiently. The MeMo model and the associated software are available at http://dbkgroup.org/memo/.


CONCLUSIONS
The maturity of relational database technology is used to support efficient data processing. The scalability and self-descriptiveness of XML are used to simplify the relational schema and facilitate the extensibility of the model necessitated by the creation of new experimental techniques. Special consideration is given to data integration issues as part of the systems biology agenda. MeMo has been physically integrated and cross-linked to related metabolomic and genomic databases. Semantic integration with other relevant databases has been supported through ontological annotation. Compatibility with other data formats is supported by automatic conversion.
Spasić
Irena
I
School of Chemistry, Faraday Building, The University of Manchester, Manchester, M60 1QD, UK. i.spasic@manchester.ac.uk
Dunn
Warwick B
WB
Velarde
Giles
G
Tseng
Andy
A
Jenkins
Helen
H
Hardy
Nigel
N
Oliver
Stephen G
SG
Kell
Douglas B
DB
D003198:Computer Simulation; D003628:Database Management Systems; D023281:Genomics / Q000379:methods*; D016247:Information Storage and Retrieval / Q000379:methods*; D008660:Metabolism / Q000502:physiology*; D008954:Models, Biological; D020543:Proteome / Q000378:metabolism*; D015398:Signal Transduction / Q000502:physiology*; D018511:Systems Integration; D014584:User-Computer Interface
D020543:Proteome