Annotation

Purpose: to analyze research on the use of digital technologies for irrigation systems, the results of which can be used in formulating requirements for the structure and functionality of database for reclamation systems and hydraulic structures. 

Discussion. An analysis of existing digital solutions for the reclamation industry showed that they are primarily focused on calculations at the level of agricultural producers and do not provide a visual display of the obtained data, georeference, or interactive communication with the user. Most developments are focused on in-farm planning, while the level of systems and operating organizations is not presented in sufficient detail. Examples with object visualization are not always convenient for calculations. Database should be reliable, easy-to-use, and scalable. At the initial stage, the recorded objects are determined, including elements of reclamation systems: linear (canals) and point (pumping stations, water outlets), as well as land areas and environmental parameters. Each object is classified according to various criteria and contains data on its name, type, status, characteristics, location, owner, and other information. The database structure is designed to integrate spatial and attribute data, track changes over time, and normalize information. Database functionality should support data entry, editing, and storage, report generation, decision support, analytical capabilities, data import from GIS, integration with Earth remote sensing systems, and exchange with enterprise resource planning systems. 

Conclusions. Developing a product that combines visualization, interactive communication, and the ability to execute user queries and calculations is relevant.

doi: 10.31774/2712-9357-2025-15-4-84-108

For quoting

Voyevodina L. A., Myachin M. A. Requirements for database structure and functionality of the reclamation systems and hydraulic structures. Land Reclamation and Hydraulic Engineering. 2025;15(4):84–108. (In Russ.). https://doi.org/10.31774/2712-9357-2025-15-4-84-108.

Bibliography

1. Senchukov G.A., Voyevodina L.A., 2023. [Water resources use in federal reclamation industry institutions]. Melioratsiya i gidrotekhnika, vol. 13, no. 1, pp. 101-117, DOI: 10.31774/2712-9357-2023-13-1-101-117, EDN: ILBYIM. (In Russian).

2. Senchukov G.A., Voyevodina L.A., Kolganov A.V., 2024. Federal'nye vodokhozyaystvennye sistemy v razreze basseynovykh okrugov Rossiyskoy Federatsii [Federal water management systems by basin districts of the Russian Federation]. Ekologicheskiy vestnik Severnogo Kavkaza [Ecological Bulletin of the North Caucasus], vol. 20, no. 1, pp. 162-166, EDN: WIIQPD. (In Russian).

3. Gelman T.Ya., 1986. Vnedrenie tekhnologii planirovaniya vodopolzovaniya i vodoraspredeleniya s pomoshchiyu EVM na gidromeliorativnykh sistemakh Rostovskoy oblasti [Introduction of water use and water allocation planning technology with the help of computer at the irrigation and drainage systems of Rostov region]. Gidrotekhnicheskie sooruzheniya i voprosy ekspluatatsii gidrotekhnicheslikh system: sb. nauch. tr. [Hydraulic Structures and Operation of Irrigation Systems: collection of scientific papers]. Novocherkassk, YuzhNIIGiM, pp. 63-69. (In Russian).

4. Brusilovsky R.D., Zhuravel L.F., Krushel E.G., Sokol G.F., Sharapov N.P., 1984. Bazovaya ASU ekspluatatsiey gidromeliorativnykh sistem Krasnodarskogo Krayvodkhoza [Basic automated control system for the operation of irrigation and drainage systems of the Krasnodar Kraivodkhoz]. Gidrotekhnika i melioratsiya [Hydraulic Engineering and Land Reclamation], no. 9, pp. 51-53. (In Russian).

5. Olgarenko V.Iv., Olgarenko I.V., Selyukov V.I., Dorozhkina O.P., Olgarenko V.Ig., Berlizov D.A., Nazarenko V.A., Dokuchaev V.V., Dorozhkin V.P., 2012. Metodologiya sostavleniya planov vodopol'zovaniya na orositel'nykh sistemakh s ispol'zovaniem informatsionnykh tekhnologiy [Methodology for drawing up water use plans for irrigation systems using information technologies]. Donskaya agrarnaya nauchno-prakticheskaya konferentsiya «Innovatsionnye puti razvitiya agropromyshlennogo kompleksa: zadachi i perspektivy». Sektsiya: Rol' melioratsii, lesnogo i vodnogo khozyaystva v razvitii agrarnogo sektora: vseros. sb. nauch. tr. [Don Agrarian Scientific and Practical Conference “Innovative Ways of Developing the Agro-Industrial Complex: Tasks and Prospects”. Section: The Role of Land Reclamation, Forestry and Water Management in the Development of the Agricultural Sector: All-Russian collection of scientific papers]. Zernograd, pp. 159-162, EDN: SIXCSP. (In Russian).

6. Olgarenko V.I., Olgarenko I.V., Selyukov V.I., 2012. Komp'yuternaya tekhnologiya planirovaniya vodopol'zovaniya v orositel'nykh sistemakh [Computer technology for water use planning in irrigation systems]. Vestnik Rossiyskoy akademii sel'skokhozyaystvennykh nauk [Bulletin of the Russian Academy of Agricultural Sciences], no. 4, pp. 12-15, EDN: PDFSKX. (In Russian).

