Russian Federation
Russian Federation
The use of relational databases MS Access, cloud-based AirTable in the breeding process showed the possibility of assessing the genetic diversity of spring barley varieties by hordeincoding loci. It is shown that using filters and queries in the database is convenient to group varieties according to hordein formulas, analyze the level of intervarietal polymorphism and internal heterogeneity in different groups of Eastern Siberian spring barley variety samples, and distinguish varieties by the frequency of occurrence of specific hordein formulas. The possibilities of integrating different databases, setting up shared access to specific research results, and importing data into spreadsheets of various formats are discussed. The results of the search for ways to transfer the database from MS Access to the PostGreSQL application recommended by the Ministry of Digital Development, Telecommunications and Mass Media of the Russian Federation are presented.
spring barley, hordeins, polymorphism, genetic diversity, databases, queries, cloud services
1. Metodika provedeniya laboratornogo sortovogo kontrolya po gruppam sel'skohozyaystvennyh rasteniy. – M.: FNGU «Rosinformagroteh», 2004. – 96 s.
2. Pomorcev, A. A. Identifikaciya i ocenka sortovoy chistoty semyan yachmenya metodom elektroforeticheskogo analiza zapasnyh belkov zerna / A. A. Pomorcev, E. V. Lyalina. – M.: MSHA, 2003. – 85 s.
3. Shevcova, L. N. Agroekologicheskaya determinaciya yarovogo yachmenya Vostochnoy Sibiri po gordeinkodiruyuschim lokusam / L. N. Shevcova, N. V. Zobova; pod. obsch. red. N. A. Surina. – Krasnoyarsk: Krasnoyarskiy GAU, 2008. – 146 s.
4. Zobova, N. V. Spektry prolaminov v agroekologicheskoy ocenke kollekcionnogo materiala yachmenya / N. V. Zobova, N. A. Surin, S. A. Gerasimov, A. A. Chuslin, T. V. Onufrienok // Dostizheniya nauki i tehniki APK. – 2018, T. 32, № 5. – S.45–47.
5. Ocenka allel'nogo sostava ishodnogo i selekcionnogo materiala pshenicy i yachmenya na osnove metoda elektroforeza: metodicheskie rekomendacii. – Krasnoyarsk: IF FIC KNC SO RAN, 2021. – 40 s.
6. Svidetel'stvo o registracii bazy dannyh № 2020622695 (Rossiyskaya Federaciya). Selekcionno-geneticheskaya klassifikaciya yarovogo yachmenya sibirskogo regiona po gordeinkodiruyuschim lokusam / L. N. Shevcova, N. V. Zobova, S. A. Bronov // zayavka № 2020621730; zayavl. 01.10.2020; registr. 18.12.2020.
7. Surin, N. A. Baza dannyh selekcionno-geneticheskih pokazateley yarovogo yachmenya Vostochnoy Sibiri v SUBD ACCESS / N. A. Surin, L. N. Shevcova, N. S. Kozulina // Dostizheniya nauki i tehniki APK. – 2021. – T. 35, № 11. – S. 53–58.
8. Shevcova, L. N. Ispol'zovanie oblachnyh servisov v upravlenii bazami dannyh i vzaimodeystvii sotrudnikov / L. N. Shevcova, V. V. Kalitina, A. S. Kuznecova // Rol' agrarnoy nauki v obespechenii prodovol'stvennoy bezopasnosti Sibiri. Materialy vserossiyskoy konferencii s mezhdunarodnym uchastiem. – Krasnoyarsk, 2022. – S. 143–147.
