基于数据仓库的学科建设决策支持系统的设计

Design of academic disciplinal construction DSS based on data warehouse

为了从高校已有的学科建设系统中提取出潜在的知识,为高校领导的决策提供辅助信息,提出了基于数据仓库的高校学科建设决策支持系统的总体框架。在DSS系统实现的过程中,将采用OLAP+DM+Web的结合方式,并重点介绍利用SQL Server 2005的分析管理器设计多维数据模型,创建数据仓库,以可视化交互的方式为高校领导提供全方位的决策支持,最后通过实例展示的决策支持系统的设计与分析过程。

In order to extract potential knowledge from the existed MIS system of disciplinal construction,which will provide supplementary information for the university leadership,the framework of academic discipline construction DSS based on the technology of data warehouse is proposed.During the process of the DSS system implementation,using the approach of combination of OLAP,DM, web and the multidimensional data model is designed by mainly introducing the use of SQL server 2005 SSAS,a data warehouse is created,which will provide university leadership with advisable decision support in a visually interactive manner.Finally,the design and analysis process is demonstrated by the application.