CAJ | 학술논문

数据仓库的构建是一个复杂的过程。 Microsoft SQL Server 2008作为微软商业智能的核心，提供了一个比较全面的数据管理服务平台。在此基础上，微软商务智能（ BI ）工具为创建数据仓库、数据分析和生成报表提出了一套可伸缩的解决方案。介绍利用这套商务智能平台构建医疗数据仓库的过程。在设计医疗数据仓库的过程中，根据医疗数据结构，结合数据仓库双重粒度和索引的设计等相关技术，以及利用微软商务智能平台数据表划分和ROW和PAGE压缩等技术实现了上海某医疗集团数据仓库的整体设计。最后给出该设计方案的实验结果，验证了所设计的系统的实用性。
수거창고적구건시일개복잡적과정。 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 .