PDF下载

[1]范攀林璐林江舟王仁霁.基于SQL的非计划二次手术患者监测方法的探索与效果评价[J].中国卫生质量管理,2026,33(4):45-47.[doi:10.13912/j.cnki.chqm.2026.33.4.10]
　FAN Pan,LIN Lu,LIN Jiangzhou.Exploration and Effectiveness Evaluation of a SQL-Based Monitoring Method for Patients with Unplanned Reoperation[J].Chinese Health Quality Management,2026,33(4):45-47.[doi:10.13912/j.cnki.chqm.2026.33.4.10]

点击复制

基于SQL的非计划二次手术患者监测方法的探索与效果评价

《中国卫生质量管理》[ISSN:1006-7515/CN:CN 61-1283/R] 卷: 33 期数: 2026年4期页码: 45-47 栏目: 医疗质量出版日期: 2026-04-15

Title:: Exploration and Effectiveness Evaluation of a SQL-Based Monitoring Method for Patients with Unplanned Reoperation

作者:: 范攀林璐林江舟王仁霁; 厦门大学附属心血管病医院

Author(s):: FAN Pan; LIN Lu; LIN Jiangzhou; Cardiovascular Hospital of Xiamen University

关键词:: 结构化查询语言; 非计划二次手术; 监测方法; 医疗质量

Keywords:: Structured Query Language; Unplanned Reoperation; Monitoring Method; Medical Quality

分类号:: R197.323

DOI:: 10.13912/j.cnki.chqm.2026.33.4.10

文献标志码:: A

摘要:: 目的采用结构化查询语言（SQL）建立非计划二次手术查询报表，评价其监测效能，为手术质量监管提供参考。方法从样本医院电子病历系统提取2023年1月1日至12月31日的手术病例19 883例，分别采用病案首页抓取法、手麻系统筛查法及SQL语法提取法抓取非计划二次手术病例，比较通过SQL语法提取法抓取非计划二次手术病例与其他两种方法的差异。结果3种方法每月筛查花费时间分别为（24.17±11.06）min、（261.50±99.12）min、（23.00±10.38）min，SQL语法提取法显著短于手麻系统筛查法，差异具有统计学意义（P＜0.01）。SQL语法提取法及手麻系统筛查法均能筛查出非计划二次手术病例，准确率均为100%，但病案首页抓取法准确率仅为19.05%，3种监测方法准确性差异具有统计学意义（P＜0.01）。结论通过SQL语法提取法能够有效提高非计划二次手术病例筛查效率和准确性。

Abstract:: ObjectiveTo establish a query report for unplanned reoperation using structured query language (SQL) and evaluate its monitoring efficacy to provide a reference for surgical quality supervision. Methods A total of 19 883 surgical cases from January 1, 2023, to December 31, 2023, were extracted from the electronic medical record system of a sample hospital. Unplanned reoperation cases were identified through three methods: the medical record front page capture method, the anesthesia information management system screening method, and the SQL syntax extraction method. The differences in the identification of unplanned reoperation cases between the SQL syntax extraction method and the other two methods were compared. ResultsThe average monthly screening times for the three methods were (24.17 ± 11.06) min, (261.50 ± 99.12) min, and (23.00 ± 10.38) min, respectively. The SQL syntax extraction method was significantly faster than the anesthesia information management system screening method, with a statistically significant difference (P< 0.01). Both the SQL syntax extraction method and the anesthesia information management system screening method accurately identified unplanned reoperation cases with an accuracy rate of 100%, while the medical record front page capture method had an accuracy rate of only 19.05%. The differences in accuracy among the three monitoring methods were statistically significant (P< 0.01).Conclusion The SQL syntax extraction method can effectively improve the efficiency and accuracy of screening for unplanned reoperation cases.

参考文献/References:

［1］宋涵超，张艳丽，于涛，等.基于RCA方法的某三级甲等医院非计划再手术分析［J］.中国医院管理，2023，43（1）：49-52.［2］王金吉.2017年至2019年某院非计划再入院与非计划再次手术医疗质量指标评价分析［J］.中国病案，2022，23（10）：20-22，36.［3］国家卫生健康委办公厅.关于印发《三级医院评审标准（2020年版）实施细则》的通知：国卫办医发﹝2021﹞19号［EB/OL］.（2021-10-21）［2025-09-15］.https://www.nhc.gov.cn/yzygj/c100068/202110/838d aad1061d4d47bae76fd0541f573 0.shtml.［4］国家卫生健康委办公厅.关于印发手术质量安全提升行动方案（2023-2025年）的通知：国卫办医政发〔2023〕10 号［EB/OL］.（2023-08-28）［2025-09-15］. https://www.nhc.gov.cn/yzygj/c100068/202308/02b 2a53614924b88ae3a6951d65e0a 61.shtml.［5］国家卫生健康委办公厅.关于印发2022 年国家医疗质量安全改进目标的通知：国卫办医函〔2022〕58 号［EB/OL］.（ 2022-03-02）［2025-09-15］.https://www.nhc.gov.cn/yzygj/c100068/202203/d5e4af0c 96814da3974d25df0bfad607.shtml.［6］王清江，盛伟琪，左克强.基于电子病历二次开发的非计划二次手术实时监控［J］.中国卫生质量管理，2020，27（1）：51-53.［7］王莹莹，林家荣，孙允宗，等.信息化管理辅助下的非计划二次手术管理探索与实践［J］.江苏卫生事业管理，2023，34（12）：1666-1669.［8］MASON EM，HENDERSON WG，BRONSERT MR，et al.Preoperative prediction of unplanned reoperation in a broad surgical population［J］.J Surg Res，2023，285：1-12.［9］张梦玲，陈浩，钱明平，等.利用医政APP进行非计划二次手术监管［J］.中国卫生质量管理，2022，29（1）：37-38，56.

相似文献/References:

[1]王宏斌郑新瑞张珊红*刘维安书杰王东光.非计划二次手术质控策略探讨[J].中国卫生质量管理,2017,24(02):34.[doi:10.13912/j.cnki.chqm.2017.24.2.11]
[2]王清江盛伟琪左克强.基于电子病历二次开发的非计划二次手术实时监控[J].中国卫生质量管理,2020,27(01):51.[doi:10.13912/j.cnki.chqm.2020.27.1.13]
[3]张梦玲陈浩钱明平黄建华胡龙军张戟侯冷晨杨佳芳.利用医政APP进行非计划二次手术监管[J].中国卫生质量管理,2022,29(01):37.[doi:10.13912/j.cnki.chqm.2022.29.1.10 ]
　ZHANG Mengling,CHEN Hao,QIAN Mingping.Unplanned Secondary Surgery Supervision Based on Medical Administration APP[J].Chinese Health Quality Management,2022,29(4):37.[doi:10.13912/j.cnki.chqm.2022.29.1.10 ]

更新日期/Last Update: 2026-04-15