高校师资数据联机分析处理系统设计与实现  

Design and implementation of on-line analytical processing system for teachers’data in colleges and universities

作　　者：刘鹏 李丹 孙思邈 黄新 闫朝升 LIU Peng;LI Dan;SUN Simiao;HUANG Xin;YAN Zhaosheng(Personnel Department,Heilongjiang University of Chinese Medicine,Harbin 150040,China;Modern Education Technology and Information Center,Heilongjiang University of Chinese Medicine,Harbin 150040,China;School of Medical Information Engineering,Heilongjiang University of Chinese Medicine,Harbin 150040,China)

机构地区：[1]黑龙江中医药大学人事处,黑龙江哈尔滨150040 [2]黑龙江中医药大学现代教育技术与信息中心,黑龙江哈尔滨150040 [3]黑龙江中医药大学医学信息工程学院,黑龙江哈尔滨150040

出　　处：《电子设计工程》2022年第7期175-179,184,共6页Electronic Design Engineering

基　　金：黑龙江省自然科学基金项目(F200908);黑龙江省高等教育教学改革研究重点委托项目(SJGZ20200162);黑龙江省高等教育教学改革研究项目(SJGY20200673,SJGY20190618);黑龙江省中医药科研项目(ZHY2020-089)。

摘　　要：如何快速、便捷地发现有价值、多维度、隐藏的师资信息,支持高校师资管理决策,是高校师资管理改革的关键问题。联机分析处理提供了快速、一致、交互的多维度、多层次数据处理技术。文中提出了基于C/S模式的高校师资数据联机分析处理系统的体系结构和功能模块,设计了面向高校师资管理决策支持的独立数据集市;在此基础上,利用可视化程序设计语言和Microsoft SQL Server,实现了高校师资数据联机分析处理系统。实验结果表明,该系统能够实现多维多层数据分析,为高校师资管理决策支持提供有价值、多维度、多层次的信息。For the management reform of teachers in colleges and universities,it has been a key problem how to quickly and easily find hidden,valuable and multi-dimensional information from a lot of historical teachers’data to support the management decision-making of teachers.The on-line analytical processing could provide a rapid,consistent and interactive data processing technique for multi-dimensional and multi-level data analysis.This paper presents an architecture and functional modules of on-line analytical processing system for teachers’data in colleges and universities which is based on C/S,and designs the independent data mart for management decision-making support of teachers.On this basis,the visual programming language and Microsoft SQL Server are used to implement an on-line analytical processing system for teachers’data in colleges and universities.Finally,experimental results showed that this system could carry out practical platform of multidimensional and multi-level data analysis,provide the valuable,multi-dimensional and multi-level information for decision-making support.

关 键 词：师资管理 联机分析处理 数据集市 决策支持 

分 类 号：TN919[电子电信—通信与信息系统]