Development of a database for asynchronous validation of a tillage combine digital twin

Modern information systems process huge amounts of data, which have a complex structure and require high performance. To work effectively with such data, special software tools called database management systems (DBMS) are used. DBMS are a set of programs and language tools necessary for creating, processing and maintaining databases. Effective data management in a database plays a key role in ensuring its reliability and performance. Microsoft Access is a fully functional relational database system designed to run on the Windows operating system. Access allows you to create complex databases, define the structure of tables and establish relationships between them. It has a powerful system of inqueries, reports and forms of varying complexity. The purpose of the study is to develop a database of machines and implements for basic tillage, reflecting the parameters and characteristics of objects, agrotechnical and energy performance indicators for validating the digital twin of the tillage unit. The components of an augmented database are the tables, forms, reports, queries, macros and modules combined in a single MS Access file. The results of the conducted digital experiment are validated through field tests. The database is cumulative and is designed to store the information entered by the user. Using MS Access, an automated reference and information database of machines and aggregates for basic tillage has been created. The database has a structure that allows you to quickly search, add and edit data. The developed database of energy indicators and parameters of machines and implements for basic tillage allows you to store a large amount of information that is necessary for work in the agricultural sector. 

1. Kravchenko V.A., Kravchenko L.V., Melikov I.M. Evaluation of traction-chain properties of powerful tractors and combines complete with varieties of various performance. Agrarnyi nauchnyi zhurnal = Agrarian Scientific Journal, 2020, no. 8, pp. 83–88. (In Russian). DOI: 10.28983/asj.y2020i8pp83-88.

2. Parkhomenko G.G., Bozhko I.V., Kambulov S.I., Pakhomov V.I. Agrotechnical and energy performance of tillage tools. Inzhenernye tekhnologii i sistemy = Engineering Technologies and Systems, 2021, vol. 31, no.1, pp. 109– 126. (In Russian). DOI: 10.15507/2658-4123.031.202101.109-126.

3. Shcheglov D.K., Eshchenko M.N., Borina A.P., Ukhov A.A. Theoretical basis for application of digital twin concept for creation of AI-based system for monitoring the technical state and servicing of sophisticated science-intensive products. Sudostroenie = Shipbuilding, 2023, no. 5 (870), pp. 21–26. (In Russian).

4. Lamm A.K., Rasulov R.K. Generalized concept of feasibility study for the development of digital twins in agriculture. Ekonomika sel'skogo khozyaistva Rossii = Economics of Agriculture of Russia, 2023, no. 11. pp. 74–79. (In Russian). 5. Fedorenko V.F., Tarkivsky V.E. Digital wireless technology to measure agricultural performance. Sel'skokhozyaistvennye mashiny i tekhnologii = Agricultural Machinery and Technologies, 2020, vol. 14, no. 1, pp. 10–15. (In Russian). DOI: 10.22314/2073-7599-2020-14-1-10-15.

5. Tishchenko V.I. The digital twin phenomenon. Sciences of Europe = Sciences of Europe, 2021, no. 85–3, pp. 5–59. (In Russian). DOI: 10.24412/3162-2364-2021-85-3-51-59.

6. Ronzhin A.L., Savel’ev A.I. Artificial intelligence systems for solving problems of agro-industrial complex digitalization and robotization. Sel'skokhozyaistvennye mashiny i tekhnologii = Agricultural Machinery and Technologies, 2022, vol. 16, no. 2, pp. 22–29. (In Russian) DOI: 10.22314/2073-7599-2022-16-2-22-29.

7. Sidorov S.A., Lobachevskiy Ya.P., Mironov D.A., Zolotarev A.S. Influence of geometric and setup parameters of the arrangement of working tools on agrotechnical and power characteristics. Sel'skokhozyaistvennye mashiny i tekhnologii = Agricultural Machinery and Technologies, 2020, vol. 14, no. 2, pp. 10–16. (In Russian). DOI: 10.22314/2073-7599-2020-14-2-10-16.

8. Lobachevsky Ya.P., Mironov D.A., Kislitsky M.M., Mironova A.V. Digital twins use effects in agriculture. Trudy Kubanskogo gosudarstvennogo agrarnogo universiteta = Proceedings of the Kuban State Agrarian University, 2023, no. 103, pp. 71–78. (In Russian). DOI: 10.21515/1999-1703-103-71-78.

9. Kambulov S.I., Parkhomenko G.G., Bozhko I.V., Boiko A.A. Results of experimental studies of the seed drill for row sowing SZD-4.0. Sel'skokhozyaistvennye mashiny i tekhnologii = Agricultural Machinery and Technologies, 2020, vol. 14, no. 2. pp. 41-45. (In Russian). DOI: 10.22314/2073-7599-2020-14-2-41-55.

10. Smirnova G.S., Sabitov R.A., Sirazetdinov R.T., Eponeshnikov A.V., Sabitov S.R. A model of sustainable development processes for the digital twin of agricultural production. Informatsionnye tekhnologii i vychislitel'nye sistemy = Information Technologies and Computing Systems, 2022, no.4, pp. 93–102. (In Russian). DOI: 10.14357/20718632210409.

11. Gusev Yu.P., Trofimov A.V.1, Trofimov V.A. Project database of CAD system as the basis of the digital twin of the automation system of power plants and substations. Elektricheskie stantsii = Electrical stations, 2020, no. 3 (1064), pp. 27–32. (In Russian).

12. Myalenko V.I. Development of a digital model of the agricultural tool working element. Sel'skokhozyaistvennye mashiny i tekhnologii = Agricultural Machinery and Technologies, 2020, vol. 14, no. 4, pp. 57–62. (In Russian). DOI: 10.22314/2073-7599-2020-14-4-57-62.

13. Ivanov V.A., Konyshev M.Yu., Smirnov S.V., Tarakanov O.V., Tarakanova V.O., Usovik S.V. Semantic interpretations of high normal forms of relations in a relational database. Sistemy i sredstva informatiki = Systems and Means of Informatics, 2023, vol. 33, no.1, pp. 45–58., (In Russian). DOI: 10.14357/08696527230105.