Advertisement

How I Do It

A Practical Database Management System to Assist Clinical Research Teams with Data Collection, Organization, and Reporting
  • Howard Lee
    Affiliations
    Russell H. Morgan Department of Radiology and Radiological Science, Division of Vascular and Interventional Radiology, The Johns Hopkins Hospital, Sheikh Zayed Tower, Ste 7203, 1800 Orleans St, Baltimore, MD 21287
    Search for articles by this author
  • Julius Chapiro
    Affiliations
    Russell H. Morgan Department of Radiology and Radiological Science, Division of Vascular and Interventional Radiology, The Johns Hopkins Hospital, Sheikh Zayed Tower, Ste 7203, 1800 Orleans St, Baltimore, MD 21287
    Search for articles by this author
  • Rüdiger Schernthaner
    Affiliations
    Russell H. Morgan Department of Radiology and Radiological Science, Division of Vascular and Interventional Radiology, The Johns Hopkins Hospital, Sheikh Zayed Tower, Ste 7203, 1800 Orleans St, Baltimore, MD 21287
    Search for articles by this author
  • Rafael Duran
    Affiliations
    Russell H. Morgan Department of Radiology and Radiological Science, Division of Vascular and Interventional Radiology, The Johns Hopkins Hospital, Sheikh Zayed Tower, Ste 7203, 1800 Orleans St, Baltimore, MD 21287
    Search for articles by this author
  • Zhijun Wang
    Affiliations
    Russell H. Morgan Department of Radiology and Radiological Science, Division of Vascular and Interventional Radiology, The Johns Hopkins Hospital, Sheikh Zayed Tower, Ste 7203, 1800 Orleans St, Baltimore, MD 21287
    Search for articles by this author
  • Boris Gorodetski
    Affiliations
    Russell H. Morgan Department of Radiology and Radiological Science, Division of Vascular and Interventional Radiology, The Johns Hopkins Hospital, Sheikh Zayed Tower, Ste 7203, 1800 Orleans St, Baltimore, MD 21287
    Search for articles by this author
  • Jean-François Geschwind
    Correspondence
    Address correspondence to: J.F.G.
    Affiliations
    Russell H. Morgan Department of Radiology and Radiological Science, Division of Vascular and Interventional Radiology, The Johns Hopkins Hospital, Sheikh Zayed Tower, Ste 7203, 1800 Orleans St, Baltimore, MD 21287
    Search for articles by this author
  • MingDe Lin
    Affiliations
    U/S Imaging and Interventions (UII), Philips Research North America, Briarcliff Manor, NY
    Search for articles by this author
Published:January 29, 2015DOI:https://doi.org/10.1016/j.acra.2014.12.002

      Rationale and Objectives

      The objective of this study was to demonstrate that an intra-arterial liver therapy clinical research database system is a more workflow efficient and robust tool for clinical research than a spreadsheet storage system. The database system could be used to generate clinical research study populations easily with custom search and retrieval criteria.

      Materials and Methods

      A questionnaire was designed and distributed to 21 board-certified radiologists to assess current data storage problems and clinician reception to a database management system. Based on the questionnaire findings, a customized database and user interface system were created to perform automatic calculations of clinical scores including staging systems such as the Child-Pugh and Barcelona Clinic Liver Cancer, and facilitates data input and output.

      Results

      Questionnaire participants were favorable to a database system. The interface retrieved study-relevant data accurately and effectively. The database effectively produced easy-to-read study-specific patient populations with custom-defined inclusion/exclusion criteria.

      Conclusions

      The database management system is workflow efficient and robust in retrieving, storing, and analyzing data.

      Key Words

      To read this article in full you will need to make a payment

      Purchase one-time access:

      Academic & Personal: 24 hour online accessCorporate R&D Professionals: 24 hour online access
      One-time access price info
      • For academic or personal research use, select 'Academic and Personal'
      • For corporate R&D use, select 'Corporate R&D Professionals'

      Subscribe:

      Subscribe to Academic Radiology
      Already a print subscriber? Claim online access
      Already an online subscriber? Sign in
      Institutional Access: Sign in to ScienceDirect

      References

        • Meineke F.A.
        • Staubert S.
        • Lobe M.
        • et al.
        A comprehensive clinical research database based on CDISC ODM and i2b2.
        Stud Health Technol Inform. 2014; 205: 1115-1119
        • Stobart S.
        • Vassileiou M.
        MySQL database and PHPMyAdmin installation. PHP and MySQL manual.
        Springer, London2004: 461-473
        • Kuenz D.
        Manage data for free with MySQL. Book manage data for free with MySQL.
        (City: Element K Journals)2001: 7-10
        • Coronel C.M.S.
        • Rob P.
        Database systems: design, implementation, and management.
        9 ed. Cengage Learning, Boston, Massachusetts2009
        • Llovet J.M.
        • Di Bisceglie A.M.
        • Bruix J.
        • et al.
        Design and endpoints of clinical trials in hepatocellular carcinoma.
        J Natl Cancer Inst. 2008; 100: 698-711
        • Kanas G.
        • Morimoto L.
        • Mowat F.
        • et al.
        Use of electronic medical records in oncology outcomes research.
        Clinicoecono Outcomes Res. 2010; 2: 1-14
        • Schmier J.K.
        • Kane D.W.
        • Halpern M.T.
        Practical applications of usability theory to electronic data collection for clinical trials.
        Contemp Clin Trials. 2005; 26: 376-385
        • Harris P.A.
        • Taylor R.
        • Thielke R.
        • Payne J.
        • Gonzalez N.
        • Conde J.G.
        Research electronic data capture (REDCap)—A metadata-driven methodology and workflow process for providing translational research informatics support.
        J Biomed Inform. 2009; 42: 377-381
      1. MySQL database provides full transactional support.
        Worldwide Databases. 2002; 14 (0-N/A)
      2. Oracle Improves Database Performance with Latest Development Milestone Release for MySQL 5.7; New Release of the World's Most Popular Open Source Database is 2x Faster than MySQL 5.6 and Over 3x Faster than MySQL 5.5 in Benchmark Tests. Book Oracle Improves Database Performance with Latest Development Milestone Release for MySQL 5.7; New Release of the World's Most Popular Open Source Database is 2x Faster than MySQL 5.6 and Over 3x Faster than MySQL 5.5 in Benchmark Tests. City 2014.

        • Xie S.X.
        • Baek Y.
        • Grossman M.
        • et al.
        Building an integrated neurodegenerative disease database at an academic health center.
        Alzheimers Dement. 2011; 7: e84-93
      3. Automatic MySQL database performance tuning.
        in: Parkes D. Lowman M. Andres C. Pro python system administration. Apress, 2010: 329-348
        • Piriyapongsa J.
        • Bootchai C.
        • Ngamphiw C.
        • et al.
        microPIR: an integrated database of microRNA target sites within human promoter sequences.
        PloS One. 2012; 7: e33888