利用数据库中间表实现医院信息系统中复杂查询  

Complex query in hospital information system based on database intermediate table

作　　者：李函 LI Han(Information Department,the 92nd Hospital of the PLA,Nanping 353000,Fujian Province,China)

机构地区：[1]解放军92医院信息科,福建南平353000

出　　处：《医疗卫生装备》2018年第1期37-40,共4页Chinese Medical Equipment Journal

摘　　要：目的:提高医院信息系统中复杂查询的时效性,降低对数据库资源的过多占用。方法:打破单一的多表联合查询数据限制,通过建立用户最终要查询的数据集合的中间表,定期将查询到的结果存到中间表中,让用户只需要访问经过处理后的中间表即可。结果:通过客户端查询软件查询相应统计数据,发现利用中间表优化后的查询速度大幅提高,实现了大数据下精确、高效的查询。结论:中间表的应用能有效解决目前医院信息系统中复杂查询碰到的瓶颈问题,为医院的数据支持中心提供精细化管理,更好地满足职能科室的统计需求,值得大力推广。Objective To improve the timeliness of complex query in hospital information system and to reduce excessive use of database resources.Methods Instead of using multi table joint query,an intermediate table was established to store the acquired results periodically,and the user realized complex query by accessing the intermediate table.Results Client inquiry software was used to execute query on statistical data,and it's found the inquiry speed was enhanced greatly after optimization by the intermediate table so that high-precision and-efficiency inquiry could be implemented in big data.Conclusion The intermediate table contributes to executing complex query in hospital information system,and thus is worthy promoting for the precision management in hospital data center.[

关 键 词：中间表 医院信息 复杂查询 大数据 统计需求 

分 类 号：R318[医药卫生—生物医学工程] TP311.13[医药卫生—基础医学]