PDF(Pubmed)
Abstract：
OBJECTIVE: Collaborate, Analyse, Research and Audit (CARA) project set out to provide an infrastructure to enable Irish general practitioners (GPs) to use their routinely collected patient management software (PMS) data to better understand their patient population, disease management and prescribing through data dashboards. This paper explains the design and development of the CARA infrastructure.
METHODS: The first exemplar dashboard was developed with GPs and focused on antibiotic prescribing to develop and showcase the proposed infrastructure. The data integration process involved extracting, loading and transforming de-identified patient data into data models which connect to the interactive dashboards for GPs to visualise, compare and audit their data.
RESULTS: The architecture of the CARA infrastructure includes two main sections: extract, load and transform process (ELT, de-identified patient data into data models) and a Representational State Transfer Application Programming Interface (REST API) (which provides the security barrier between the data models and their visualisation on the CARA dashboard). CARAconnect was created to facilitate the extraction and de-identification of patient data from the practice database.
CONCLUSIONS: The CARA infrastructure allows seamless connectivity with and compatibility with the main PMS in Irish general practice and provides a reproducible template to access and visualise patient data. CARA includes two dashboards, a practice overview and a topic-specific dashboard (example focused on antibiotic prescribing), which includes an audit tool, filters (within practice) and between-practice comparisons.
CONCLUSIONS: CARA supports evidence-based decision-making by providing GPs with valuable insights through interactive data dashboards to optimise patient care, identify potential areas for improvement and benchmark their performance against other practices.Supplementary file 1. Graphical abstract.
METHODS: The first exemplar dashboard was developed with GPs and focused on antibiotic prescribing to develop and showcase the proposed infrastructure. The data integration process involved extracting, loading and transforming de-identified patient data into data models which connect to the interactive dashboards for GPs to visualise, compare and audit their data.
RESULTS: The architecture of the CARA infrastructure includes two main sections: extract, load and transform process (ELT, de-identified patient data into data models) and a Representational State Transfer Application Programming Interface (REST API) (which provides the security barrier between the data models and their visualisation on the CARA dashboard). CARAconnect was created to facilitate the extraction and de-identification of patient data from the practice database.
CONCLUSIONS: The CARA infrastructure allows seamless connectivity with and compatibility with the main PMS in Irish general practice and provides a reproducible template to access and visualise patient data. CARA includes two dashboards, a practice overview and a topic-specific dashboard (example focused on antibiotic prescribing), which includes an audit tool, filters (within practice) and between-practice comparisons.
CONCLUSIONS: CARA supports evidence-based decision-making by providing GPs with valuable insights through interactive data dashboards to optimise patient care, identify potential areas for improvement and benchmark their performance against other practices.Supplementary file 1. Graphical abstract.
摘要：
目标：合作，分析,研究和审计（CARA）项目旨在提供基础设施，使爱尔兰全科医生（GP）能够使用其常规收集的患者管理软件（PMS）数据来更好地了解其患者人群，通过数据仪表板进行疾病管理和处方。本文介绍了CARA基础设施的设计和开发。
方法：第一个示例性仪表板是与全科医生一起开发的，重点是抗生素处方，以开发和展示拟议的基础设施。数据集成过程涉及提取，将去识别的患者数据加载并转换为连接到交互式仪表板的数据模型，以便全科医生可视化，比较和审核他们的数据。
结果：CARA基础架构的体系结构包括两个主要部分：摘录，加载和转换过程(ELT，将患者数据去识别为数据模型）和代表性状态转移应用程序编程接口（RESTAPI）（在CARA仪表板上提供数据模型及其可视化之间的安全屏障）。创建CARAconnect是为了便于从实践数据库中提取和取消识别患者数据。
结论：CARA基础设施允许与爱尔兰一般实践中的主要PMS无缝连接和兼容性，并提供了可重复的模板来访问和可视化患者数据。CARA包括两个仪表板，实践概述和特定主题的仪表板（示例集中在抗生素处方上），其中包括一个审计工具，过滤器(实践中)和实践之间的比较。
结论：CARA通过交互式数据仪表板为全科医生提供有价值的见解，以优化患者护理，从而支持基于证据的决策。确定潜在的改进领域，并根据其他实践对其性能进行基准测试。补充文件1.图形抽象。
方法：第一个示例性仪表板是与全科医生一起开发的，重点是抗生素处方，以开发和展示拟议的基础设施。数据集成过程涉及提取，将去识别的患者数据加载并转换为连接到交互式仪表板的数据模型，以便全科医生可视化，比较和审核他们的数据。
结果：CARA基础架构的体系结构包括两个主要部分：摘录，加载和转换过程(ELT，将患者数据去识别为数据模型）和代表性状态转移应用程序编程接口（RESTAPI）（在CARA仪表板上提供数据模型及其可视化之间的安全屏障）。创建CARAconnect是为了便于从实践数据库中提取和取消识别患者数据。
结论：CARA基础设施允许与爱尔兰一般实践中的主要PMS无缝连接和兼容性，并提供了可重复的模板来访问和可视化患者数据。CARA包括两个仪表板，实践概述和特定主题的仪表板（示例集中在抗生素处方上），其中包括一个审计工具，过滤器(实践中)和实践之间的比较。
结论：CARA通过交互式数据仪表板为全科医生提供有价值的见解，以优化患者护理，从而支持基于证据的决策。确定潜在的改进领域，并根据其他实践对其性能进行基准测试。补充文件1.图形抽象。
