基于SQL Server的铅锌钨钼多金属矿地质业务系统开发及应用

Development and Application of Geological Business Computing System for a Lead Zinc Molybdenum Polymetallic Ore Based on SQL Server

针对许多金属矿山生产中段下延,矿山地质技术管理工作任务日益艰巨和复杂的现状,研究开发了基于SQL Server数据库的地质业务计算机系统。该地质业务管理系统主要应用于矿山钻探工程数据处理及报表、地质储量平衡数据处理及查询等工作。文章介绍了该系统的基本框架,以及数据处理、地质储量平衡、各类报表和查询等相关功能设计。某铅锌钨钼多金属矿山目前已有10余个中段,大小矿块合计340个同时作业,年度储量数据已接近5万条记录,地质数据管理极为复杂。系统在该矿运行稳定,能适时有效地对井下钻探工程、各生产中段矿块数据进行监督和管理,有效地提高了矿山地质工作的效率和质量。该系统的开发及应用成果可供其他金属矿山地质业务管理参考。

This paper develops the geological business computing system by using SQL Server database to address the increasingly complicated geological technical management in the metallic mines due to extending mining depth. The system can be applied in data processing, reporting and retrieving for drilling engineering and geological reserves balance. This paper introduces the basic framework and related functions including data processing, geological reserves balance, reporting and queries. The system was applied to the geological management business in Huangshaping Lead Zinc molybdenum polymetallic ore, which has 340 drilling working points at the same time. The geological data management is extreme complicated for the annum reserves data amounting to fifty thousand records. The stable performance of the system realizes the timely and effective supervision and management on the mining data by improving the efficiency and quality of the mine geological work. Development and application results of the system provide favorable reference to the geological business management of other metal mines.