Related Experiment Videos
YAdumper: extracting and translating large information volumes from relational databases to structured flat files
José M Fernández1, Alfonso Valencia
1Protein Design Group, National Center for Biotechnology, CNB-CSIC Cantoblanco, Madrid 28049, Spain. jmfernandez@cnb.uam.es
Bioinformatics (Oxford, England)
|May 1, 2004
Summary
YAdumper efficiently downloads structured data from relational databases into XML format. This Java tool reduces memory usage and improves writing performance for bioinformatics data extraction.
Area of Science:
- Bioinformatics
- Database Management
Background:
- Downloading data from relational databases into formats like XML is common in bioinformatics.
- This process often demands significant computational resources (CPU, disk, memory).
Purpose of the Study:
- To introduce YAdumper, a specialized tool for efficient, integral structured information download from relational databases.
- To address the resource-intensive nature of traditional database dumping methods.
Main Methods:
- YAdumper is a Java application designed for database extraction.
- It utilizes an XML template guided by an external Document Type Declaration for data organization.
Main Results:
- YAdumper substantially reduces memory requirements compared to non-native alternatives.
- The tool considerably improves writing performance during data extraction.
Conclusions:
- YAdumper offers an optimized solution for structured database downloads in bioinformatics.
- The tool enhances efficiency and reduces resource consumption for data transfer tasks.