面向药品决策支持系统的数据仓库模型设计

医院药品的业务庞杂，数据集成与分析不完善，缺少信息全面、集成的数据仓库系统。研究医院药品数据，运用“业务维度生命周期法”进行数据仓库项目的设计、开发和部署。解决的问题有：创建数据仓库总线结构，建立主题模型，使用维度建模来进行逻辑建模．数据存储的物理设计．数据转储与开发。总体逻辑结构模型设计清晰，构建方法新颖，给出一个较好的医院药品数据仓库的分析模型。

The Data Warehouse's Model Design for the Decision Support System of Hospital Drugs

Hospital drug business is complex. The data integration and the analysis are imperfect. Data warehouse system, in which the information is comprehensive and integrated is lacking. Studied the hospital drugs data, the design, the development and the deployment of the data warehouse projecting using business dimension lifecycte method,, are carried on. The question solved in the paperincludes： founding the data war ehouse bus structure, establishing subject models, carrying on the Iogicat modelling, the physical design of data storage, data dump and develop- ment by using dimension modelling. The overall logical organization pattern layout was clear and the construction method was novel. These give a good anatomic model of hospital drugs data warehouse.