A model for data integration systems of biomedical data applied to online genetic databases

Area of Science:

• Computer Science
• Bioinformatics
• Data Management

Background:

• Data integration is challenging due to heterogeneous data sources.
• Existing systems often lack a unified approach for querying diverse datasets.
• Online genetic databases are numerous and fragmented, hindering comprehensive analysis.

Purpose of the Study:

• To present a general model for data integration systems.
• To enable efficient querying across multiple, disparate data sources.
• To demonstrate the model's applicability in the bioinformatics domain.

Main Methods:

• Developed a mediated schema to represent commonalities across data sources.
• Utilized source descriptions for mapping underlying data to the mediated schema.
• Implemented an automatic query plan generation and ranking mechanism.
• Applied the model to online genetic databases for cross-source querying.

Main Results:

• The system successfully integrates data from multiple online genetic databases.
• Queries posed against the mediated schema are efficiently answered.
• The query plan generation effectively enumerates and ranks all possible query answering strategies.
• Demonstrated the model's capability to handle complex data integration tasks in bioinformatics.

Conclusions:

• The mediated schema approach provides a robust framework for data integration.
• Automated query planning enhances the efficiency and effectiveness of cross-database queries.
• This model offers a significant advancement for accessing and analyzing distributed genetic information.