DATABASE FOR AGROECOLOGICAL ASSESSMENT OF AGRICULTURAL LAND
https://doi.org/10.26898/0370-8799-2018-1-11
Abstract
Databases have been created to form models of knowledge representation and geoinformation modeling of regional standards for the assessment and grouping of agricultural lands. The process of creating databases included the main stages: designing a conceptual domain model, logical and physical design. At the initial stage of the design, when developing the conceptual model, a choice was made of the type of data organization. High-level entities in the databases are defined by Climate, Relief, Soil and Culture. The basis is an object-oriented relational model with the possibility of its further use for geomodels constructing. The application of object-oriented technology gives system properties of the geoinformation model and allows creating a natural hierarchy of territorial objects, as well as the processes of interaction between them, ensuring the functioning of the system as a whole. A complex system of describing natural conditions and factors associated with agricultural lands in the form of interconnected tables is created in which the information object is represented as a named set of units or entities with a given structure. The analysis of functioning and support of statistical data processing, necessary connections with the server and database tables is performed. At the stage of physical implementation, a program was developed for accessing and working with databases. It is possible to upgrade and adapt the databases for making changes, optimizing the functioning and modifying the program. Information from external data sources is updated in the form of Excel files or other database formats that are compatible with MS SQL Server 2012 database management system.
About the Authors
A. I. Pavlova
Siberian Federal Scientific Center of Agro-Bio Technologies RAS
Russian Federation
Russian Federation
Candidate of Technical Sciences, Leading Researcher
Krasnoobsk, Novosibirsk region, 630501, Russia
V. K. Kalichkin
Siberian Federal Scientific Center of Agro-Bio Technologies RAS
Russian Federation
Russian Federation
Doctor of Agricultural Sciences, Chief Researcher
Krasnoobsk, Novosibirsk region, 630501, Russia
References
1. Agroekologicheskaya otsenka zemel’, proektirovanie adaptivno-landshaftnykh sistem zemledeliya i agrotekhnologii. Metodicheskoe rukovodstvo / Pod red. V.I. Kiryushina, A.L. Ivanova. – M.: FGNU «Rosinformagrotekh», 2005. – 784 s.
2. Glazunov G.P., Afonchenko N.V., Sanzharov A.I. Struktura bazy dannykh agroekologicheskoi otsenki zemel’ // Dostizheniya nauki i tekhniki APK. – 2015. – T. 29., № 8. – S. 72–76.
3. Glazunov G.P., Afonchenko N.V., Sanzharov A.I. Programmnye sredstva informatsionno- spravochnoi sistemy dlya agroekologicheskoi otsenki zemel’ // Vestnik Kurskoi GSKhA. – 2016. – № 8. – S. 58–63.
4. Petrushin A.F. Kompleks programm formirovaniya i obrabotki baz dannykh i znanii v agronomii: avtoref. dis. … kand. tekhn. nauk. – SPb.: AFI, 2005. – 163 s.
5. Lutsenko E.V., Loiko V.I., Velikanova L. O. Postanovka zadachi i sintez mode-li prognozirovaniya urozhainosti zernovykh kolosovykh i podderzhki prinyatiya reshenii po ratsional’nomu vyboru agrotekhnologii // Nauchnyi zhurnal KubGAU. – 2008. – № 38(4). – S. 1–21.
6. Pruzhin M.K., Plotnikova T.A. Formirovanie baz dannykh dlya podderzhki komp’yutizirovannykh agrotekhnologii // Vestn. Kurskoi GSKhA. – 2012. – T. 1, Vyp. 1. – S. 134–135.
7. Pruzhin M.K., Plotnikova T.A. Osobennosti sozdaniya relyatsionnoi bazy dan-nykh dlya proektirovaniya agrotekhnologii // Nauchnoe obespechenie agropromysh-lennogo proizvodstva (materialy Mezhdunar. nauchn.-prakt. konfer., 29–31 yan-varya 2014 g., Kursk,). – Kursk: Kurskaya GSKhA im. I.I. Ivanova, 2014. – Ch. 1. – S. 10–12.
8. Stepnykh N.V., Zargaryan A.M., Zhukova O. A. Komp’yuternaya programma po pro- ektirovaniyu tekhnologii vyrashchivaniya sel’khozkul’tur // Agrarnyi vestnik Urala. – 2017. – № 3 (157). – S. 54–58.
9. Il’inykh A.L. Razrabotka bazy dannykh avtomatizirovannoi informatsionnoi sistemy monitoringa zemel’ sel’skokhozyaistvennogo naznacheniya // Sb. mater. VII Mezhdunar. nauchn. kongressa «Geo-Sibir’–2011», 19–29 aprelya 2011 g., Novosibirsk. – Novosibirsk: SGGA, 2011. – T. 3, ch. 2. – S. 120–124.
10. Il’inykh A.L. Struktura i soderzhanie bazy dannykh avtomatizirovannoi informatsionnoi sistemy monitoringa zemel’ sel’skokhozyaistvennogo naznacheniya // Vestn. SGUGiT. – 2012. – № 1 (17). – S. 79– 84.
11. Konnolli T., Begg K. Bazy dannykh. Proektirovanie, realizatsiya i soprovozh- denie. Teoriya i praktika = Database Systems: A Practical Approach to Design, Im- plementation, and Management. – M.: Vil’yams, 2003. – 1436 s.
12. Deit K. Dzh. Vvedenie v sistemy baz dannykh = Introductionto Database Systems. – M.:Vil’yams, 2006. – 8-e izd. – 1328 s.
13. Microsoft SQL Server. https://www.microsoft.com/ru-RU/download/details.aspx?id=29062 (data obrashcheniya 14.04.2017).
14. Petkovich D. Microsoft SQL Server 2012. – SPb.: BKhV-Peterburg, 2013. – 816 s.
15. Kogalovskii M.R. Entsiklopediya tekhnologii baz dannykh. – M.: Finansy i statistika, 2002. – 800 s.
16. Dwyer Barry Data Base Technology // Systems Analysis and Synthesis Bridging Computer Science and Information, 2016, – Chapter 6. – P. 169–202.
17. Post G.V., Kagan A. Comparison of Database Management Systems // Journal of Computer Information Systems, 2001. – Vol. 41, Issue 4. – P. 43–46.
18. Batra D., Zanakis S.H. A conceptual database design approach based on rules and heuristics // European Journal of Information Systems. – 1994. – Vol. 3, Issue 3. – P. 228–239.
19. Mikroklimat kholmistogo rel’efa i ego vliyanie na sel’skokhozyaistvennye kul’tury / Pod red. I.A. Gol’tsberg. – L.: Gidrometeoizdat, 1962. – 250 s.
20. Reingard Ya.R., Bevzova M.S., Reingard L. M. Izmenenie osnovnykh pokazate-lei svoistv zonal’nykh pochv yuga Zapadnoi Sibiri pod vliyaniem erozionnykh i deflyatsionnykh protsessov: (na primere Omskoi obl.). – Omsk: Sfera, 2007. – 222 s.
Review
For citations:
Pavlova A.I., Kalichkin V.K. DATABASE FOR AGROECOLOGICAL ASSESSMENT OF AGRICULTURAL LAND. Siberian Herald of Agricultural Science. 2018;48(1):80-88. (In Russ.) https://doi.org/10.26898/0370-8799-2018-1-11
Views:
565
Email this article 