基于SQL Server云数据库的洪水河铁矿三维地质建模  

Three-dimensional Geological Modeling of Hongshuihe Iron Mine Based on SQL Server Cloud Database

作　　者：陈丽娟[1,2] 刘锦秀 王春涛[1] 

机构地区：[1]青海省地质调查院,青海西宁810012 [2]青海省青藏高原北部地质过程与矿产资源重点实验室,青海西宁810012

出　　处：《金属矿山》2017年第9期160-165,共6页Metal Mine

摘　　要：为提高复杂矿体三维建模精度与矿山基础地质数据的存储效率,以青海省洪水河铁矿为例,提出了利用SQL Server云数据库实现矢量与栅格数据一体化云存储的矿山三维地质建模方法。首先利用矿区55个勘探钻孔数据、5条勘探平硐数据以及物探数据,采用SQL Server云数据库设计了新的云存储空间架构和交互方式,利用HDFS文件系统与ACID分布式图形数据库实现了数据云同步功能,用户权限保证了数据安全性;然后设计了三维地质数据录入平台,界面友好,简化了地质数据录入和建模难度;最后对于零厚体和透镜体,设计出遍历法和裁切功能对已构建的矿山三维地质模型进行修正。研究表明,所构建的矿体三维地质模型较精确模拟了洪水河铁矿矿区地质体三维分布规律,建模效率和地质数据安全性有所提高。In order to improve the three-dimensional geological modeling precision and mine basic geological data storage efficiency,taking the Hongshuihe Iron Mine in Qinghai Province as the study example,the mine three-dimensional geological modeling method is proposed by using SQL Server cloud database to realize the goal of the integrated cloud storage of vector data and raster data. Firstly,based on the data of 55 exploration drillings and 5 exploration adits and geophysical prospecting data of the mining area,the new cloud storage spatial architecture and interactive mode are designed by SQL Server cloud database,the data cloud synchronization function is realized by HDFS file system and ACID distributed graph database; then,the three-dimensional geological data input platform is designed,the entry interface is friendly,so the difficulties of geological data input and three-dimensional geological modeling are reduced; finally,in order to deal with the zero thick body and lenticle with high efficiency,the established three-dimensional geological model is modified by adopting the traversing method and cutting function that are designed in this paper. The study results show that the three-dimensional distribution regularity of the geological bodies in Hongshuihe mining area are simulated effectively by the three-dimensional geological model established in this paper,the modeling efficiency and geological data security are both improved.

关 键 词：铁矿 三维地质建模 SQL Server云数据库 云存储 

分 类 号：P628[天文地球—地质矿产勘探] TD672[天文地球—地质学]