7. Olgarenko V.I., Selyukov V.I., Olgarenko I.V., 2012. Algoritm formirovaniya i rascheta plana poseva i poliva sel'skokhozyaystvennykh kul'tur s ispol'zovaniem informatsionnykh tekhnologiy [Algorithm for forming and calculating a plan for sowing and watering agricultural crops using information technologies]. Izvestiya Nizhnevolzhskogo agrouniversitetskogo kompleksa: nauka i vysshee professional'noe obrazovanie [Proceedings of the Lower Volga Agro-University Complex: Science and Higher Education], no. 1(25), pp. 124-129, EDN: OWIDYD. (In Russian).

8. Olgarenko I.V., Selyukov V.I., 2011. Programmnoe obespechenie protsessa planirovaniya vodopol'zovaniya na orositel'nykh sistemakh [Software for water utilization planning process on irrigation systems]. Prirodoobustroystvo [Environmental Engineering], no. 4, pp. 38-40, EDN: OIMORT. (In Russian).

9. Olgarenko V.I., Olgarenko G.V., Olgarenko I.V., Nazarenko V.A., Dokuchaev V.V., 2017. Programmnyy kompleks planirovaniya vodopol'zovaniya dlya orositel'nykh sistem na osnove informatsionnykh tekhnologiy [Software package for planning water use for irrigation systems based on information technology]. Melioratsiya i vodnoe khozyaystvo [Land Reclamation and Water Management], no. 5, pp. 39-43, EDN: ZSBQNV. (In Russian).

10. Olgarenko V.I., Olgarenko I.V., Olgarenko V.I., Korzhov I.V., 2024. [Operational dispatch control of water distribution in irrigation systems according to the calculated increment of volumes]. Melioratsiya i vodnoe khozyaystvo, no. 3, pp. 36-42, DOI: 10.32962/0235-2524-2024-3-36-42, EDN: IFPDWG. (In Russian).

11. Polukhina E.V., 2014. Case-study kak issledovatel'skaya strategiya [Case-study as a research strategy]. Case-study – obrazovatel'nyy i issledovatel'skiy opyt v mezhdistsiplinarnom kontekste: sb. nauch. st. po itogam mezhdistsiplinar. nauch. seminara kadrovogo rezerva «Problemy i perspektivy ispol'zovaniya metoda case-study: mezhdistsiplinarnyy opyt» [Case-study – Educational and Research Experience in an Interdisciplinary Context: Collection of scientific articles based on the results of Interdisciplinary Scientific Seminar of the Personnel Reserve “Problems and Prospects of Using the Case-Study Method: Interdisciplinary Experience”]. St. Petersburg, Department of Operational Printing, National Research University Higher School of Economics, pp. 5-21. (In Russian).

12. Varganova G.V., 2006. Keys-stadis kak metod nauchnogo issledovaniya [Case study as a method of scientific research]. Bibliosfera [Bibliosphere], no. 2, pp. 36-42, EDN: HSNGPP. (In Russian).

13. Johansson R., 2007. On case study methodology. Open House International, vol. 32, no. 3, pp. 48-54, DOI: 10.1108/OHI-03-2007-B0006.

14. Litskas V., Vourlioti P., Mamouka Th., Kotsopoulos S., Paraskevas Ch., 2023. Sustainable water resources management under climate change: A case study with potato irrigation in an insular Mediterranean environment. Hydrology, vol. 10, no. 12, article number: 218, DOI: 10.3390/ hydrology10120218, EDN: WVRZWD.

15. Rios-Rojas L., Ordonez-Córdoba J., Bulla B., Gómez O., Enciso R., Martínez M., 2024. IoT network to water management in an irrigation district: Study case in Colombia. Journal of Applied Research and Technology, vol. 22, no. 2, pp. 206-218, https:doi.org/10.22201/icat.24486736e.2024.22.2.2274, EDN: JOUSPA.

16. Nuamcharoen S., 2024. The co-production and sustainability policies: Multi-case study in water management policies in Thailand. Asia Social Issues, vol. 17, no. 3, e264180, 17 р., DOI: 10.48048/asi.2024.264180, EDN: UTAGIN.

17. Purwanto H.B., Sunarto S., Setyono P., Rindarjono M.G., Rachmadhan A.A., Sakti M.B.G., Hidayat A., 2024. Water resources management model based on regional development: Case study of Magetan Regency, Indonesia. Tropical and Subtropical Agroecosystems, vol. 27, no. 1, article number: 029, 23 p., DOI: 10.56369/tsaes.5106, EDN: DOBAII.

18. Sawassi A., Khadra R., Crookston B., 2024. Water banking as a strategy for the management and conservation of a critical resource: A case study from Tunisia’s Medjerda River Basin (MRB). Sustainability, vol. 16, iss. 9, article number: 3875, 20 p., DOI: 10.3390/su16093875, EDN: VAUZCT.

