面向矿床三维动态建模的地质勘探数据库增量更新方法

针对深部找矿过程中地质勘探数据增加和动态三维地质建模需要,提出了一种基于版本管理的矿床地质勘探数据库增量更新方法。在分析矿床地质勘探工程数据与三维地质模型映射关系的基础上,建立时序版本和建模版本作为矿床勘探数据增量更新版本标识。针对矿床地质勘探数据库增量更新的版本管理,提出了一种扩展的有向无环图版本管理模型,设计了基于关系数据库的版本管理方法并探讨了其实现过程。以安徽铜陵凤凰山矿床地质勘探数据为例,基于SQL Server数据库系统建立了实例矿床地质勘探版本数据库,以C#编程实现了实例矿床勘探数据库的版本管理,包括版本的建立、查询与显示等功能,通过勘探工程增量更新版本数据建立了三维矿体的动态修正模型,证实了方法的可行性与有效性。

An incremental update method of geological prospecting database for 3D dynamic modelling in mineral deposits

Due to the increasing geological exploration data and 3D dynamic geological modelling in the deep mineral exploration, we proposed an incremental update method of geological prospecting database based on version management. Firstly, based on the analysis of the mapping relationship between geological exploration engineering data and 3D geological model, we established sequential version and modelling version as the incremental updating version identifiers of deposit exploration data. Then, aiming at version management of the updated exploration data, we put forward a version management model based on extended directed acyclic graph, designed a version management method based on relational database, and discussed its implementation process as well. Finally, taking the Fenghuangshan ore field in Tongling of Anhui as a case study, we built a practical geological exploration version database based on the SQL Server system. The C# program was developed to implement the functions of version management for practical mineral exploration database, including version establishment, query and display functions. A set of 3D ore-body dynamic correction models was built by using the incremental updating version instance. This method is confirmed to be feasible and efficient.