数据仓库在军字一号工程药品信息管理分析中应用研究

The applying research of data warehouse technology in the medicine information management analysis of "No.1 Project,Military

目的探讨如何应用数据仓库技术构建军字一号工程药品信息统计资源库。方法运用Oracle9.2和OWB9.0数据仓库生成软件,构建药品信息统计资源库,并利用Oracle9iDiscoverer工具进行数据挖掘。结果从药品信息统计资源库中挖掘出大量的管理信息,并生成了相应的报表和视图。结论应用数据仓库技术构建医院药品信息统计资源库,可从中得到丰富的辅助决策信息,拓展了HIS信息资源利用空间。

Objective To investigate how to apply data warehouse technology to construct medicine information statistic resource database of'No.1Project of Military'.Methods Applying Oracle9.2.0.1.0and OWB9.0.4.8.21software to construct medicine information statistic resource database,following to this statistic resource database by Oracle9i Discoverer software.Results It had mined much information including all kinds of tables and graphs from the statistic resource database.Conclusion Applying data warehouse technology to construct statistic resource database of hospital medicine information,much information to help decision -making,could be goven,and making using spaces of HIS information resource to be expende.