19. Poncin M., Ogilvie A., Descroix L., Chariag I., Balique C., 2024. How does a master plan contribute to strengthening transboundary water management? A case study in West Africa. Water International, vol. 49, no. 3-4, pp. 503-516, DOI: 10.1080/02508060.2024.2321785, EDN: TQTTTB.

20. Olgarenko V.I., Olgarenko I.V., Korzhov I.V., Olgarenko V.I., 2024. [Principles of using information technology in organizing and conducting water use planning in irrigation systems]. Melioratsiya i gidrotekhnika, vol. 14, no. 3, pp. 100-115, DOI: 10.31774/2712-9357-2024-14-3-100-115, EDN: URAPHZ. (In Russian).

21. Matveev A.V., 2024. Programmnye komponenty veb-GIS-sistemy dlya obosnovaniya resheniy po upravleniyu meliorativno-vodokhozyaystvennym kompleksom Respubliki Kalmykiya [Software components of a web GIS system for substantiating decisions on managing the reclamation and water management complex of the Republic of Kalmykia]. Melioratsiya i oroshaemoe zemledelie v reshenii zadach ustoychivogo razvitiya APK: k 100-letiyu Vserossiyskogo nauchno-issledovatel'skogo instituta gidrotekhniki i melioratsii im. A. N. Kostyakova: sb. st. [Land Reclamation and Irrigated Agriculture in Solving Problems of Sustainable Development of the Agro-Industrial Complex: on the 100th Anniversary of the All-Russian Research Institute of Hydraulic Engineering and Land Reclamation of A.N. Kostyakov: collection of articles]. Moscow, Federal Scientific Center VNIIGIM named after A. N. Kostyakov, pp. 139-149, DOI: 10.37738/VNIIGIM.2024.50.70.015, EDN: DOHIHO. (In Russian).

22. Ryzhakov A.N., Kuzmichev A.A., Martynov D.V., 2023. [Development of the geoinformation database “Ponuro-Kalinin “Water Management System”]. Puti povysheniya effektivnosti oroshaemogo zemledeliya, vol. 91, no. 3, pp. 238-249, EDN: YNZVUX. (In Russian).

23. Rosas-Chavoya M., Gallardo-Salazar J.L., López-Serrano P.M., Alcántara-Concepción P.C., León-Miranda A.K., 2022. QGIS a constantly growing free and open-source geospatial software contributing to scientific development. Cuadernos de Investigación Geográfica, vol. 48, no. 1, pp. 197-213, DOI: 10.18172/cig.5143, EDN: CNGXPW.

24. Moyroud N., Portet F., 2018. Introduction to QGIS (Chapter 1). QGIS and Generic Tools, vol. 1, pp. 1-17, DOI: 10.1002/9781119457091.ch1.

25. Graser A., Olaya V., 2015. Processing: A Python framework for the seamless integration of geoprocessing tools in QGIS. ISPRS International Journal of Geo-Information, vol. 4, no. 4, pp. 2219-2245, DOI: 10.3390/ijgi4042219.

26. Stallman R., 2015. Free Hardware and Free Hardware Designs, available: https:www.gnu.org/philosophy/free-hardware-designs.en.html [accessed 16.05.2025].

27. Suyunduk U.K., Askaraliev B.O., Mamatov N.E., Omurzakov K.E., Askaraliev T.B., 2019. Analiz sostoyaniya oroshaemykh zemel' v basseyne reki Alamedin s primeneniem GIS tekhnologiy (QGIS) [Analysis of the state of irrigated lands in the Alamedin River basin using GIS technologies (QGIS)]. Vestnik Kyrgyzskogo natsional'nogo agrarnogo universiteta im. K. I. Skryabina [Bulletin of Kyrgyz National Agrarian University named after K. I. Skryabin], no. 1(50), pp. 136-140, EDN: EJTYBL. (In Russian).

28. Dedova E.B., Isaeva S.D., Matveev A.V., Shabanov R.M., 2024. Veb-GIS-sistema dlya obosnovaniya resheniy po integral'nomu upravleniyu meliorativno-vodokhozyaystvennym kompleksom [Web GIS system for substantiating decisions on integrated management of reclamation and water management complex]. Melioratsiya i vodnoe khozyaystvo [Land Reclamation and Water Management], no. 4, pp. 47-51, EDN: QWWNQX. (In Russian).

29. Voyevodina L.A., Myachin M.A., 2024. [The reclaimed land registering in the Russian Federation]. Melioratsiya i gidrotekhnika, vol. 14, no. 2, pp. 236-259, DOI: 10.31774/2712-9357-2024-14-2-236-259, EDN: XJACLY. (In Russian).

30. Ponin F.N., 2024. Metodologiya proektirovaniya i sozdaniya baz dannykh dlya sovremennogo programmnogo obespecheniya [Methodology of designing and creating databases for modern software]. Universum: tekhnicheskie nauki [Universum: Technical Sciences], no. 1-1(118), pp. 16-20, DOI: 10.32743/UniTech.2024.118.1.16666, EDN: NITAHM.