首页 | 本学科首页   官方微博 | 高级检索  
     

基于SQL 数据库的医院财务管理信息平台
引用本文:傅,仁.基于SQL 数据库的医院财务管理信息平台[J].兵工自动化,2024,43(2):23-27.
作者姓名:  
作者单位:上海交通大学医学院附属上海儿童医学中心
摘    要:为提升医院财务信息的管理能力,利用信息化技术建立医院财务信息一体化平台,采用统一的数据库对财务信息数据进行统一存储和处理。对基于信息一体化的医院财务信息一体化平台的架构进行设计,基于结构化查询语言(structuredquerylanguage,SQL)技术建立财务网上报销系统,对医院财务报销业务流程进行分析,以SQL Server2005为后台数据库,实行客户/服务器(browser/server,B/S)模式的医院财务报销流程。实验结果表明:该系统对多用户并发的单业务响应时间<4.96s,对多用户并发的混合业务的响应时间<65s;系统的数据吞吐量为8 Mbps,数据处理效率为87%,优于同类系统的数据处理结果,优于一般系统的操作响应性能,可以满足医院财务管理的需求,为建立信息化的医院财务管理信息平台提供参考。

关 键 词:医院财务管理  报销系统  信息平台  SQL数据库
收稿时间:2023/10/13 0:00:00
修稿时间:2023/11/20 0:00:00

Hospital Financial Management Information Platform Based on SQL Database
Abstract: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.
Keywords:hospitals financial management  reimbursement system  information platform  SQL database
点击此处可从《兵工自动化》浏览原始摘要信息
点击此处可从《兵工自动化》下载全文
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号