Data analysis system for coal special fund based on OLAP technology
-
摘要: 针对煤炭企业专项资金数据整合分析功能不足的问题,设计了基于OLAP技术的煤炭专项资金数据分析系统。该系统采用HOLAP混合结构物理存储数据,以雪花模型组织事实表和维度表数据,将数据进行ETL处理后加载到多维数据集;最后采用OLAP多维分析技术实现数据分析功能和良好的用户交互,可满足专项资金数据分析需求,为企业决策提供了必要支持。Abstract: In view of problem of inadequate function of data integration and analysis of special fund of coal enterprise, a data analysis system for coal special fund based on OLAP technology was designed. The system uses HOLAP hybrid structure to realize physical storage of data, uses snowflake schema to organize data of fact table and dimension table, and loads the data into multidimensional data set after ETL processing for the data. Eventually, the system uses OLAP multidimensional analysis technology to realize data analysis function and good user interaction, so as to meet needs of dada analysis of special fund and provide necessary support for enterprise decision.
-
Key words:
- special fund /
- data analysis /
- OLAP /
- multidimensional data set
点击查看大图
计量
- 文章访问数: 28
- HTML全文浏览量: 4
- PDF下载量: 2
- 被引次数: 0