Наука Красноярья (Nov 2020)
CREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING
Abstract
Developed database for optimal selection of agricultural machinery. An analytical review of today’s database management systems (DBMS) has shown that an easy-to-use, easy-to-implement DBMS for various software solutions is SBMS ite. Entities have been created in the relational database: land plots, agricultural machines, aggregates. Tables reflecting the traction and coupling properties of modern foreign and domestic tractors and units have been created using DBMSite. The essence of land plots is described by a set of geometric and attributive properties reflecting spatial (area, perimeter) and also technological properties of land plots. Such properties include: the length of the site gon, the soil energy intensity score, soil resistivity, soil rockiness, relief angle, relief inclination coefficient, internal distance, road group coefficient, relief inclination coefficient along the route. Practical implementation was carried out on the example of the economy of the Mirny Kochenevsky district of the Novosibirsk region using the geographic information system ArcGIS 10.6. The developed database allows the selection of agricultural machinery and can be used to compare the selection of different versions of machine-tractor units taking into account the technological properties of land plots. Methods: database design methods. Results: A database of agricultural machinery has been developed with the help of SOUNDite, containing tables of agricultural machinery (tractors and aggregates) and land plots. Information on land plots is structured in the spatial database of geodata ArcGIS 10 and includes information on the area, type of use, as well as technological properties associated with the traction and coupling properties of tractors. Application of the results: the developed database of agricultural machinery will allow further calculation of time costs in soil cultivation on a specific land plot.
Keywords
