The Process of Installing REDCap, a Web Based Database Supporting Biomedical Research

Summary

Background: Clinical and research data are essential for patient care, research and healthcare system planning. REDCapTM is a web-based tool for research data curatorship developed at Vanderbilt University in Nashville, USA. The Faculty of Health Sciences at the University of the Witwatersrand, Johannesburg South Africa identified the need for a cost effective data management instrument. REDCap was installed as per the user agreement with Vanderbilt University in August 2012.

Objectives: In order to assist other institutions that may lack the in-house Information Technology capacity, this paper describes the installation and support of REDCap and incorporates an analysis of user uptake over the first year of use.

Methods: We reviewed the staffing requirements, costs of installation, process of installation and necessary infrastructure and end-user requests following the introduction of REDCap at Wits. The University Legal Office and Human Research Ethics Committee were consulted regarding the REDCap end-user agreement. Bi-monthly user meetings resulted in a training workshop in August 2013. We compared our REDCap software user numbers and records before and after the first training workshop.

Results: Human resources were recruited from existing staff. Installation costs were limited to servers and security certificates. The total costs to provide a functional REDCap platform was less than $9000. Eighty-one (81) users were registered in the first year. After the first training workshop the user numbers increased by 59 in one month and the total number of active users to 140 by the end of August 2013. Custom software applications for REDCap were created by collaboration between clinicians and software developers.

Conclusion: REDCap was installed and maintained at limited cost. A small number of people with defined skills can support multiple REDCap users in two to four hours a week. End user training increased in the number of users, number of projects created and the number of projects moved to production.

Citation: Klipin M, Mare I, Hazelhurst S, Kramer B. The process of installing REDCap, a web based database supporting biomedical research – the first year. Appl Clin Inf 2014; 5: 916–929

http://dx.doi.org/10.4338/ACI-2014-06-CR-0054

Keywords

Database management systems - medical informatics - electronic data capture - clinical research - translational research

• References

• 1 Coovadia H, Jewkesn R, Barron P, Sanders D, McIntyre D. The health and health system of South Africa: historical roots of current public health challenges. Lancet 2009; 374 9692 817-834.
• 2 University of the Witwatersrand.. Faculty of health Sciences, Faculty. http://www.wits.ac.za/academichealth/faculty/ (Last accessed 4/21/2014)
• 3 University of the Witwatersrand.. Library. Database management guidelines. http://libguides.wits.ac.zaDataManagement/ (Last accessed 4/21/2014)
• 4 Paulus JK, Santoyo-Vistrain R, Havelick D, Cohen A, Kalyesubula R, Ajayi IO, Mattsson JG, Adami H, Dalal H. Global teaching and training initiatives for emerging cohort studies. Journal of Epidemiology and Global Health 2012; 2: 125-133.
• 5 Travis P, Bennett S, Haines A, Pang T, Bhutta Z, Hyder AA, Pielemeier NR, Mills A, Evans T. Overcoming health-systems constraints to achieve the Millennium Development Goals. Lancet 2004; 364 9437 900-906.
• 6 Harris PA, Taylor R, Thielke R, Payne J, Gonzalez N, Conde JG. Research electronic data capture (REDCap) –a metadata-driven methodology and workflow process for providing translational research informatics support. J Biomed Inform 2009; 42 (02) 377-381.
• 7 Gallagher SA, Smith AB, Mathews JE, Potter CW, Woods ME, Raynor M, Wallen EM, Rathmell WK, Whang YE, Kim WY, Godley PA, Chen RC, Wang A, You C, Barocas DA, Pruthi RS, Nielson ME, Milowsky MI. Roadmap for the development of the University of North Carolina at Chapel Hill Genitourinary Oncology Database –UNC GOLD. Urologic Oncology: Seminars and Original Investigations 2014; 32 (01) 1-9.
• 8 Franklin JD, Guidrya A, Brinkleya JF. A partnership approach for electronic data capture in small-scale clinical trials. J Biomed Inform 2011; 44 (01) S103-S108.
• 9 REDCap http://project-REDCap.org (Last accessed 4/21/2014)
• 10 Habib I. Virtualization with KVM. Linux Journal 2008; 166: 8.
• 11 Powers S. LVM Demystified. Linux Journal 2013; 236: 7.
• 12 http://www.vtoxford.org/enicq/enicq5/documents/eNICQ5ExternalDataInterfaceGuide.pdf (Last accessed 4/21/2014)
• 13 Paulus JK, Santoyo-Vistrain R, Havelick D, Cohen A, Kalyesubula R, Ajayi IO, Mattsson JG, Adami H, Dalal H. Global teaching and training initiatives for emerging cohort studies. Journal of Epidemiology and Global Health 2012; 2: 125-133.
• 14 Lorenzi NM, Riley RT. Managing Technological Change: Organizational Aspects of Health Informatics. 2nd Ed. New York: Springer Verlag; 2004
• 15 Lyratzopoulos G, Patrick H, Campbell B. Registers needed for new interventional procedures. Lancet 2008; 371 9626 1734-1736.
• 16 Dreyer NA. Garner S Registries for robust evidence. JAMA 2009; 302 (07) 790-791.
• 17 Jacobs JP, Edwards FH, Shahian DM, Haan CK, Puskas JD, Morales LS, Gammie JS, Sanches JA, Brennan MJ, O’Brien SM, Dokholyan SD, Hammill BG, Curtis LH, Peterson ED, Badhwar V, George KM, Mayer JE, Chitwood WR, Murray GF, Grover FL. Successful linking of the Society of Thoracic Surgeons adult cardiac surgery database to Centers for Medicare and Medicaid Services Medicare data. Ann Thoracic Surg 2010; 90 (01) 1150-1156.