[1]崔金广,窦一峰,蒙文涛,等.基于ETL技术的医院质控数据库系统设计与实现[J].医学信息,2021,34(04):16-21.[doi:10.3969/j.issn.1006-1959.2021.04.005]
　Jin-guang,DOU Yi-feng,MENG Wen-tao,et al.Design and Implementation of Hospital Quality Control Database System Based on ETL TechnologyCUI[J].Medical Information,2021,34(04):16-21.[doi:10.3969/j.issn.1006-1959.2021.04.005]
点击复制

基于ETL技术的医院质控数据库系统设计与实现()
分享到：

医学信息[ISSN:1006-1959/CN:61-1278/R]

卷:
34卷
期数:
2021年04期
页码:
16-21
栏目:
出版日期:
2021-02-15

文章信息/Info

Title:
Design and Implementation of Hospital Quality Control Database System Based on ETL TechnologyCUI
文章编号:
1006-1959（2021）04-0016-06
作者:
崔金广; 窦一峰; 蒙文涛; 等
（天津市宝坻区人民医院网络信息中心，天津 301800）
Author(s):
Jin-guang; DOU Yi-feng; MENG Wen-tao; et al.
(Network Information Center,Tianjin Baodi Hospital,Tianjin 301800,China)
关键词:
医院质控数据库; 医疗质量; 质控指标; 设计
Keywords:
Hospital quality control database; Medical quality; Quality control index; Design
分类号:
R197
DOI:
10.3969/j.issn.1006-1959.2021.04.005
文献标志码:
B
摘要:
针对公立医院三级绩效考核数据采集分散、数据统计公式和标准不规范、内容反馈和呈现不直观等问题，本文构建了基于数据仓库（ETL）技术的医院质控数据库系统，主要包括时间维度与科室维度下的数据字典、指标分类、数据录入、报告展示、对比输出等内容。依托大数据分析，通过Kettle分别由HIS、LIS、PACS、EMR、卫生统计、OA等信息系统提取数据，将其加工、整理后存储到质控数据库，并开发设计B/S架构的医院质控数据库系统，对质控数据进行统一管理。最终实现及时准确的提取、加工、整理质控指标数据的目的，旨在为院领导决策、职能处室和临床科室提供准确有效的数据支持。
Abstract:
In view of the scattered collection of three-level performance appraisal data in public hospitals, irregular data statistical formulas and standards, and unintuitive content feedback and presentation, etc.this article builds a hospital quality control database system based on data warehouse (ETL) technology, which mainly includes data dictionary, index classification, data entry, report display, comparison output, etc. under the time dimension and department dimension.Relying on big data analysis, Kettle extracts data from HIS, LIS, PACS, EMR, health statistics, OA and other information systems respectively, and stores them in the quality control database after processing and sorting.And develop and design a hospital quality control database system with B/S structure, and conduct unified management of quality control data.In the end, the purpose of timely and accurate extraction, processing, and sorting of quality control index data is realized, and it aims to provide accurate and effective data support for hospital leadership decision-making, functional departments and clinical departments.

参考文献/References:

[1]徐祥贵,丁强,陈彦,等.“组团式”援疆促进医疗质量持续改进的实践与探索[J].现代医院管理,2018,16(3):13-16. [2]李泉,李雪婉,孙鉴.区域卫生信息化进程中大数据分析在公立医院绩效考核应用[J].医学信息,2014,27(4):1. [3]谢世堂,沈慧,曹桂,等.基于融合理念的公立医院内部绩效考核体系探索研究[J].中国医院管理,2017(10):22-24. [4]胡军,贾垒,袁晋华.现代化医院医疗质量管理的体系建设与实践[J].卫生软科学,2018,32(10):39-41. [5]管雅文.整合生物信息的临床数据中心建设方案[J].中国数字医学,2019,14(2):57-59. [6]魏小林,叶舟,拓宽前.基于ETL技术的医院绩效管理系统设计与实现[J].中国数字医学,2015,10(11):22-24. [7]Kushiro N,Matsuda S,Takahara K.Model Oriented System Design on Big-data[J].Procedia Computer ence,2014(35):961-968. [8]贾军华,徐洋阳.医疗大数据在医院绩效管理中的应用探讨[J].中国管理信息化,2019,22(24):48-49. [9]廖家智,陈安民,徐永健,等.精准化、信息化、系统化的医疗质量与安全体系构建[J].中华医院管理杂志,2016(32):123-125. [10]赵贵兵.Kettle应用案例分析[J].电脑知识与技术,2019,15(9):95-96. [11]刘繁艳.基于数据仓库的ETL技术研究[J].软件导刊,2007(11):24-26. [12]周丹,尹安春,张秀杰.基于Web of Science的肾脏病学领域护理研究的可视化分析[J].中国实用护理杂志,2020,36(4):315-321. [13]朱鹏志.基于Ajax和SSH技术的办公自动化系统的实现[D].青岛大学,2020.

相似文献/References:

