基于Caché数据库和ETL过程的医疗质量辅助决策方法研究  

Medical Quality Decision Support Method Based on Caché Database and ETL Tools

作　　者：刘蔷[1] 廖茂成[1] 李韶朗 范世平[1] 龙桂芳[1] 

机构地区：[1]汕头大学医学院附属粤北人民医院,广东韶关512025

出　　处：《中国卫生质量管理》2015年第1期94-96,共3页Chinese Health Quality Management

基　　金：2012年韶关市医药卫生科研计划项目(Y13207)

摘　　要：目的探讨构建医疗质量辅助决策平台方法。方法与医院信息管理系统对接,利用ETL过程对Caché数据库中的医疗数据进行提取、转换和加载。结果参照医疗质量指标体系,建立了一套丰富的指标集合。对医院前瞻性数据进行实时动态分析,具备高效完善的数据提取和预处理机制、灵活的界面定制和开发机制,同时具有强大的数据分析、钻取和结果展示功能。结论医疗质量辅助决策平台方法能够在医疗质量辅助决策、管理、科研、预测、评价等方面发挥重要的作用。Objective To preliminarily investigate methods of constructing a medical quality decision support platform based on Cache database and ETL tools. Method Docking with the hospital information management system, we designed new ETL tools to analyze medical data from Cache; databases. Result Based on the medical quality indicators system, a rich set of indicators was established. The hospital prospective data can be dynamic analyzed in real time, improve the efficiency of the data extraction anti pretreatment mechanism, have flexible interface customization and development mechanism, powerful data analysis and drill function. Conclusion This preliminary study plays an important role in decision - making and management, medical quality control, forecasting, evaluation and other aspects.

关 键 词：SPEED ETL Caché数据库 医疗质量 辅助决策 

分 类 号：R197.32[医药卫生—卫生事业管理]