Data analysis system for coal special fund based on OLAP technology
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 orga...
Main Authors: | , , , |
---|---|
Format: | Article |
Language: | zho |
Published: |
Editorial Department of Industry and Mine Automation
2014-08-01
|
Series: | Gong-kuang zidonghua |
Subjects: | |
Online Access: | http://www.gkzdh.cn/article/doi/10.13272/j.issn.1671-251x.2014.08.026 |
_version_ | 1797868702712987648 |
---|---|
author | WANG Sheguo ZHANG Feng TIAN Zhimin WU Shasha |
author_facet | WANG Sheguo ZHANG Feng TIAN Zhimin WU Shasha |
author_sort | WANG Sheguo |
collection | DOAJ |
description | 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. |
first_indexed | 2024-04-10T00:00:02Z |
format | Article |
id | doaj.art-64d5d5aaeeab427fb2714172db044532 |
institution | Directory Open Access Journal |
issn | 1671-251X |
language | zho |
last_indexed | 2024-04-10T00:00:02Z |
publishDate | 2014-08-01 |
publisher | Editorial Department of Industry and Mine Automation |
record_format | Article |
series | Gong-kuang zidonghua |
spelling | doaj.art-64d5d5aaeeab427fb2714172db0445322023-03-17T01:51:22ZzhoEditorial Department of Industry and Mine AutomationGong-kuang zidonghua1671-251X2014-08-01408979910.13272/j.issn.1671-251x.2014.08.026Data analysis system for coal special fund based on OLAP technologyWANG SheguoZHANG FengTIAN ZhiminWU ShashaIn 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.http://www.gkzdh.cn/article/doi/10.13272/j.issn.1671-251x.2014.08.026special funddata analysisolapmultidimensional data set |
spellingShingle | WANG Sheguo ZHANG Feng TIAN Zhimin WU Shasha Data analysis system for coal special fund based on OLAP technology Gong-kuang zidonghua special fund data analysis olap multidimensional data set |
title | Data analysis system for coal special fund based on OLAP technology |
title_full | Data analysis system for coal special fund based on OLAP technology |
title_fullStr | Data analysis system for coal special fund based on OLAP technology |
title_full_unstemmed | Data analysis system for coal special fund based on OLAP technology |
title_short | Data analysis system for coal special fund based on OLAP technology |
title_sort | data analysis system for coal special fund based on olap technology |
topic | special fund data analysis olap multidimensional data set |
url | http://www.gkzdh.cn/article/doi/10.13272/j.issn.1671-251x.2014.08.026 |
work_keys_str_mv | AT wangsheguo dataanalysissystemforcoalspecialfundbasedonolaptechnology AT zhangfeng dataanalysissystemforcoalspecialfundbasedonolaptechnology AT tianzhimin dataanalysissystemforcoalspecialfundbasedonolaptechnology AT wushasha dataanalysissystemforcoalspecialfundbasedonolaptechnology |