通过整合数据库和研究工具,增强美国心脏协会 "Get With The Guidelines "登记册的研究能力。

IF 6.2 2区 医学 Q1 CARDIAC & CARDIOVASCULAR SYSTEMS
Chandler Beon, Lanjing Wang, Vihaan Manchanda, Pratheek Mallya, Haoyun Hong, Holly Picotte, Kathie Thomas, Jennifer L Hall, Juan Zhao, Xue Feng
{"title":"通过整合数据库和研究工具,增强美国心脏协会 \"Get With The Guidelines \"登记册的研究能力。","authors":"Chandler Beon, Lanjing Wang, Vihaan Manchanda, Pratheek Mallya, Haoyun Hong, Holly Picotte, Kathie Thomas, Jennifer L Hall, Juan Zhao, Xue Feng","doi":"10.1161/CIRCOUTCOMES.124.010967","DOIUrl":null,"url":null,"abstract":"<p><strong>Background: </strong>The American Heart Association's Get With The Guidelines (GWTG) has emerged as a vital resource in advancing the standards and practices of inpatient care across stroke, heart failure, coronary artery disease, atrial fibrillation, and resuscitation focus areas. The GWTG registry data have also created new opportunities for secondary use of real-world clinical data in biomedical research. Our goal was to implement a scalable database with an integrated user interface (UI) to improve GWTG data management and accessibility.</p><p><strong>Methods: </strong>The curation of registry data begins by going through a data processing and quality control pipeline programmed in Python. This pipeline includes data cleaning and record exclusion, variable derivation and unit harmonization, limited data set preparation, and documentation generation of the registry data. The database was built using PostgreSQL, and integrations between the database and the UI were built using the Django Web Framework in Python. Smaller subsets of data were created using SQLite database files for distribution purposes. Use cases of these tools are provided in the article.</p><p><strong>Results: </strong>We implemented an automated data curation pipeline, centralized database, and UI application for the American Heart Association GWTG registry data. The database and the UI are accessible through a Precision Medicine Platform workspace. As of March 2024, the database contains over 13.2 million cleaned GWTG patient records. The SQLite subsets benefit researchers by optimizing data extraction and manipulation using Structured Query Language. The UI improves accessibility for nontechnical researchers by presenting data in a user-friendly tabular format with intuitive filtering options.</p><p><strong>Conclusions: </strong>With the implementation of the GWTG database and UI application, we addressed data management and accessibility concerns despite its growing scale. We have launched tools to provide streamlined access and accessibility of GWTG registry data to all researchers, regardless of familiarity or experience in coding.</p>","PeriodicalId":49221,"journal":{"name":"Circulation-Cardiovascular Quality and Outcomes","volume":" ","pages":"e010967"},"PeriodicalIF":6.2000,"publicationDate":"2024-09-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Empowering Research With the American Heart Association Get With The Guidelines Registries Through Integration of a Database and Research Tools.\",\"authors\":\"Chandler Beon, Lanjing Wang, Vihaan Manchanda, Pratheek Mallya, Haoyun Hong, Holly Picotte, Kathie Thomas, Jennifer L Hall, Juan Zhao, Xue Feng\",\"doi\":\"10.1161/CIRCOUTCOMES.124.010967\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<p><strong>Background: </strong>The American Heart Association's Get With The Guidelines (GWTG) has emerged as a vital resource in advancing the standards and practices of inpatient care across stroke, heart failure, coronary artery disease, atrial fibrillation, and resuscitation focus areas. The GWTG registry data have also created new opportunities for secondary use of real-world clinical data in biomedical research. Our goal was to implement a scalable database with an integrated user interface (UI) to improve GWTG data management and accessibility.</p><p><strong>Methods: </strong>The curation of registry data begins by going through a data processing and quality control pipeline programmed in Python. This pipeline includes data cleaning and record exclusion, variable derivation and unit harmonization, limited data set preparation, and documentation generation of the registry data. The database was built using PostgreSQL, and integrations between the database and the UI were built using the Django Web Framework in Python. Smaller subsets of data were created using SQLite database files for distribution purposes. Use cases of these tools are provided in the article.</p><p><strong>Results: </strong>We implemented an automated data curation pipeline, centralized database, and UI application for the American Heart Association GWTG registry data. The database and the UI are accessible through a Precision Medicine Platform workspace. As of March 2024, the database contains over 13.2 million cleaned GWTG patient records. The SQLite subsets benefit researchers by optimizing data extraction and manipulation using Structured Query Language. The UI improves accessibility for nontechnical researchers by presenting data in a user-friendly tabular format with intuitive filtering options.</p><p><strong>Conclusions: </strong>With the implementation of the GWTG database and UI application, we addressed data management and accessibility concerns despite its growing scale. We have launched tools to provide streamlined access and accessibility of GWTG registry data to all researchers, regardless of familiarity or experience in coding.</p>\",\"PeriodicalId\":49221,\"journal\":{\"name\":\"Circulation-Cardiovascular Quality and Outcomes\",\"volume\":\" \",\"pages\":\"e010967\"},\"PeriodicalIF\":6.2000,\"publicationDate\":\"2024-09-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Circulation-Cardiovascular Quality and Outcomes\",\"FirstCategoryId\":\"3\",\"ListUrlMain\":\"https://doi.org/10.1161/CIRCOUTCOMES.124.010967\",\"RegionNum\":2,\"RegionCategory\":\"医学\",\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"2024/8/22 0:00:00\",\"PubModel\":\"Epub\",\"JCR\":\"Q1\",\"JCRName\":\"CARDIAC & CARDIOVASCULAR SYSTEMS\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Circulation-Cardiovascular Quality and Outcomes","FirstCategoryId":"3","ListUrlMain":"https://doi.org/10.1161/CIRCOUTCOMES.124.010967","RegionNum":2,"RegionCategory":"医学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"2024/8/22 0:00:00","PubModel":"Epub","JCR":"Q1","JCRName":"CARDIAC & CARDIOVASCULAR SYSTEMS","Score":null,"Total":0}
引用次数: 0

摘要

背景:美国心脏协会的 "Get With The Guidelines"(GWTG)已成为推动中风、心力衰竭、冠心病、心房颤动和复苏等重点领域住院护理标准和实践的重要资源。GWTG 登记数据还为在生物医学研究中二次使用真实世界的临床数据创造了新的机会。我们的目标是建立一个具有集成用户界面(UI)的可扩展数据库,以改善 GWTG 数据的管理和可访问性:注册表数据的整理首先要通过用 Python 编程的数据处理和质量控制流程。该流程包括数据清理和记录排除、变量推导和单位统一、有限数据集准备以及登记册数据文档生成。数据库使用 PostgreSQL 建立,数据库和用户界面之间的集成使用 Python 中的 Django 网络框架建立。为便于分发,使用 SQLite 数据库文件创建了较小的数据子集。文章中提供了这些工具的使用案例:我们为美国心脏协会 GWTG 登记数据实施了自动数据整理管道、集中式数据库和用户界面应用程序。数据库和用户界面可通过精准医学平台工作区访问。截至 2024 年 3 月,该数据库包含超过 1320 万条经过清理的 GWTG 患者记录。SQLite 子集通过使用结构化查询语言优化数据提取和操作,使研究人员受益匪浅。用户界面以用户友好的表格格式显示数据,并提供直观的过滤选项,从而提高了非技术研究人员的可访问性:通过实施 GWTG 数据库和用户界面应用程序,我们解决了数据管理和可访问性方面的问题,尽管其规模不断扩大。我们推出了各种工具,为所有研究人员提供简化的 GWTG 登记数据访问和可访问性,无论他们是否熟悉编码或是否有编码经验。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
Empowering Research With the American Heart Association Get With The Guidelines Registries Through Integration of a Database and Research Tools.

Background: The American Heart Association's Get With The Guidelines (GWTG) has emerged as a vital resource in advancing the standards and practices of inpatient care across stroke, heart failure, coronary artery disease, atrial fibrillation, and resuscitation focus areas. The GWTG registry data have also created new opportunities for secondary use of real-world clinical data in biomedical research. Our goal was to implement a scalable database with an integrated user interface (UI) to improve GWTG data management and accessibility.

Methods: The curation of registry data begins by going through a data processing and quality control pipeline programmed in Python. This pipeline includes data cleaning and record exclusion, variable derivation and unit harmonization, limited data set preparation, and documentation generation of the registry data. The database was built using PostgreSQL, and integrations between the database and the UI were built using the Django Web Framework in Python. Smaller subsets of data were created using SQLite database files for distribution purposes. Use cases of these tools are provided in the article.

Results: We implemented an automated data curation pipeline, centralized database, and UI application for the American Heart Association GWTG registry data. The database and the UI are accessible through a Precision Medicine Platform workspace. As of March 2024, the database contains over 13.2 million cleaned GWTG patient records. The SQLite subsets benefit researchers by optimizing data extraction and manipulation using Structured Query Language. The UI improves accessibility for nontechnical researchers by presenting data in a user-friendly tabular format with intuitive filtering options.

Conclusions: With the implementation of the GWTG database and UI application, we addressed data management and accessibility concerns despite its growing scale. We have launched tools to provide streamlined access and accessibility of GWTG registry data to all researchers, regardless of familiarity or experience in coding.

求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
Circulation-Cardiovascular Quality and Outcomes
Circulation-Cardiovascular Quality and Outcomes CARDIAC & CARDIOVASCULAR SYSTEMS-
CiteScore
8.50
自引率
2.90%
发文量
357
审稿时长
4-8 weeks
期刊介绍: Circulation: Cardiovascular Quality and Outcomes, an American Heart Association journal, publishes articles related to improving cardiovascular health and health care. Content includes original research, reviews, and case studies relevant to clinical decision-making and healthcare policy. The online-only journal is dedicated to furthering the mission of promoting safe, effective, efficient, equitable, timely, and patient-centered care. Through its articles and contributions, the journal equips you with the knowledge you need to improve clinical care and population health, and allows you to engage in scholarly activities of consequence to the health of the public. Circulation: Cardiovascular Quality and Outcomes considers the following types of articles: Original Research Articles, Data Reports, Methods Papers, Cardiovascular Perspectives, Care Innovations, Novel Statistical Methods, Policy Briefs, Data Visualizations, and Caregiver or Patient Viewpoints.
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信