[1]陈志强,张 甄,欧阳邦辉.基于质量数据中心的医疗质量管理实践[J].医学信息,2019,32(10):3.[doi:10.3969/j.issn.1006-1959.2019.10.002]
　CHEN Zhi-qiang,ZHANG Zhen,OUYANG Bang-hui.Medical Quality Management Practice Based on Quality Data Center[J].Medical Information,2019,32(04):3.[doi:10.3969/j.issn.1006-1959.2019.10.002]
[2]方 涛,沈宁乔,范晓薇,等.医院感染管理信息化实践与应用[J].医学信息,2020,33(24):11.[doi:10.3969/j.issn.1006-1959.2020.24.004]
　FANG Tao,SHEN Ning-qiao,FAN Xiao-wei,et al.Practice and Application of Hospital Infection Management Information[J].Medical Information,2020,33(04):11.[doi:10.3969/j.issn.1006-1959.2020.24.004]
[3]吴治林,何 秦,张 东,等.医联体内机构同质化管理方法的效果评价[J].医学信息,2021,34(04):151.[doi:10.3969/j.issn.1006-1959.2021.04.041]
　WU Zhi-lin,HE Qin,ZHANG Dong,et al.Evaluation of the Effect of the Homogenization Management Method of Institutions in the Medical Partnership[J].Medical Information,2021,34(04):151.[doi:10.3969/j.issn.1006-1959.2021.04.041]
[4]周 芮,陈彦东,宿 明.基于大数据和AI的电子病历自动质控系统构建[J].医学信息,2022,35(04):13.[doi:10.3969/j.issn.1006-1959.2022.04.004]
　ZHOU Rui,CHEN Yan-dong,SU Ming.Construction of Automatic Quality Control System for Electronic Medical RecordsBased on Big Data and AI[J].Medical Information,2022,35(04):13.[doi:10.3969/j.issn.1006-1959.2022.04.004]
[5]陈 涛,田怀谷,卢 红,等.基于CiteSpace可视化分析我国医生职业倦怠研究热点与趋势[J].医学信息,2022,35(07):5.[doi:10.3969/j.issn.1006-1959.2022.07.002]
　CHEN Tao,TIAN Huai-gu,LU Hong,et al.Analysis of Research Hotspots and Trends of Doctor Burnout in China Based on CiteSpace Visualization[J].Medical Information,2022,35(04):5.[doi:10.3969/j.issn.1006-1959.2022.07.002]
[6]朱绮霞,梁 鹏,李红霞.精细化管理在提升手术室运行效率和质量中的实践及效果评价[J].医学信息,2022,35(14):102.[doi:10.3969/j.issn.1006-1959.2022.14.024]
　ZHU Qi-xia,LIANG Peng,LI Hong-xia.Practice and Effect Assessment of Fine Management in Improving the Operating Efficiency and Quality of the Operating Room[J].Medical Information,2022,35(04):102.[doi:10.3969/j.issn.1006-1959.2022.14.024]
[7]张泓柳,李杨凤,梁雷颖.运用Topsis法和综合指数法综合评价广西某紧密型医联体成员单位的医疗质量[J].医学信息,2023,36(13):62.[doi:10.3969/j.issn.1006-1959.2023.13.011]
　ZHANG Hong-liu,LI Yang-feng,LIANG Lei-ying.Synthetic Evaluation of a Tight Medical Association Member Unit’s Medical Quality in Guangxi with Topsis and Synthetic Index Method[J].Medical Information,2023,36(04):62.[doi:10.3969/j.issn.1006-1959.2023.13.011]
[8]窦一峰,吕劲松.某三级医院脑部疾病出院病例统计分析[J].医学信息,2023,36(14):44.[doi:10.3969/j.issn.1006-1959.2023.14.008]
　DOU Yi-feng,LYU Jin-song.Statistical Analysis of Discharged Cases of Brain Diseases in a Tertiary Hospital[J].Medical Information,2023,36(04):44.[doi:10.3969/j.issn.1006-1959.2023.14.008]
[9]胡志伟.基于PowerBI的病案首页可视化统计分析[J].医学信息,2023,36(21):21.[doi:10.3969/j.issn.1006-1959.2023.21.005]
　HU Zhi-wei.Visual Statistical Analysis of Medical Record Home Page Based on PowerBI[J].Medical Information,2023,36(04):21.[doi:10.3969/j.issn.1006-1959.2023.21.005]
[10]朱绮霞,闫晓婷,任 洁,等.基于OA平台线上线下相结合的医疗不良事件闭环管理模式实践[J].医学信息,2024,37(04):65.[doi:10.3969/j.issn.1006-1959.2024.04.011]
　ZHU Qi-xia,YAN Xiao-ting,REN Jie,et al.Practice of Closed-loop Management Mode of Medical Adverse Events Based on OA Platform Combining Online and Offline[J].Medical Information,2024,37(04):65.[doi:10.3969/j.issn.1006-1959.2024.04.011]

更新日期/Last Update: 1900-01-01