摘要
针对公立医院三级绩效考核数据采集分散、数据统计公式和标准不规范、内容反馈和呈现不直观等问题,本文构建了基于数据仓库(ETL)技术的医院质控数据库系统,主要包括时间维度与科室维度下的数据字典、指标分类、数据录入、报告展示、对比输出等内容。依托大数据分析,通过Kettle分别由HIS、LIS、PACS、EMR、卫生统计、OA等信息系统提取数据,将其加工、整理后存储到质控数据库,并开发设计B/S架构的医院质控数据库系统,对质控数据进行统一管理。最终实现及时准确的提取、加工、整理质控指标数据的目的,旨在为院领导决策、职能处室和临床科室提供准确有效的数据支持。
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.
作者
崔金广
窦一峰
蒙文涛
吴秀春
CUI Jin-guang;DOU Yi-feng;MENG Wen-tao;WU Xiu-chun(Network Information Center,Tianjin Baodi Hospital,Tianjin 301800,China)
出处
《医学信息》
2021年第4期16-21,共6页
Journal of Medical Information
基金
天津市卫生健康科技项目(编号:ZC20095)。
关键词
医院质控数据库
医疗质量
质控指标
设计
Hospital quality control database
Medical quality
Quality control index
Design
