Relational model for storing ecologico-biological expedition data

by

A.M. Lyakh1, I.V. Agarkova-Lyakh2

1A.O. Kovalevsky Institute of Biology of the Southern Seas of RAS, RF, Sevastopol, Nakhimov Av. 2

E-mail: me@antonlyakh.ru

2Institute of Natural and Technical Systems, RF, Sevastopol, Lenina St., 28

E-mail: iva_crimea@mail.ru

DOI: 10.33075/2220-5861-2021-3-98-106

UDC 574.1+004.65                                                       

Abstract:

   Many ecological-biological data, especially archival data, as well as abstracts to publications, contain the names of sampling sites without coordinates. This means that geographical names act as the main source of information about the place location. Therefore, the aim of the work is to describe a relational database model for storing ecological and biological data, where the main emphasis is placed on geographical names.

   The system of geographical territories has a lot of similarities with the system of biological taxa. Such similarity allows using the same structure of the database table for their storage. The table contains a tree of names described by the structure “materialized path”. An additional field “status” describes the nomenclatural status of the name, and the field “rank” is reserved for the type of geographical object.

   Officially recognized and unofficial territories form a single hierarchical system united by vertical links. In the tree, all names are distributed between two major branches: land and water areas. But since the coastal territories are adjacent to the coastal water areas, the “neighbor” field is used to store such horizontal neighborhood relations. It contains an identifier of the adjacent area of the territory or water area. Water bodies and streams located on the land are also parts of the hydrosphere, but are spatially related to the land. The field “aquatory” is used to indicate such water bodies. Negative value of the field shows that it is a water body located on the land.

   The general structure of the expedition database includes tables with geographical names, descriptions of expeditions, sampling sites and characteristics of samples. The table for storing primary data is not reflected in the relational model. The described structure of the database allows connecting the collected expedition data to the name of the region, which helps to present the geography of the collected data in a natural form.

Keywords: full-scale climatic tests, transparent thermoplastics, polymethylmethycrylate, destruction, light transmission.

To quote:

Full text in PDF(RUS)

REFERENCES

  1. Barakhnin V.B., Zhizhimov O.L., Kupershtokh D., Skachkov D.M., Fedotov A.M. Algoritm izvlecheniya iz tekstovyh dokumentov geograficheskih nazvanij, otrazhayushchih soderzhanie // Vestnik NGU. Seriya: Informatsionnye technologii. 2012. Vol. 10, No 1, pp. 109–120.
  2. Rodosthenous C.T., Michael L. GeoMantis: Inferring the Geographic Focus of Text using Knowledge Bases // ICAART. 2018. P. 111–121.
  3. Lyakh A.M., Lelekov S.G. Modulnaya struktura taksonomicheskoj bazy dannyh // Elektronnye Informacionnye Sistemy. 2018. No 2 (17). pp. 59–70.
  4. Lyakh A.M. Minimalnaya struktura bazy dlya hraneniya dannyh o biologicheskom raznoobrazii organizmov // SPIIRAS Proceedings. 2020. Vol. 19, No 4, pp. 855–879.
  5. Mennis J. Multidimensional map algebra: design and implementation of a spatio-temporal GIS processing language // Trans. GIS. 2010. Vol. 14. P. 1–21.
  6. Gebert S., Leppelt T., Pebesma E. A topology-based spatio-temporal map algebra for big data analysis // Data. 2019. 4 (2), 86.
  7. Elektronnaya kollekciya parazitov ryb Mirovogo okeana Instituta morskih biologicheskih issledovanij im. A.O. Kovalevskogo / Ye.V. Dmitrieva, A.M. Lyakh, Yu.M. Kornyychuk [et al.] // Morskoj biologicheskij zhurnal. 2016. Vol. 1, No 3, pp. 27–31.
  8. Agarkova-Lyah I.V., Lyakh A.M. Usloviya razvitiya i aktivnost ekzogennyh geologicheskih processov na beregah YUgo-Zapadnogo Kryma ot m. Ajya do m. Sarych // Izvestiya Saratovskogo universiteta. Seriya “Nauki o Zemle”. 2020. Vol. 20, No 2, pp. 76–85.
  9. Shuyskiy Yu.D., Vykhovanets G.V., Organ L.V. Vdolberegovye litodinamicheskie sistemy v beregovoj zone severo-zapadnoj chasti Chernogo morya // Prichernomorskij ekologicheskij byulleten. 2010. No. 1 (35), pp. 74–83.
  10. Wieczorek J., Bloom D., Guralnick R., Blum S., Doring M., Giovanni R., Robertson T., Vieglais D. Darwing Core: an evolving community-developed biodiversity data standard // PLoS ONE. 2012. Vol. 7. P. 1–8.
  11. Skachkov D.M., Zhizhimov O.L. Ob integracii geograficheskih metadannyh posredstvom retrospektivnogo tezaurusa // Informatics and Applications. 2012. Vol. 6, No. 3, pp. 43–51.
  12. Zhizhimov O.L. Tekhnologiya izvlecheniya geograficheskih nazvanij iz tekstovyh dokumentov na osnove instrumentariya PostgreSQL // Vestnik Vostochno-Kazahstanskogo Gosudarstvennogo Tekhnicheskogo Universiteta im. D. Serikbaeva. 2018. No 1–3, pp. 195–203.
  13. Koroleva I.A. Microtoponims and nonofficial regional toponims (raising the questions) // Izvestiya SmolGU. 2016. No 4 (36), pp. 94–103.
  14. Koroleva I.A. Toponimy kak svernutyj lingvo-kulturnyj kod // Vestnik BFU im. I. Kanta. 2015. No. 8, pp. 31–38.
  15. Patterson D.J., Cooper J., Kirk P.M., Pyle R.L., Remsen D.P. Names are key to the big new biology // Trends in Ecology and Evolution. 2010. Vol. 25 (12). P. 686-691.
  16. Peruzzi L. Using scientific names guarantees universality of communication in science… but are plant biologists aware of it? // Plant Biosystems – An International Journal Dealing with all Aspects of Plant. 2020. Vol. 154. No 6. P. 1000–1002.
  17. Evolyuciya standarta ZOOCOD – koncepciya otrazheniya ekologicheskih ierarhicheskih klassifikacij v ploskih tablicah relyacionnyh baz dannyh / A.L. Lobanov, I.S. Smirnov, M.B. Dianov [et al.] // Elektronnye biblioteki: perspektivnye metody i tekhnologii, elektronnye kollekcii. Sbornik trudov Vserossijskoj nauchnoj konferencii RCDL’2008. Dubna. 2008, pp. 326–332.
  18. Revkov N.K. Nekotorye zamechaniya po sostavu i mnogoletnej dinamike fauny mollyuskov ryhlyh gruntov Yugo-Vostochnogo Kryma (Chernoe more) // 95 let Karadagskoj nauchnoj stancii: Sb. nauch. trudov. 2009, pp. 251–261.
  19. Zhiyanov A. Kak uprostit polzovatelyu zhizn. https://antonz.ru/simplify-users-life/ (data obrasheniya: 18.08.2021).
  20. Birman I. Kak sdelat interfejs druzhelyubnym? Byuro Gorbunova. https://bureau.ru/bb/soviet/20150714/ (data obrasheniya: 07.08.2021).

 

Loading