数据库一体机提升医院信息系统性能的探索与实践

Exploration and practice of improving the performance of hospital information systems with database integrated machine

目的医院信息系统的数据交互与信息量的快速增长,给系统的运维和服务性能带来了重大挑战。为了解决软件的性能瓶颈、提升医院信息系统的响应性能,某医院探索性引入了Exadata数据库一体机。方法通过硬件参数选型、高可用测试以及数据迁移等实现了数据库一体机的上线,通过对比上线前后数据库的I/O操作时间、SQL语句执行时间和业务系统模块加载时长评估效益。结果上线一体机后I/O操作的整体等待时长下降83.47%、相同语句的执行时间降幅超22%、业务系统加载时间平均下降43.74%。结论数据库一体机能够有效降低查询时间,加快业务模块的运行速度,能够帮助提升医院信息系统的性能。

Objective The rapid growth of data exchange and information volume in hospital information systems has brought significant challenges to the operation,maintenance,and service performance of the system.In order to overcome the performance bottleneck of the software and improve the response performance of the hospital information system,our hospital has tentatively introduced the Exadata database machine.Methods The machine was launched through hardware parameter selection,high availability testing,and data migration.The benefits were evaluated by comparing the I/O operation time,SQL statement execution time,and business system module loading time before and after the launch.Results After using this machine,the overall waiting time of I/O operations decreased by 83.47%,the execution time of the same statement decreased by over 22%,and the average loading time of the business system decreased by 43.74%.Conclusion The database machine can effectively reduce query time,accelerate the running speed of business modules,and help improve the performance of hospital information systems.