基于OLAP的高校数据分析与决策支持系统研究
|
摘要
基于Mahout的高校数据分析与决策支持系统,存在高校数据处理速率低、用户满意度差的弊端,设计基于OLAP的高校数据分析与决策支持系统,采用雪花模型根据不同主题设计数据仓库模块,缩短维表与反应表的连接用时,实现对高校数据仓库信息的高效查询处理;通过联机分析处理OLAP模块采用切片、切块、钻取和旋转操作实现面向高校数据的分析、归纳和总结;系统软件部分通过OLAP多维引擎,采用切片模块、立方体模块和表示模块将多维分析请求的分析结果以报表或图形的形式发送给用户,实现用户对高校数据分析与决策分析的需求。实验结果表明,所设计系统在更新关联内容用时、查看分析结果用时和文档导出用时均较短,且实际用户的满意度较高。
Since the university data analysis and decision-making support system based on the Mahout has the disadvantages of low data processing rate and poor user satisfaction,a university data analysis and decision-making support system based on the OLAP is designed. The snowflake model is used to design the data warehouse module according to different topics,and reduce the time consumption of connection between dimension tables and the reaction table,so as to realize high-efficient query and processing of university data warehouse information. Analysis,induction and summarization of university data are realized by using the online analysis and processing module OLAP and performing operations of slicing,block cutting,drilling and rotation.In the software part of the system,the slicing module,cubic module and representation module are used to send the analysis result of the multidimensional analysis request to users in the form of report and graph by means of the OLAP multidimensional engine,so as to meet users′ needs of data analysis and decision-making analysis in colleges and universities. The experimental results show that the designed system has short time-consumption in associated content updating,analysis result query and file export,and a high actual user satisfaction.
Since the university data analysis and decision-making support system based on the Mahout has the disadvantages of low data processing rate and poor user satisfaction,a university data analysis and decision-making support system based on the OLAP is designed. The snowflake model is used to design the data warehouse module according to different topics,and reduce the time consumption of connection between dimension tables and the reaction table,so as to realize high-efficient query and processing of university data warehouse information. Analysis,induction and summarization of university data are realized by using the online analysis and processing module OLAP and performing operations of slicing,block cutting,drilling and rotation.In the software part of the system,the slicing module,cubic module and representation module are used to send the analysis result of the multidimensional analysis request to users in the form of report and graph by means of the OLAP multidimensional engine,so as to meet users′ needs of data analysis and decision-making analysis in colleges and universities. The experimental results show that the designed system has short time-consumption in associated content updating,analysis result query and file export,and a high actual user satisfaction.
引文
[1]侯杰,胡乃联,李国清,等.基于OLAP的矿业集团生产运营决策系统构建研究[J].中国矿业,2016,25(11):11-15.HOU Jie,HU Nailian,LI Guoqing,et al. Construction of production operation&decision-making system for mining group based on OLAP[J]. China mining magazine,2016,25(11):11-15.
[2]满毅,章炯民,徐晓锦.一种基于朴素贝叶斯算法的OLAP缓存机制[J].计算机工程与应用,2017,53(6):85-90.MAN Yi,ZHANG Jiongmin,XU Xiaojin. OLAP cache mechanism based on naive Bayesian[J]. Computer engineering and applications,2017,53(6):85-90.
[3]王泽奥,吴斌,吴心宇,等.大规模多维网络数据分析框架的研究与实现[J].计算机科学与探索,2017,11(12):1941-1952.WANG Ze’ao,WU Bin,WU Xinyu,et al. Research and implementation of framework for large-scale multi-dimensional network analysis[J]. Journal of frontiers of computer science&technology,2017,11(12):1941-1952.
[4]徐扬,云梦妍,张瑾贤.大学生择业决策支持系统研究[J].当代教育与文化,2016,8(1):95-101.XU Yang,YUN Mengyan,ZHANG Jinxian. Research on decision support system of undergraduate career choice[J]. Contemporary education and culture,2016,8(1):95-101.
[5]封超,郭晓.基于CBR的应急情报智能决策支持系统研究[J].情报杂志,2017,36(10):36-40.FENG Chao,GUO Xiao. Research on Emergency intelligence intelligent decision support system based on case-based reasoning[J]. Journal of intelligence,2017,36(10):36-40.
[6]王宗水,赵红.大数据变革背景下的顾客网络满意度比较:基于OLAP可视化技术应用视角[J].软科学,2015,29(5):106-110.WANG Zongshui,ZHAO Hong. Comparison of customer online satisfaction comments in big data revolution:a view of OLAP visualization technology utility[J]. Soft science,2015,29(5):106-110.
[7]王会举,覃雄派,王珊,等.面向大规模机群的可扩展OLAP查询技术[J].计算机学报,2015,38(1):45-58.WANG Huiju,QIN Xiongpai,WANG Shan,et al. Scalable OLAP queries processing towards large cluster[J]. Chinese journal of computers,2015,38(1):45-58.
[8]崔红波,游进国,简兴明,等.Spark环境下的分布式OLAP查询[J].小型微型计算机系统,2017,38(11):2517-2522.CUI Hongbo,YOU Jinguo,JIAN Xingming,et al. Distributed OLAP query in Spark[J]. Journal of Chinese computer sys-tems,2017,38(11):2517-2522.
[9]武慧娟,秦雯,孙鸿飞.激励视角下高校智库协同决策机制研究:以吉林省高校智库建设为例[J].现代情报,2017,37(3):8-12.WU Huijuan,QIN Wen,SUN Hongfei. Research on collabora-tive decision mechanism of university think tank based the in-centive perspective:taking the construction of university thinktanks in Jilin Province as an example[J]. Modern information,2017,37(3):8-12.
[10]易魁,陈豪,赵志勇,等.小湾水电站工程安全分析与决策支持系统研究与构建[J].水力发电,2017,43(3):123-127.YI Kui,CHEN Hao,ZHAO Zhiyong,et al. Research and construction of engineering safety analysis and decision-making support system for Xiaowan hydropower station[J]. Water power,2017,43(3):123-127.
[2]满毅,章炯民,徐晓锦.一种基于朴素贝叶斯算法的OLAP缓存机制[J].计算机工程与应用,2017,53(6):85-90.MAN Yi,ZHANG Jiongmin,XU Xiaojin. OLAP cache mechanism based on naive Bayesian[J]. Computer engineering and applications,2017,53(6):85-90.
[3]王泽奥,吴斌,吴心宇,等.大规模多维网络数据分析框架的研究与实现[J].计算机科学与探索,2017,11(12):1941-1952.WANG Ze’ao,WU Bin,WU Xinyu,et al. Research and implementation of framework for large-scale multi-dimensional network analysis[J]. Journal of frontiers of computer science&technology,2017,11(12):1941-1952.
[4]徐扬,云梦妍,张瑾贤.大学生择业决策支持系统研究[J].当代教育与文化,2016,8(1):95-101.XU Yang,YUN Mengyan,ZHANG Jinxian. Research on decision support system of undergraduate career choice[J]. Contemporary education and culture,2016,8(1):95-101.
[5]封超,郭晓.基于CBR的应急情报智能决策支持系统研究[J].情报杂志,2017,36(10):36-40.FENG Chao,GUO Xiao. Research on Emergency intelligence intelligent decision support system based on case-based reasoning[J]. Journal of intelligence,2017,36(10):36-40.
[6]王宗水,赵红.大数据变革背景下的顾客网络满意度比较:基于OLAP可视化技术应用视角[J].软科学,2015,29(5):106-110.WANG Zongshui,ZHAO Hong. Comparison of customer online satisfaction comments in big data revolution:a view of OLAP visualization technology utility[J]. Soft science,2015,29(5):106-110.
[7]王会举,覃雄派,王珊,等.面向大规模机群的可扩展OLAP查询技术[J].计算机学报,2015,38(1):45-58.WANG Huiju,QIN Xiongpai,WANG Shan,et al. Scalable OLAP queries processing towards large cluster[J]. Chinese journal of computers,2015,38(1):45-58.
[8]崔红波,游进国,简兴明,等.Spark环境下的分布式OLAP查询[J].小型微型计算机系统,2017,38(11):2517-2522.CUI Hongbo,YOU Jinguo,JIAN Xingming,et al. Distributed OLAP query in Spark[J]. Journal of Chinese computer sys-tems,2017,38(11):2517-2522.
[9]武慧娟,秦雯,孙鸿飞.激励视角下高校智库协同决策机制研究:以吉林省高校智库建设为例[J].现代情报,2017,37(3):8-12.WU Huijuan,QIN Wen,SUN Hongfei. Research on collabora-tive decision mechanism of university think tank based the in-centive perspective:taking the construction of university thinktanks in Jilin Province as an example[J]. Modern information,2017,37(3):8-12.
[10]易魁,陈豪,赵志勇,等.小湾水电站工程安全分析与决策支持系统研究与构建[J].水力发电,2017,43(3):123-127.YI Kui,CHEN Hao,ZHAO Zhiyong,et al. Research and construction of engineering safety analysis and decision-making support system for Xiaowan hydropower station[J]. Water power,2017,43(3):123-127.