Subscribe to RSS
Download PDF
DOI: 10.1055/s-0041-1728962
How I Do it: A Practical Database Management System to Assist Clinical Research Teams with Data Collection, Organization, and Reporting
Financial support and sponsorship Nil.
Abstract
With the growing amount of research projects in the field of interventional radiology, storing and organizing the patients' data and information effectively is becoming more difficult. Existing hospital electronic medical record and archiving systems store patient information in the form of reports which put the physicians and researchers in a situation where they have to use time-consuming manual search through reports for suitable patients for different clinical researches. Spreadsheet programs such as Microsoft Excel® (Microsoft, Washington, USA) are often used as a data storage, which has limitations in both organization and the quality of the data. Higher risk of incorrect data entry and introducing duplicates are associated with data input and analysis without a database system. Furthermore, selection, as well as calculation of data, is time-consuming. This article aims to provide interventionists with an efficient data collection tool optimized for interventional oncology clinical research. The implementation of the current database and interface allows a much faster and more detailed retrospective analysis of patient cohorts. The database management system with an interface is a very time-efficient and robust tool that provides a significant edge over the manual retrieval of patient records by filtering data and assisting statistical analysis in a study-relevant fashion.
Publication History
Article published online:
10 April 2021
© 2017. The Arab Journal of Interventional Radiology. This is an open access article published by Thieme under the terms of the Creative Commons Attribution-NonDerivative-NonCommercial-License, permitting copying and reproduction so long as the original work is given appropriate credit. Contents may not be used for commercial purposes, or adapted, remixed, transformed or built upon. https://creativecommons.org/licenses/by-nc-nd/4.0/.
Thieme Medical and Scientific Publishers Pvt. Ltd.
A-12, 2nd Floor, Sector 2, Noida-201301 UP, India
-
References
- 1 Lee H, Chapiro J, Schernthaner R, Duran R, Wang Z, Gorodetski B, et al. How I do it: A practical database management system to assist clinical research teams with data collection, organization, and reporting. Acad Radiol 2015;22:527-33.
- 2 Stobart S, Vassileiou M. MySQL Database and PHP My Admin Installation. PHP and MySQL Manual. London: Springer; 2004. p. 461-73.
- 3 Kuenz D. Manage Data for Free with MySQL. Book Manage Data for Free with MySQL. (City: Element K Journals); 2001. p. 7-10.
- 4 Coronel CM, Rob P. Database Systems: Design, Implementation, and Management. 9th ed. Boston, Massachusetts: Cengage Learning; 2009.
- 5 Llovet JM, Di Bisceglie AM, Bruix J, Kramer BS, Lencioni R, Zhu AX, et al. Design and endpoints of clinical trials in hepatocellular carcinoma. J Natl Cancer Inst 2008;100:698-711.
- 6 Kanas G, Morimoto L, Mowat F, O'Malley C, Fryzek J, Nordyke R. Use of electronic medical records in oncology outcomes research. Clinicoecon Outcomes Res 2010;2:1-14.
- 7 Xie SX, Baek Y, Grossman M, Arnold SE, Karlawish J, Siderowf A, et al. Building an integrated neurodegenerative disease database at an academic health center. Alzheimers Dement 2011;7:e84-93.
- 8 Parkes D, Lowman M, Andres C, et al. Pro Python System Administration. Automatic MySQL Database Performance Tuning. Apress; 2010. p. 329-48.
- 9 Piriyapongsa J, Bootchai C, Ngamphiw C, Tongsima S. MicroPIR: An integrated database of microRNA target sites within human promoter sequences. PLoS One 2012;7:e33888.