文献类型：期刊文献

中文题名：煤田地质勘探地理信息系统空间数据库管理系统设计

英文题名：Designing of Geographic Information System Spatial Database Management System for Coalfield Geological Exploration

作者：孙岩[1];李斌[2];罗群[3]

第一作者：孙岩

机构：[1]北京联合大学特殊教育学院,北京100075;[2]韩山师范学院,潮州521041;[3]中国石油大学(北京)非常规科学技术研究院,北京100049

第一机构：北京联合大学特殊教育学院

年份：2021

卷号：21

期号：1

起止页码：95-102

中文期刊名：科学技术与工程

外文期刊名：Science Technology and Engineering

收录：CSTPCD;;北大核心:【北大核心2020】；

基金：北京联合大学基础研究基金(122139918290107084);北京联合大学科技创新服务能力建设-财政专项基本科研项目(122139919290104059);北京联合大学教育教学研究与改革项目(JJ2019Y034)。

语种：中文

中文关键词：空间数据库;煤田勘探;关系型数据库;协同式传输;地理信息系统

外文关键词：spatial database;coalfield exploration;relational database;cooperative transmission;geographic information system(GIS)

摘要：在煤田地质勘探实践中,积累了大量地质数据,以常规文件方式存储管理难以满足煤田勘探、开发、科研的需求。按照空间关系型数据库管理思路设计煤田地质勘探地理信息系统(geographic information system,GIS)空间数据库管理系统,以空间数据库和属性数据库服务器方式存储、管理煤田勘探地质数据,以数据库角色用户方式进行远程传输、更新、维护属性数据表,以共享文件夹传输、文件传输协议(file transfer protocol,FTP)文件传输、网页客户端平台方式维护数据文件,通过浏览器/服务器(browser/server,B/S)方式实现异地客户端地质数据空间复杂查询、下载等,实现信息共享,高级用户可通过数据库客户端直接访问数据表。煤田地质勘探空间数据库管理系统的实现,从根本上实现了复杂地质数据的科学化管理,提高了数据存储、访问、维护的便捷性、高效性、准确性和安全性,为煤田勘探地质数据的标准化存储、查询、维护、应用提出了新的方案,可以在煤田地质勘探中深入推广应用。
Massive geological data have been accumulated in the practice of coalfield geological exploration.File storage management is hardly to meet the needs of coal exploration,development and scientific research.The geographic information system(GIS)spatial database management system of coalfield geological exploration was designed according to the idea of relational spatial database.The data were stored in the way of network space database server and attribute database server,in which the geological attribute database was transmitted,updated and maintained in a remote cooperative manner through the user role of the database,and the data files were maintained by shared folders transmission,FTP file transmission and web client platform.Geological attribute data could be shared through remote network client querying and downloading in the B-S way.Advanced users had direct access to the database from the database client.The implementation of the spatial database management system for coalfield geological exploration has fundamentally realized the scientific management of complex geological data,which has improved the convenience,efficiency,accuracy and safety of data storage,access and maintenance,and put forward a new concept for standardized storage,query,maintenance and application of coal exploration geological data.The case can be further applied in coalfield geological exploration.