基于MySQL的煤质信息数据库设计
Design of coal quality information database based on MySQL
柯妍 1孙佳留 2朱士飞 1秦云虎 1吴国强 3王双美 1张静1
作者信息
- 1. 江苏地质矿产设计研究院(中国煤炭地质总局检测中心),江苏 徐州 221006;中国煤炭地质总局煤系矿产资源重点实验室,江苏 徐州 221006
- 2. 中国矿业大学 资源与地球科学学院,江苏 徐州 221008
- 3. 中国煤炭地质总局煤系矿产资源重点实验室,江苏 徐州 221006
- 折叠
摘要
在长期的煤炭勘探和煤矿建设、生产过程中,积累了大量的煤质数据,但这些数据没有得到统一有效的管理,存在多源异构数据标准不统一、信息孤立未融合、数据的深度价值未发掘等问题.本文选用了MySQL作为开发煤质信息管理系统的数据库系统,对各省份汇总的煤质数据信息按照统一的格式进行整理和筛选,根据煤质信息管理系统的需求设计了煤质数据汇总表、煤质数据地理位置表和用户信息表,将整理筛选后的煤质信息数据入库,建立了煤质信息管理系统的基础数据库.
Abstract
In the long-term coal exploration,coal mine construction and production process,a large amount of coal quality data has been accumulated,which has not been unified and effective management.Multi-source heterogeneous data standards are not unified,information is isolated and not integrated,and the depth value of data has not been explored.In this paper,MySQL was selected as the database system for the coal quality information management system.The coal quality data collected by each province was sorted and screened in a unified format to obtain the provincial summary data,and the coal quality data summary table,coal quality data geographical location table and user information table were designed according to the requirements of the coal quality information management system.The basic database of the coal quality information management system was established and imported the sorted and screened coal quality information data.
关键词
煤质信息/MySQL/数据表/数据库Key words
coal quality information/MySQL/data sheet/database引用本文复制引用
基金项目
江苏地质矿产设计研究院科技创新项目(JSY2020-8)
中国煤炭地质总局科技专项(ZMKJ-2020-J02-3)
出版年
2024
NETL
NSTL
万方数据