Ximing Coal Preparation Plant of Shanxi Coking Coal Group Corporation Ltd.

快速高效采集、计算、分析、管理数据并准确提供煤质趋势分析的大数据技术,其在煤炭质量管理中的应用可提高生产效能及施行精益化管理。西铭矿选煤厂自主开发基于VBAVisualBasicforApplications的煤炭质量数据研究分析报告综合管理系统,系统运用大数据技术,将大量煤炭质量数据纳入数据库管理,以期为矿井和选煤厂指导煤炭生产提供数据支撑。简介煤炭质量数据研究分析报告综合管理系统的主要功能特点及系统内主要功能的实现,阐述大数据技术在数据采集、预处理、存储等方面的实现与应用,并结合大数据挖掘与数据分析对系统数据库的稳定性与安全性、系统的延伸性和扩展性进行剖析。企业在保证煤炭产品质量的前提下应兼顾生产最优,力争从煤炭的开采、洗选、储运、销售等方面给各级管理者提供高质量数据;调度指挥系统根据数据结果及时调整煤炭配采、运输储存、洗选配装工艺,提高精煤产品的质量稳定性和合格率并正确指导一线生产,从而使煤质管理从传统模式向现代化管理方式发展且开创基层煤质管理工作的新局面。

The big data technology which collects, calculates, analyzes and manages data quickly and efficientlyand provides accurate coal quality trend analysis, the application in coal quality management can improve productionefficiency and implement lean management. Ximing Coal Preparation Plant has independently developed a compre⁃hensive management system for coal quality data research and analysis report based on VBA (Visual Basic for Appli⁃cations). The system uses big data technology to manage a large amount of coal quality data in the database. It is ex⁃pected to provide data support for coal production in mines and coal preparation plants. This paper introduced themain functions characteristics and implementation of main functions within the system of the comprehensive manage⁃ment system of coal quality data research and analysis report, elaborated on the implementation and application of bigdata technology in data collection, preprocessing, storage, and other aspects. Combining with big data mining anddata analysis, the stability and security of the system database, as well as the extensibility and scalability of the sys⁃tem were analyzed. The enterprise shall give consideration to the optimal production while ensuring the quality of coalproducts, and strive to provide high⁃quality data to the managers at all levels from the aspects of coal mining, wash⁃ing, storage, transportation and sales. According to the data results, the dispatching and command system shall ad⁃just the process of coal mining, transportation, storage, washing and packing in time, and improve the quality sta⁃bility and the qualified rate of the clean coal products and correctly guide the first⁃line production, therefore, the de⁃velopment of coal quality management from traditional models to modern management methods can be achieved, and anew situation in grassroots coal quality management can be created.

韩建英, 朱晶, 赵丽娇. 大数据技术在煤质管理中的应用研究 [J]. 煤质技术, 2023, 38 (3): 71-77.

HAN Jianying, ZHU Jing, ZHAO Lijiao. Application of big data technology in coal quality management [J]. CoalQuality Technology, 2023, 38 (3): 71-77.