数据仓库化的设备管理决策支持系统的研究

Study on Data Warehouse-based Decision Support System of Equipment Management

分析了传统决策支持系统难于实现的原因 ,针对系统升级和业务功能扩展的需求 ,建立了基于数据仓库与数据挖掘的设备管理决策支持系统 ,建立了数据仓库化的决策模型 ,设计了系统的功能模块图和数据仓库架构图 ,分析了设备管理决策支持系统中数据挖掘的作用和特点 ,探讨了利用数据库复制技术实现数据仓库化的决策支持系统的方法 ,并给出了一种实现小型数据库复制成大型数据库的流程图。

The causes for the hard realization of traditional decision support system are analyzed. In view of the requirement of system upgrading and function expansion, a decision support system of equipment management which is based on data warehouse and data mining is proposed, the decision model of data warehouse established, and the system function modules and data warehouse architecture are designed. The functions and features of the data mining in the support system are analysed, the method for realizing the data warehouse using database duplication technology is explored and an example of database duplication flowchart from small databases into a large one presented.