基于SQL数据库的医院财务管理信息平台

Hospital Financial Management Information Platform Based on SQL Database

为提升医院财务信息的管理能力,利用信息化技术建立医院财务信息一体化平台,采用统一的数据库对财务信息数据进行统一存储和处理。对基于信息一体化的医院财务信息一体化平台的架构进行设计,基于结构化查询语言(structured query language,SQL)技术建立财务网上报销系统,对医院财务报销业务流程进行分析,以SQL Server 2005为后台数据库,实行客户/服务器(browser/server,B/S)模式的医院财务报销流程。实验结果表明:该系统对多用户并发的单业务响应时间<4.96 s,对多用户并发的混合业务的响应时间<65 s;系统的数据吞吐量为8 Mbps,数据处理效率为87%,优于同类系统的数据处理结果,优于一般系统的操作响应性能,可以满足医院财务管理的需求,为建立信息化的医院财务管理信息平台提供参考。

In order to improve the management ability of hospital financial information,an integrated platform of hospital financial information is established by using information technology,and a unified database is used to store and process the financial information data.This paper designs the architecture of hospital financial information integration platform based on information integration,establishes a financial online reimbursement system based on structured query language(SQL)technology,analyzes the business process of hospital financial reimbursement,and takes SQL Server 2005 as the background database.Hospital financial reimbursement process based on browser/server(B/S)mode.The experimental results show that the response time of the system is less than 4.96 s for single service and less than 65 s for mixed service;The data throughput of the system is 8 Mbps,and the data processing efficiency is 87%,which is better than the data processing results of similar systems and the operation response performance of general systems,and can meet the needs of hospital financial management,and provide a reference for the establishment of an information-based hospital financial management information platform.