使用微软商务智能平台构建医疗数据仓库

摘要

数据仓库的构建是一个复杂的过程。 Microsoft SQL Server 2008作为微软商业智能的核心，提供了一个比较全面的数据管理服务平台。在此基础上，微软商务智能（ BI ）工具为创建数据仓库、数据分析和生成报表提出了一套可伸缩的解决方案。介绍利用这套商务智能平台构建医疗数据仓库的过程。在设计医疗数据仓库的过程中，根据医疗数据结构，结合数据仓库双重粒度和索引的设计等相关技术，以及利用微软商务智能平台数据表划分和ROW和PAGE压缩等技术实现了上海某医疗集团数据仓库的整体设计。最后给出该设计方案的实验结果，验证了所设计的系统的实用性。%It is a complicated process to construct a data warehouse .As the core of the Microsoft Business Intelligence ( BI) ,Microsoft SQL Server 2008 provides a more comprehensive data management service platform .On that basis,the Microsoft BI provides a retractable scheme for building data warehouse ,data analysis and generating reports .In this paper we introduce the building process of medical data warehouse with this BI platform.In the process of medical data warehouse designing ,according to the medical data structure ,combining with the related technologies of dual-granularity and index designing in data warehouse ,and using the technologies of table partition and ROW&PAGE com-pression in Microsoft BI platform ,we realise the overall design of the data warehouse for a medical group in Shanghai .Finally we present the experimental results of the design scheme ,and verify the practicability of the designed system .