2024/10/21 by Klyuchko, Olena, Melezhyk, Olga
#coding #database #image #information and computer technology #information system
paper · doi:10.25929/re84ry96
Introduction: Images of biological objects are used very often now for the creation of novel information systems for biology and medicine. But the sphere of their use, tasks which are possible to solve with them, can be successfully expanded. Problem statement: Contemporary biomedical relational databases (DBs) very often include images. But additionally, images themselves can play important functional roles in DBs. Purpose: To use images of fishes’ genetic codes fragments as keys for the construction of relational DB; this has to ensure the reliability of biomedical information storage better than in prototypes, and to provide better data integrity. Methods: DB Design, object-oriented system analysis for DBs design in an optimal way, ER diagrams design. Results: An algorithm for the construction of relational DBs with images, other biomedical information, analytical approaches and recommendations for doing this in an optimal way were presented. The main attention was paid to the creation and application of the most functionally high-quality codes for keys in DB (including primary keys). To perform this function, usages of codes based on images of fishes’ genetic codes fragments were proposed. The example for such a task solution, described in this article, was the creation of DBs with information about fishes (or other aquatic organisms) and chemical inorganic environmental pollutants which affected them. Conclusions: The results of the use of images of genetic codes fragments as keys for the construction of DBs with ecological data in an information system for environmental monitoring were presented. Through the high level of individualization of the data in a system with such keys the maintenance of species-specific information is substantiated. The work has theoretical and practical values. It may also be applied in an academician process for teaching students.