Construction and application of management system based on SQL server database for medical equipment of co-building laboratories of hospital
10.3969/j.issn.1672-8270.2025.10.013
- VernacularTitle:基于SQL server数据库的医院共建实验室设备管理系统构建及应用
- Author:
Yang WANG
1
;
Zheng WANG
;
Xin WANG
Author Information
1. 淄博市第一医院院办公室 淄博 255200
- Publication Type:Journal Article
- Keywords:
SQL server database;
Co-building laboratory of hospital;
Medical equipment;
Management efficiency for equipment;
Data security
- From:
China Medical Equipment
2025;22(10):66-72
- CountryChina
- Language:Chinese
-
Abstract:
Objective:To build a management system based on SQL server database for medical equipment of co-building laboratories of hospital,so as to achieve management with high efficiency for medical equipment.Methods:This system adopted a browser/server(B/S)architecture.The front-end used HyperText Markup Language(HTML)to construct the page structure,which combined Cascading Style Sheets(CSS)for style beautification,and realized dynamic interactive effects and data verification through JavaScript,so as to provide an intuitive and smooth operation interface for users.The back-end used MyBatis framework to conduct efficient data interaction with the SQL Server 2019 database.A full life cycle management process with six major modules was constructed,which included monitoring module for equipment status,management and control module for equipment's full-process,intelligent dispatching module,maintenance and early warning module for equipment,statistics and reporting module for data,and traceability module for quality control.Through standardized data interfaces and business processes,the system realized collaborative management for medical equipment in the hospital's co-building laboratories.A total of sixty medical equipment of laboratory at Zibo People's Hospital from January to December 2024 were selected,and they were grouped according to different management modes.The different groups were managed respectively by adopting conventional management mode and management mode based on SQL server database for medical equipment of co-building laboratories of hospital(referred to as SQL server database management mode),with 30 equipment for each mode.The operationally convenient degree for system,multi-dimensional performance scores of equipment,the management quality of the entire process and the defect rate of management between the two management modes were compared.Results:The timely rate of response,simplification rate of repetitive operations,coverage rate of real-time feedback and accuracy rate of analyzing fault code of medical equipment under the SQL server database management mode were respectively(95.56±5.99)%,(12.36±2.33)%,(94.22±6.69)%and(93.66±5.33)%,all of which were significantly higher than those of the conventional management mode,and the differences were statistically significant(t=10.723,6.921,8.934,8.359,P<0.05).The scores for the usage efficiency,maintenance efficiency and repair efficiency of medical equipment of the SQL server database management mode were significantly higher than those of the conventional management mode,respectively,and the differences were statistically significant(t=12.113,7.569,8.072,P<0.05).The scores for the rationality of the procurement plan,the standardization of the acceptance process,the implementation degree of the operational norms,the timeliness of the maintenance plan,and the traceability of quality issues for medical equipment of the SQL server database management mode were significantly higher than those of the conventional management mode,and the differences were statistically significant(t=4.469,5.541,5.445,6.139,6.698,P<0.05).The error rates of sub-packaging medical equipment,damage rate of equipment,and maintenance rate of equipment of the SQL server database management mode were all significantly lower than those of the conventional management mode,and the differences were statistically significant(x2=5.192,6.405,4.320,P<0.05).Conclusion:Adopting the SQL server database management mode to manage equipment can significantly improve the convenience of operating equipment,and enhance the multi-dimensional efficiency of the equipment,and realize the full-process management for equipment,and reduce defect rate of managing equipment.
