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

IF 6.2 2区 医学 Q1 CARDIAC & CARDIOVASCULAR SYSTEMS Circulation-Cardiovascular Quality and Outcomes Pub Date : 2024-09-01 Epub Date: 2024-08-22 DOI:10.1161/CIRCOUTCOMES.124.010967
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 登记数据访问和可访问性,无论他们是否熟悉编码或是否有编码经验。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
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.
期刊最新文献
Cost-Effectiveness of Aortic Valve Replacement in Low- and Intermediate-Risk Chinese Patients With Severe Aortic Stenosis. Cost-Effectiveness of Transcatheter Versus Surgical Aortic Valve Replacement in China: Same, but Different. Racial and Ethnic Differences in Prepregnancy Hypertension by Maternal Age. Association Between Use of WATCHMAN Device and 1-Year Mortality Using High-Dimensional Propensity Scores to Reduce Confounding. Predicting Mortality in Patients Hospitalized With Acute Myocardial Infarction: From the National Cardiovascular Data Registry.
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1