CREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING
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,...
Guardado en:
| Autores principales: | , |
|---|---|
| Formato: | article |
| Lenguaje: | EN RU |
| Publicado: |
Science and Innovation Center Publishing House
2020
|
| Materias: | |
| Acceso en línea: | https://doaj.org/article/eaf9c7f1c81e4f9191dfb93085f5ecfa |
| Etiquetas: |
Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
| id |
oai:doaj.org-article:eaf9c7f1c81e4f9191dfb93085f5ecfa |
|---|---|
| record_format |
dspace |
| spelling |
oai:doaj.org-article:eaf9c7f1c81e4f9191dfb93085f5ecfa2021-12-02T17:21:02ZCREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING2070-756810.12731/2070-7568-2020-3-158-175https://doaj.org/article/eaf9c7f1c81e4f9191dfb93085f5ecfa2020-11-01T00:00:00Zhttp://journal-s.org/index.php/nk/article/view/12929https://doaj.org/toc/2070-7568Developed 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.Anna Illarionova PavlovaVitaly Vladimirovich TikhonovskyScience and Innovation Center Publishing Housearticleбаза данныхсельскохозяйственная техникатехнологические свойства земельных участковсистема управления базой данныхLawKSocial SciencesHENRUНаука Красноярья, Vol 9, Iss 3, Pp 158-175 (2020) |
| institution |
DOAJ |
| collection |
DOAJ |
| language |
EN RU |
| topic |
база данных сельскохозяйственная техника технологические свойства земельных участков система управления базой данных Law K Social Sciences H |
| spellingShingle |
база данных сельскохозяйственная техника технологические свойства земельных участков система управления базой данных Law K Social Sciences H Anna Illarionova Pavlova Vitaly Vladimirovich Tikhonovsky CREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING |
| description |
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. |
| format |
article |
| author |
Anna Illarionova Pavlova Vitaly Vladimirovich Tikhonovsky |
| author_facet |
Anna Illarionova Pavlova Vitaly Vladimirovich Tikhonovsky |
| author_sort |
Anna Illarionova Pavlova |
| title |
CREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING |
| title_short |
CREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING |
| title_full |
CREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING |
| title_fullStr |
CREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING |
| title_full_unstemmed |
CREATION OF DATABASE OF AGRICULTURAL MACHINERY TAKING |
| title_sort |
creation of database of agricultural machinery taking |
| publisher |
Science and Innovation Center Publishing House |
| publishDate |
2020 |
| url |
https://doaj.org/article/eaf9c7f1c81e4f9191dfb93085f5ecfa |
| work_keys_str_mv |
AT annaillarionovapavlova creationofdatabaseofagriculturalmachinerytaking AT vitalyvladimirovichtikhonovsky creationofdatabaseofagriculturalmachinerytaking |
| _version_ |
1718381057295777792 |