Romanenko A. Development of an efficient database for geophysical and surveying monitoring for the Geodata Zones System
- Details
- Parent Category: Geo-Technical Mechanics, 2024
- Category: Geo-Technical Mechanics, 2024, Issue 169
Geoteh. meh. 2024, 169, 86-95
DEVELOPMENT OF AN EFFICIENT DATABASE FOR GEOPHYSICAL AND SURVEYING MONITORING FOR THE GEODATA ZONES SYSTEM
Romanenko A.
Technical University "Metinvest Polytechnic" LLC
UDC 622.1
Language: English
Abstract. This article delves into the development of an advanced database aimed at integrating and analyzing geophysical and surveying data within the GeoDATA Zones monitoring system, specifically tailored for quarry applications. Modern mining operations face significant risks such as landslides, collapses, and other geological hazards due to inadequate data management practices. The GeoDATA Zones system addresses these challenges by implementing innovative data processing methods using machine learning and artificial intelligence algorithms. This article's primary goal is to showcase how the development of a structured database can improve the speed, accuracy, and reliability of geophysical and surveying data analysis, which in turn supports more effective decision-making processes.
Key factors influencing the stability of rock masses, including geological formations, physical properties of rocks, fracturing, and the impact of ongoing mining activities, are thoroughly explored. The article also examines environmental influences, such as water saturation and seismic activities, which can further destabilize rock structures. Furthermore, the article highlights the critical role that a well-structured database plays in ensuring data integrity, security, and scalability, while also enabling integration with other systems utilized in the mining sector. The database design considers logical and physical structures, with Microsoft SQL Server being the primary database management system. Additionally, visualization tools such as Power BI are leveraged to enhance data interpretation, analysis, and reporting capabilities for real-time decision-making.
The development process incorporates robust security measures, including multi-level user authentication, data encryption, and access control protocols to safeguard against unauthorized access and ensure the system's resilience. Research findings suggest that GeoDATA Zones can significantly improve the efficiency, safety, and sustainability of mining operations, thereby contributing to the long-term success of mining enterprises. This solution fosters proactive decision-making and risk mitigation, aligning with the industry's push toward more sustainable and environmentally conscious mining practices.
Keywords: geophysical condition, rock mass stability, database management, void detection in rock formations, machine learning, mining safety, data integration, sustainable mining practices.
REFERENCES
1. Cherniaiev, O., Pavlychenko, A., Romanenko, O. and Vovk, Y. (2021), “Substantiation of resource-saving technology when mining the deposits for the production of crushed-stone products”, Mining of Mineral Deposits, vol. 15, pp. 99–106. https://doi.org/10.33271/mining15.04.099.
2. Carvalho, F.P. (2017), “Mining industry and sustainable development: time for change”, Food and Energy Security, vol. 6(2), pp. 61–77. https://doi.org/10.1002/FES3.109.
3. Gorova, A., Pavlychenko, A., Borysovs’ka, O. and Krups’ka, L. (2013), “The development of methodology for assessment of environmental risk degree in mining regions”, Mining of Mineral Deposits, pp. 207–209. https://doi.org/10.1201/b16354-38.
4. Kravets, M.A. and Iskov, S.S. (2022), “Directions for reclamation of disturbed lands”, Materials of the Conference of the State University "Zhytomyr Polytechnic", p. 57, available at: https://conf.ztu.edu.ua/wp-content/uploads/2022/01/57.pdf (Accessed 5 June 2024).
5. Shamsi, M., Pourrahimian, Y. and Rahmanpour, M. (2022), “Optimisation of open-pit mine production scheduling considering optimum transportation system between truck haulage and semi-mobile in-pit crushing and conveying”, International Journal of Mining, Reclamation and Environment, vol. 36(2), pp. 142–158. https://doi.org/10.1080/17480930.2021.1996983.
6. Abbaspour, H., Drebenstedt, C., Paricheh, M. and Ritter, R. (2019), “Optimum location and relocation plan of semi-mobile in-pit crushing and conveying systems in open-pit mines by transportation problem”, International Journal of Mining, Reclamation and Environment, vol. 33(5), pp. 297–317. https://doi.org/10.1080/17480930.2018.1435968.
7. Symonenko, V.I., Haddad, J.S., Cherniaiev, O.V., Rastsvietaiev, V.O. and Al-Rawashdeh, M.O. (2019), “Substantiating systems of open-pit mining equipment in the context of specific cost”, Journal of The Institution of Engineers (India): Series D, 100, pp. 301–305. https://doi.org/10.1007/s40033-019-00185-2.
8. Ishchenko, K., Konoval, V. and Lohvyna, L. (2019), “An effective way to rock mass preparation on metallic and nonmetallic quarries Ukraine”, E3S Web of Conferences, 109, 00031. https://doi.org/10.1051/e3sconf/201910900031.
9. Braun, T., Hennig, A. and Lottermoser, B.G. (2017), “The need for sustainable technology diffusion in mining: Achieving the use of belt conveyor systems in the German hard-rock quarrying industry”, Journal of Sustainable Mining, vol. 16(1), pp. 24–30. https://doi.org/10.1016/J.JSM.2017.06.003.
10. Dryzhenko, A., Moldabayev, S., Shustov, A., Adamchuk, A. and Sarybayev, N. (2017), “Open pit mining technology of steeply dipping mineral occurrences by steeply inclined sublayers”, International Multidisciplinary Scientific GeoConference Surveying Geology and Mining Ecology Management, SGEM, vol. 17(13), pp. 599–606. https://doi.org/10.5593/sgem2017/13/s03.076.
11. Kovrov, O., Babiy, K., Rakishev, M. and Kuttybayev, A. (2016), “Influence of watering filled-up rock massif on geomechanical stability of the cyclic and progressive technology line”, Mining of Mineral Deposits, vol. 10(2), pp. 55–63. https://doi.org/10.15407/mining10.02.055.
About the author:
Romanenko Andrii, Candidate of Technical Sciences (Ph.D), student of group 122-23-1-M, Technical University "Metinvest Polytechnic" LLC, Zaporizhzhia, Ukraine, This email address is being protected from spambots. You need JavaScript enabled to view it. , ORCID 0000-0002-8381-8873