Application and Analysis of Database Management System in Production and Distribution of Sandak Open-pit Mine
Shandak open-air copper-gold mine after nearly a decade of mining, ore production management is also improving. However, at present, the mine has entered deep mining, and the effective area of ​​the working steps is getting less and less. The negative change of the step ore leads to a sharp decrease in the amount of minerals in the boundary, and the transition of the ore and rock is mostly in abrupt state, and the ore grade changes are not obvious. The law has made it increasingly difficult to manage the distribution of minerals. In order to strengthen the management of production ore distribution and improve the utilization rate of resources, this study uses Excel as the management platform and combines the Microsoft SQL Server database to establish a management system for the distribution and distribution of the Shandak open-pit mine. Through the statistical analysis of the production and distribution data, the ore-matching rules are summarized. To improve the quality of the ore,
It has realized the intelligent management of production and distribution data and the refined management of production and distribution.
1 geological overview
Shandak Copper Gold porphyry copper type metal hydrothermal alteration, alteration lithology center outward from an open state is gradually reduced, followed by potassium cloud England diorite porphyry → sericite cloud England diorite Porphyry → Qingpan lithified siltstone (Qingdang lithification Yunying diorite porphyry). The ore body is a sub-ring-shaped ore belt extending in the NNW direction on the plane, and has an upright cylindrical shape in the section [1]. In the production process, in order to facilitate the distribution management, the production grade ore is divided into high grade ore according to the grade of copper: high grade ore HG (>0.5%), ordinary mine ORE (0.25%~0.5%) and off-balance mine LG (0.2% to 0.25%). Figure 1 shows the typical step geological plan. The ore of each area has different degrees of interlaced stone. The ore boundary is mostly abrupt and distributed irregularly. The whole body presents a “honeycomb shape†with no obvious rules.
2 Establishment of production and distribution database management system
2.1 Main factors affecting production ore distribution [2]
The quality index of Shandak open-pit copper-gold mine is: the daily supply grade is controlled at 0.3%-0.5%; the monthly supply grade is controlled at 0.395%-0.45%; the ore loss rate and the depletion rate Within 3% of control, the ore block rate is controlled within a reasonable range (subject to not affecting the production of the plant). According to the investigation and analysis, the main influencing factors of the mineralization quality of Shandak Open-pit Mine are as follows: 1 The on-site monitoring of the ore distribution is insufficient. At present, the mining depth has reached more than 200 m. The ore-dispensing personnel need to calculate the ore grade in the office, according to the calculation results. The operation area is confirmed on the spot, and the site has many distribution points, and the grade changes greatly. It needs to be repeatedly calculated and adjusted, which seriously affects the on-site management quality of the ore-distributing personnel. 2 The peeling is not thorough. Due to the large changes in the site geology, it is easy to produce ore. The boundary stripping is not complete, the stone removal is not clean, causing the rock to mix in, increasing the depletion rate of the ore; 3 the blasting effect is poor, which is manifested in the large displacement of the blasting pile, especially when the blasting of the blasting blast is mixed and the large block exceeds the standard; The distribution of ore rocks is complex, the transition is abrupt, and there is no obvious law, resulting in inaccurate grades during ore blending.
2.2 The principle of establishment of production and distribution database
The previous calculation of the ore grade of the Shanda Copper and Gold Mine was mainly the combination of artificial and Excel. However, with the accumulation of relevant ore data, it is very difficult to find relevant laws from the complicated data, and the problems of data query, storage and security are highlighted.
Microsoft SQL (StructuredQuerylanguage) Server database technology has been widely used in different industries, from small single item processing systems to large information systems, more and more applications use database storage and processing information resources [3]. Excel and Microsoft SQL Server database can not only play Excel's data processing capabilities, but also ensure data storage, security and fast multi-condition query.
With Excel as the management platform, through ADO (Microsoft ActiveXDataObjects2.xLibrary) object library reference, the purpose of connecting and managing SQL Server database is achieved. At the same time, the management technology of the database itself can affect Excel by adjusting data, and realize the two-way data between Excel and SQLServer. Communication, as shown in Figure 2.
2.3 The function of the distribution and distribution database The distribution database is managed in two ways: 1 using Excel as the development platform, compiling the user form, controlling the connection and management with the database through the form component; 2using the management technology of the SQLSever database itself To adjust the data as a supplement to the first method. Figure 3 and Figure 4 show the "login interface" and "daily work interface" in the management system compiled by VBA secondary development language on the Excel platform.
3 Application and analysis of the distribution database
3.1 combined with AutoCAD
Entering the AutoCAD environment from the daily work interface, according to the mining requirements and working area of ​​each shift, the production and distribution weights are arranged. After adjusting to the required ore grade, the dispatch management personnel enters the site to mark the operation area, and arranges the shovel for production and distribution. mine. According to the site situation, the work area and the number of vehicles can be adjusted at any time, and the database automatically displays the adjusted results.
By querying the daily production and distribution data, you can find detailed information such as the time, work steps, shifts, shovel, watchman, grade, etc. in the shovel loading map (Fig. 5), and mark it in the production shovel loading map.
3.2 multi-condition query
After importing the ore data into the database, it can be conveniently queried according to multiple conditions such as date, grade, shift, and operation shovel, as shown in Figure 6.
3.3 Analysis of the distribution data on duty
Combine the matching data with the ore processing data to analyze the relationship between the ore grade and the return grade, and calculate the distribution location of the returned grade abnormality, and divide the ore distribution area into “calculated grade less than the return grade†on the shovel loading map. Area", "calculated grade is greater than return grade area" and "normal area", automatic warning when the operation reaches the guide area. Figure 7 is the interface for statistical analysis of Class A mineralization data on April 1, 2013.
3.4 analysis of the application effect of the distribution database management system
Considering the large amount of data information, the data information of April-April 2012-2015 is randomly selected from the database for comparison (Figure 8).
3.4.1 Pre-application situation of the distribution database management system
Figure 8(a) is a comparison of the daily return grade and planned grade in April 2012 before the application of the mine database management system. From the figure, it can be calculated that the confidence range of the daily return grade fluctuation range satisfying the 95% confidence level is (0.3987, 0.4187), the mean value of the ore grade is 0.404%, the fluctuation range is ±3.59%, and 4 The grade on the 4th of the month exceeded 0.5%.
3.4.2 After the application of the mine database management system
From Fig. 8(b) to Fig. 8(c), it can be calculated that the confidence intervals for the daily return grade fluctuation range satisfying the 95% confidence level are (0.3959, 0.4161), (0.4029, 0). .4240) and (0.4222, 0.4408), the mean value of the mined grades are 0.406%, 0.413% and 0.432%, respectively, the fluctuation range is ±2.49%, ±2.56%
And ±2.15%.
3.4.3 Application effect of the distribution database management system
Through comparative analysis, it can be seen that the deviation and dispersion of daily return grade and planned grade after application of the distribution data management system are smaller than before application, and the daily return grade fluctuation range satisfies the confidence interval of 95% confidence level, and the fluctuation range Gradually stable, much less than the fluctuation range of ±3.59% before application, indicating the application of the distribution database management system, and comprehensively improved the quality of ore.
4 Conclusion
(1) Due to the complexity of the ore body in Shandaknan open pit and the uneven distribution of grades, improving the quality of ore supply and controlling the quality of ore supply has become the focus of production. The modernization method of the distribution database management system is used for production and distribution management. necessary.
(2) Using the distribution database management system to improve the convenience of production and distribution, so that the ore personnel have more time for on-site supervision and management.
(3) The distribution database management system has functions such as ore calculation, multi-condition inquiry, comparative analysis, automatic alarm, etc., which realizes the intelligentization of production and distribution and improves the quality of production and distribution.
references
[1] Yu Mingshun, Chen Chucai, Chen Dengwen. Basic design of Sandak copper and gold project in Balochistan, Pakistan [R]. Beijing: Beijing Nonferrous Metallurgy Design and Research Institute, 1991.
[2] Yuan Kang. Discussion and application of stable production technology in deep mining of Shandak open-pit copper-gold mine [J]. Metallurgical Economy and Management, 2011 (8): 25-30.
[3] Wang Xiangyun. SQL from entry to proficient [M]. Beijing: Publishing House of Electronics Industry, 2009.
Article source: "Modern Mining"; 2016.9;
Author: Yuan Kang, Dujian Chun, Chen Liqiang; MCC Resources Development Co., Ltd;
Copyright:
Cylinder Repair Kits for KOBELCO Booms and Midarms
Available for KOBELCO Travel Motor Repair Kits
Available for KOBELCO Rotary Motor Repair Kits
Suitable for KOBELCO Tensioner Cylinder Repair Kits
Available for KOBELCO Joystick Repair Kits
Available for KOBELCO Distribution Valve Repair Kits
Available for KOBELCO Pilot Pump Repair Kits
Suitable for KOBELCO Hydraulic Pump Repair Kits
For Kobelco Cylinder Seal Kit,Kobelco Rotary Motor Seal Kit,For Kobelco Boom Cylinder Seal Kit,Special Elevator Repair Kit
Safe Seal Technology Co., Ltd. , https://www.aprseal.com