基于数据仓库的医院信息系统的设计与实现

:519000沙翔DESIGNANDREALIZATIONOFHOSPITALINFORMATIONSYSTEMBASEDOFDATAWAREHOUSESHAXiang=随着信息技术的飞速发展,医院汇聚了大量的数据然而并非所有的数据都可带来有用信息,医院常常面临/数据爆炸但知识贫乏0的窘迫局面本文描述了一个基于数据仓库的医院信息系统的设计与实现,包括体系结构数据预处理和主题选择等这有助于医院实现数据共享,统一分析平台的数据环境,为提高医疗服务质量,更有效配置医疗资源,进行科学决策提供坚实的数据基础=信息系统数据仓库数据预处理主题选择=AbstractAlongwiththerapiddevelopmentofInformationTechnology,moredatacomesintobeinginthehospita.lButnotallthedatabringscorrespondinginformation,sotheembarrassingsituationthatdataexplosionbutstarvingforknowledgeoccursfrequently.Thispaperdescribesthedesignandrealizationaboutahospitalinformationsystembasedondatawarehouse,involvingthedesignofarchitectureandsubjects.Itwillhelptorealizethesharingofinformationtounifyplatformfordataanalysisenvironment,tocollocatemedicalresourcesmoreeffectivelyinordertoelevatemedicalservicequality,andtoprovideexcellentdatabasisforscientificdecisions.=KeywordsInformationsystem,Datawarehouse,Datapreprocessing,Subjectselection=AuthorcsaddressComputerCenter,InformationSection,ZhuhaiPeople.sHospita,lGuangdongProvince,519000PRCdo:i10.3969/.jissn.1671-332X.2009.06.0721,,,,,,,,,,,,2,,,;,,;,,,,,,,,,,,,;,,,,,,;,,,,,,2009696ModernHospitalJun2009Vol9No6,,3,:,,,,,13.1医院数据仓库体系结构2:,,,:(),,,:,:,(OLAP)(OLAM),,,,,,,,,,:,/,,,,,,,3.2数据预处理,,,,,,,,/0(),,,,,,1392009696ModernHospitalJun2009Vol9No6,,,,,,,,,,,,,,,,;,dd-mm-yy,yy-mm-dd,,,,,,,,,,,SQL,,3.3主题的选择,,,,,,,3.3.1,,,,,,,3.3.2,,,,3.3.3,,,,3.3.4,,,/0,3.3.5,,,3.3.6,,,(),,,3.3.7,,,4,,,,,,,,,[1]W.H.INMON.BuildingtheDataWarehouse[M].SecondEd-ition.NewYork:JohnWiley&SonsInc,1996.[2]RALPHKIMBALL,MARGYROSS.TheDataWarehouseToolkit:theCompleteGuidetoDimensionalModeling[M].SecondEd-ition.JohnWiley&SonsInc,2003.[3]PAULRAJPONNIAH.DataWarehousingFundamentalsACompre-hensiveGuideforITProfessionals[M].JohnWiley&SonsInc,2001.[4],.[M].,2002.[5].[J].,2002,22(1):29-30.[6],,.[J].,2002,22(2):37-38.1402009696ModernHospitalJun2009Vol9No6