Creation of fish databases for electronic interactive map: tables and keys

Abstract

Purpose. Purpose of the work is to create fish databases using rainbow trout data and basing on new methods of theoretical analysis of fish data and their ordering in hierarchical structures with elements represented as relation tables linked through a system with primary keys with specific codes.Methodology. The methods of object-oriented system analysis, ER-diagram design, and the methods of computer databases construction were used in process of present work.Findings. Some well-known fish databases (seafood, aquaculture samples) were reviewed and some of their peculiarities are analyzed from the point of view of professional construction of relational databases within modern electronic information systems. The ways of the construction of such databases for domestic use in connection with the Internet were proposed. A number of algorithm stages for fish database design was described on the example of the information on rainbow trout and locations of its occurrence (catches) in Ukraine; ER-diagram, logical diagram of such database with its elements that can be presented in tables are suggested as well. Such tables should be unmistakably interconnected through the key system, and this procedure is described in detail in the article, as well as the creation of specific key codes, their formation and use to form links between the tables. The implementation of described works can be considered as one of the first stages in the development of interactive map with information of the fish species distribution (and locations of their catches) in Ukraine.Originality. Such important modern project as an interactive map with the information on the distribution of fish species (and locations of their catches) based on modern information and computer technologies using biological databases has not been implemented yet in Ukraine. The work described in this article is the first step in creating of such a map that will facilitate further intensive introduction of modern information technologies and the development of domestic fishery industry.Practical value. Rainbow trout is an important object for fishery industry of the country; and development of interactive electronic map with the information on the spread of the rainbow trout and other fish species (and places of their catches) in Ukraine is an important step for the transformation of fishery industry in our country to the contemporary level of the world technologies and for the provision of food safety. Using of contemporary computer technologies suggested in the this article, would make this branch more effective in Ukraine and in the whole world.