基于SQL SERVER 2008在医院信息系统中构建数据仓库

Build Up Data Warehouse in HIS Based on SQL SERVER 2008

利用Microsoft SQL Server 2008作为构建数据仓库的技术平台,建立基于2005至2008年住院病人费用情况的数据仓库实例,详细说明了数据仓库建模及数据加载过程中事实表、维度表的设计和实现过程。总结了建仓过程中遇到的问题及其解决途径和方法。为进行进一步的数据挖掘和报表展现打好基础。

Utilizing Microsoft SQL Server 2008 as a technology platform of data warehouse to build up data warehouse examples based on patients expenses in 2005-2008, the modeling of data warehouse and the design and implementation of fact table and dimension table in data loading are described in detail. This article summarizes the problems in the process of warehouse building and solutions, contributing to a better foundation of data mining and reports.