Trudy SPIIRAN
RUS  ENG    JOURNALS   PEOPLE   ORGANISATIONS   CONFERENCES   SEMINARS   VIDEO LIBRARY   PACKAGE AMSBIB  
General information
Latest issue
Archive

Search papers
Search references

RSS
Latest issue
Current issues
Archive issues
What is RSS



Informatics and Automation:
Year:
Volume:
Issue:
Page:
Find






Personal entry:
Login:
Password:
Save password
Enter
Forgotten password?
Register


Trudy SPIIRAN, 2020, Issue 19, volume 4, Pages 855–879
DOI: https://doi.org/10.15622/sp.2020.19.4.6
(Mi trspy1119)
 

This article is cited in 1 scientific paper (total in 1 paper)

Artificial Intelligence, Knowledge and Data Engineering

Minimal structure of the database for storing organisms' biodiversity data

A. M. Lyakh

A.O. Kovalevsky Institute of Biology of the Southern Seas of RAS (IBSS)
Abstract: To date, a huge amount of data on organisms diversity has been accumulated. Databases help to store and use these data for scientific purposes. There exists several dozens of databases for storing biodiversity data that were described in publications. Each has an original structure which badly correlates with the structures of other databases. This complicates data exchange and the formation of big biodiversity data array.
The cause of this situation is the lack of the formal definitions of universal data components, which allow to build the database with any data on the diversity of organisms. The analysis of publications and author’s experience show that such universal components are present in the characteristics of any organisms. For example, it is an organism taxonomic name and a location where it was found. There are six such components and they answer to one of the six questions: what, where, when, who, where from and where to. What determines the name of an organism; where determines the location where it was found; when indicates the date of finding; who enumerates the persons, who found and analyzed an organism; where from refers to publications, where data about an organism are extracted or published; where to shows in which biological collection an organism is put in.
Each component corresponds to a separate database table. These tables are linked to the table with data about organism (individual) and they are not linked with each other. Attributes of the links between the organism table and the component tables are stored in intermediate tables. They are used, for example, to store bibliographic facts, descriptions of collection items or geographical points. They also act as docking stations to which tables with any other information are attached.
The creation of any database about the diversity of living organisms begins with the definition of the table of organism specimens. It must be used even if there is no explicit data on organisms. In that case virtual organisms should be introduced and the other components should be linked with them by means of intermediate tables. The latter are docked to other data. Minimal structures of all the tables, links between them and examples of databases construction are described in the work.
Keywords: data components, organism data, geographical point, taxonomic name, bibliographic record, biological collection, collection item, metadata.
Funding agency Grant number
Ministry of Science and Higher Education of the Russian Federation АААА-А18-118020890074-2
Russian Foundation for Basic Research 18-44-920024
20-44-920004
This work was supported by the scientific research theme of the Institute of Biology of the Southern Seas No АААА-А18-118020890074-2 and by RFBR and Government of the Sevastopol according to the research project No 18-44-920024 and 20-44-920004.
Received: 06.06.2020
Document Type: Article
UDC: 574.1+004.65
Language: Russian
Citation: A. M. Lyakh, “Minimal structure of the database for storing organisms' biodiversity data”, Tr. SPIIRAN, 19:4 (2020), 855–879
Citation in format AMSBIB
\Bibitem{Lya20}
\by A.~M.~Lyakh
\paper Minimal structure of the database for storing organisms' biodiversity data
\jour Tr. SPIIRAN
\yr 2020
\vol 19
\issue 4
\pages 855--879
\mathnet{http://mi.mathnet.ru/trspy1119}
\crossref{https://doi.org/10.15622/sp.2020.19.4.6}
Linking options:
  • https://www.mathnet.ru/eng/trspy1119
  • https://www.mathnet.ru/eng/trspy/v19/i4/p855
  • This publication is cited in the following 1 articles:
    Citing articles in Google Scholar: Russian citations, English citations
    Related articles in Google Scholar: Russian articles, English articles
    Informatics and Automation
    Statistics & downloads:
    Abstract page:74
    Full-text PDF :33
     
      Contact us:
     Terms of Use  Registration to the website  Logotypes © Steklov Mathematical Institute RAS, 2024