HIS数据库升级——SQL2005到SQL2014的跨版本升级  

HIS Database Upgrade——Cross-version Upgrade from SQL2005 to SQL2014

作　　者：丁晔[1] DING Ye(Jiangsu Cancer Hospital, Jiangsu Institute of Cancer Prevention and Control, Cancer Hospital Affiliated to Nan jing Medical University, Nanjing 210009, Jiangsu Province, P.R.C.)

机构地区：[1]江苏省肿瘤医院,江苏省肿瘤防治研究所,南京医科大学附属肿瘤医院

出　　处：《中国数字医学》2018年第5期55-56,54,共3页China Digital Medicine

摘　　要：目的:完成HIS的软硬件升级,解决SQL数据库下HIS负荷过重的问题。方法:数据库升级后,由3台服务器组成集群环境,利用SQL2014的AlwaysOn完成HIS数据库的读写分离,将HIS中的各类查询及报表做负载均衡。结果:极大地提升了HIS的性能和安全。结论:利用SQL2014自带的AlwaysOn,无须借助第三方软件,对于提升HIS性能是十分安全、可靠的。Objective： To solve the problem of overload of HIS under SQL database, we had upgraded the hardware and software of HIS. Methods： Using the HA cluster formed by three servers after the database of HIS upgraded, we have compeleted the Read/Write Splitting of HIS database and created the load balacing on kinds of query and report of HIS. Results： The safety and performance of HIS have enhanced greatly. Conclusion： It is very safe and reliable for improving the performance of HIS using Always On of SQL2014 without the third party software.

关 键 词：数据库 SQL2014 读写分离 主副本服务器 辅助副本服务器 

分 类 号：R319[医药卫生—基础医学] TP391[自动化与计算机技术—计算机应用技术]