摘要
快速高效采集、计算、分析、管理数据并准确提供煤质趋势分析的大数据技术,其在煤炭质量管理中的应用可提高生产效能及施行精益化管理。西铭矿选煤厂自主开发基于VBA Visual Basic for Applications的煤炭质量数据研究分析报告综合管理系统,系统运用大数据技术,将大量煤炭质量数据纳入数据库管理,以期为矿井和选煤厂指导煤炭生产提供数据支撑。简介煤炭质量数据研究分析报告综合管理系统的主要功能特点及系统内主要功能的实现,阐述大数据技术在数据采集、预处理、存储等方面的实现与应用,并结合大数据挖掘与数据分析对系统数据库的稳定性与安全性、系统的延伸性和扩展性进行剖析。企业在保证煤炭产品质量的前提下应兼顾生产最优,力争从煤炭的开采、洗选、储运、销售等方面给各级管理者提供高质量数据;调度指挥系统根据数据结果及时调整煤炭配采、运输储存、洗选配装工艺,提高精煤产品的质量稳定性和合格率并正确指导一线生产,从而使煤质管理从传统模式向现代化管理方式发展且开创基层煤质管理工作的新局面。
The big data technology which collects,calculates,analyzes and manages data quickly and efficiently and provides accurate coal quality trend analysis,the application in coal quality management can improve production efficiency and implement lean management.Ximing Coal Preparation Plant has independently developed a comprehensive management system for coal quality data research and analysis report based on VBA(Visual Basic for Applications).The system uses big data technology to manage a large amount of coal quality data in the database.It is expected to provide data support for coal production in mines and coal preparation plants.This paper introduced the main functions characteristics and implementation of main functions within the system of the comprehensive management system of coal quality data research and analysis report,elaborated on the implementation and application of big data technology in data collection,preprocessing,storage,and other aspects.Combining with big data mining and data analysis,the stability and security of the system database,as well as the extensibility and scalability of the system were analyzed.The enterprise shall give consideration to the optimal production while ensuring the quality of coal products,and strive to provide high-quality data to the managers at all levels from the aspects of coal mining,washing,storage,transportation and sales.According to the data results,the dispatching and command system shall adjust the process of coal mining,transportation,storage,washing and packing in time,and improve the quality stability and the qualified rate of the clean coal products and correctly guide the first-line production,therefore,the development of coal quality management from traditional models to modern management methods can be achieved,and a new situation in grassroots coal quality management can be created.
作者
韩建英
朱晶
赵丽娇
HAN Jianying;ZHU Jing;ZHAO Lijiao(Ximing Coal Preparation Plant of Shanxi Coking Coal Group Corporation Ltd.,Taiyuan 030053,China)
出处
《煤质技术》
2023年第3期71-77,共7页
Coal Quality Technology
关键词
大数据技术
煤质管理
综合管理系统
数据库
高质量数据
系统延伸性
big data technology
coal quality management
integrated management system
database
high quality data
system extensibility
