Relational databases: a transparent framework for encouraging biology students to think informatically

Area of Science:

• Bioinformatics
• Genomics
• Computational Biology

Background:

• Large-scale genomic datasets present significant data management and analysis challenges.
• Relational databases offer a structured approach for organizing and querying complex biological data.

Purpose of the Study:

• To demonstrate the utility of relational databases for genomic data analysis.
• To introduce a case study of a Drosophila splice-site database for research and teaching.

Main Methods:

• Development of a relational database for storing and analyzing Drosophila splice-site data.
• Implementation of a custom algorithm for splice-site computation using cDNA and genomic DNA.
• Creation of a web interface supporting data analysis procedures and structured query language (SQL) queries.
• Design allowing for the addition of new analytical procedures via metatable updates.

Main Results:

• The database successfully stores and facilitates analysis of Drosophila splice-site data.
• The web interface provides flexible access to analytical procedures and custom queries.
• The system architecture allows for extensible analytical capabilities without altering the core interface.

Conclusions:

• Relational databases provide a robust framework for handling large genomic datasets.
• The developed Drosophila splice-site database serves as a valuable tool for both scientific research and bioinformatics education.
• The database design promotes the development of computational thinking skills in students.