基于OLAP的矿业集团生产运营决策系统构建研究

摘要

In order to realize the distributed collection,processing,analysis and comprehensive analysis of production operation data under the control mode of mining group,OLAP is applied to design and develop the production operation and decision-making system for mining group.With the information technology,system framework is build which is consist of production and operation index system,parameter management,service components,data processing,data warehouse,OLAP and report tools.In the meantime,the function structure of system sub module is planned.The data storage structure of the system is organized by Database technology and the multidimensional data set oriented to the theme of production operation is built by OLAP,which is the prerequisite for the analysis and visualization of the multi-dimension data.In addition,the system has been constructed and applied in a Chinese mining group.And realize the distributed data extraction,data auditing,report generation and statistical analysis,which could effectively improve the level of production operation management and the ability of scientific decision-making.%为实现矿业集团管控模式下生产运营数据的分布式采集、处理、分析与决策,运用OLAP技术设计与实现了矿业集团生产运营决策系统.借助信息技术搭建了以生产运营指标体系、参数管理、服务组件、数据加工、数据仓库、OLAP服务和报表工具为核心部件的系统框架,并规划系统各子模块的功能体系.利用数据库技术优化系统数据存储结构,采用OLAP技术构建出面向生产运营主题的多维数据集,进而实现数据的多维操作与可视化展示.通过国内某大型矿业集团的建设与应用,实现了成员矿山生产运营数据的抽取、稽核、报表生成及统计分析,有效促进了矿业集团生产运营管理水平和科学决策能力的提升.