煤矿采空区岩土工程勘察数据库设计与应用  

Design of Geotechnical Engineering Survey Database in Coal Mine Goaf

作　　者：韦罗沁浩 赵伏军 刘朝跃[2] 林剑 WeiLuo Qinhao;Zhao Fujun;Liu Chaoyue;Lin Jian(School of Resources,Environment and Safety Engineering,Hunan University of Science and Technology,Xiangtan 411201,China;Guizhou Provincial Transportation Planning,Survey,Design and Research Institute Co.,Ltd.,Guiyang 500110,China;School of Computer Science and Engineering,Hunan University of Science and Technology,Xiangtan 411201,China)

机构地区：[1]湖南科技大学资源环境与安全工程学院,湖南湘潭411201 [2]贵州省交通规划勘察设计研究院股份有限公司,贵州贵阳500110 [3]湖南科技大学计算机科学与工程学院,湖南湘潭411201

出　　处：《矿业工程研究》2020年第3期65-72,共8页Mineral Engineering Research

基　　金：国家自然科学基金资助项目(51474103)。

摘　　要：采空区岩土勘察信息数字化是矿山勘察工作智能化的重要环节之一,设计一个满足日常勘察工作各环节需求及利于工程勘察评价的数据库对于其信息管理具有重要意义.依据煤矿采空区岩土工程勘察相关的国家规范,分析了数据库设计需求,将煤矿采空区岩土工程勘察涉及的实体划分为勘察目标实体、勘察方法实体和属性实体,建立了勘察目标实体之间的实体-关系(E-R)模型.对勘察方法实体和属性实体进行分类,"勘察"关联实体构建了数据库概念模型.在此基础上,实现了数据库逻辑设计和物理设计,并以此数据库服务于系统功能.Digitization of geotechnical survey information in the coal mine goaf is one of the important links in the intelligentization of mine survey work,designing a database that meets the needs of daily survey work and favorable for engineering investigation and evaluation is of great significance for its information management.According to the relevant national standards of the geotechnical engineering investigation in the goaf of coal mine,the database design requirements are analyzed.The entities involved in the geotechnical engineering investigation in the goaf of coal mine are divided into the investigation target entity,the investigation method entity and the attribute entity.The entity relationship(E-R)model between the investigation target entities is established.The survey method entities and attribute entities are classified,and the database concept model is constructed for the"survey"associated entities.On this basis,the database logical design and physical design are completed,and the database serves the system functions.

关 键 词：煤矿采空区 岩土工程勘察 实体-关系模型 数据库设计 

分 类 号：TD167[矿业工程—矿山地质测量]