MeMo: a hybrid SQL/XML approach to metabolomic data management for functional genomics
Open Access
- 5 June 2006
- journal article
- research article
- Published by Springer Nature in BMC Bioinformatics
- Vol. 7 (1) , 281
Abstract
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. Description: 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/. Conclusion: 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.Keywords
This publication has 40 references indexed in Scilit:
- An object model and database for functional genomicsBioinformatics, 2004
- YAdumper: extracting and translating large information volumes from relational databases to structured flat filesBioinformatics, 2004
- Pedro: a configurable data entry tool for XMLBioinformatics, 2004
- CEBS object model for systems biology data, SysBio-OMBioinformatics, 2004
- Common interchange standards for proteomics data: Public availability of tools and schema. Report on the Proteomic Standards Initiative Workshop, 2 nd Annual HUPO Congress, Montreal, Canada, 8–11 th October 2003Proteomics, 2004
- Public-Private Group Maps Out InitiativesScience, 2002
- Creating a bioinformatics nationNature, 2002
- Systems Biology: A Brief OverviewScience, 2002
- Life with 6000 GenesScience, 1996
- The entity-relationship model—toward a unified view of dataACM Transactions on Database Systems, 1976