William D Dunn1, Jake Cobb2, Allan I Levey3, David A Gutman4. 1. Department of Neurology, Emory University, Atlanta, GA, USA; Department of Biomedical Informatics, Emory University, Atlanta, GA, USA. 2. College of Computing, Georgia Institute of Technology, Atlanta, GA, USA. 3. Department of Neurology, Emory University, Atlanta, GA, USA. 4. Department of Neurology, Emory University, Atlanta, GA, USA; Department of Biomedical Informatics, Emory University, Atlanta, GA, USA. Electronic address: dgutman@emory.edu.
Abstract
OBJECTIVE: A memory clinic at an academic medical center has relied on several ad hoc data capture systems including Microsoft Access and Excel for cognitive assessments over the last several years. However these solutions are challenging to maintain and limit the potential of hypothesis-driven or longitudinal research. REDCap, a secure web application based on PHP and MySQL, is a practical solution for improving data capture and organization. Here, we present a workflow and toolset to facilitate legacy data migration and real-time clinical research data collection into REDCap as well as challenges encountered. MATERIALS AND METHODS: Legacy data consisted of neuropsychological tests stored in over 4000 Excel workbooks. Functions for data extraction, norm scoring, converting to REDCap-compatible formats, accessing the REDCap API, and clinical report generation were developed and executed in Python. RESULTS: Over 400 unique data points for each workbook were migrated and integrated into our REDCap database. Moving forward, our REDCap-based system replaces the Excel-based data collection method as well as eases the integration into the standard clinical research workflow and Electronic Health Record. CONCLUSION: In the age of growing data, efficient organization and storage of clinical and research data is critical for advancing research and providing efficient patient care. We believe that the workflow and tools described in this work to promote legacy data integration as well as real time data collection into REDCap ultimately facilitate these goals. Published by Elsevier Ireland Ltd.
OBJECTIVE: A memory clinic at an academic medical center has relied on several ad hoc data capture systems including Microsoft Access and Excel for cognitive assessments over the last several years. However these solutions are challenging to maintain and limit the potential of hypothesis-driven or longitudinal research. REDCap, a secure web application based on PHP and MySQL, is a practical solution for improving data capture and organization. Here, we present a workflow and toolset to facilitate legacy data migration and real-time clinical research data collection into REDCap as well as challenges encountered. MATERIALS AND METHODS: Legacy data consisted of neuropsychological tests stored in over 4000 Excel workbooks. Functions for data extraction, norm scoring, converting to REDCap-compatible formats, accessing the REDCap API, and clinical report generation were developed and executed in Python. RESULTS: Over 400 unique data points for each workbook were migrated and integrated into our REDCap database. Moving forward, our REDCap-based system replaces the Excel-based data collection method as well as eases the integration into the standard clinical research workflow and Electronic Health Record. CONCLUSION: In the age of growing data, efficient organization and storage of clinical and research data is critical for advancing research and providing efficient patient care. We believe that the workflow and tools described in this work to promote legacy data integration as well as real time data collection into REDCap ultimately facilitate these goals. Published by Elsevier Ireland Ltd.
Entities:
Keywords:
Biomedical informatics; Clinical informatics; Clinical research informatics; ETL; Electronic health record; REDCap
Authors: Paul A Harris; Robert Taylor; Robert Thielke; Jonathon Payne; Nathaniel Gonzalez; Jose G Conde Journal: J Biomed Inform Date: 2008-09-30 Impact factor: 6.317
Authors: J C Morris; A Heyman; R C Mohs; J P Hughes; G van Belle; G Fillenbaum; E D Mellits; C Clark Journal: Neurology Date: 1989-09 Impact factor: 9.910
Authors: Christopher B Forrest; Peter A Margolis; L Charles Bailey; Keith Marsolo; Mark A Del Beccaro; Jonathan A Finkelstein; David E Milov; Veronica J Vieland; Bryan A Wolf; Feliciano B Yu; Michael G Kahn Journal: J Am Med Inform Assoc Date: 2014-05-12 Impact factor: 4.497
Authors: R Martin-Willett; Z McCormick; W Newman; L D Larsen; M A Ortiz Torres; L C Bidwell Journal: J Biomed Inform Date: 2019-04-22 Impact factor: 6.317
Authors: Jessica Andriesen; Sheana Bull; Janan Dietrich; Jessica E Haberer; Barbara Van Der Pol; Yegor Voronin; Kristin M Wall; Christopher Whalen; Frances Priddy Journal: J Med Internet Res Date: 2017-07-31 Impact factor: 5.428