The integration of routine clinical administrative activities into ongoing rigorous clinical research poses challenges for both clinicians and researchers. This case study describes the development of a responsive database system used to facilitate comprehensive longitudinal research into the outcomes of patients waiting for hip and knee replacement surgery in a large public teaching hospital. The initial research procedure was paper-based, with manual patient matching and data entry. This process was time-consuming and associated with substantial risk of error and omissions, necessitating the design of a better system. An integrated database system was designed to receive daily electronic updates of the orthopaedic waiting-list and scheduled clinic and surgery dates. Using readily available software (Microsoft Access), new patients were identified through specifying inclusion and exclusion criteria which allowed rapid and complete recruitment at time of entry to the waiting-list. The integrated system specified the appropriate timing of multiple follow-up assessments, provided prompt information on recruitment for reporting purposes and integrated multiple linked research projects within one database. Seamless exporting of data to statistical programs for analysis was also enabled. This simple integrated approach facilitated efficient execution of a longitudinal study from recruitment to statistical analysis while maximising confidentiality and minimising resources required. This case study describes the development and design of a simple system which could be easily adapted for database management in hospital or clinic-based settings according to local requirements.
Every reasonable effort has been made to ensure that permission has been obtained for items included in Deakin Research Online. If you believe that your rights have been infringed by this repository, please contact firstname.lastname@example.org
Field of Research
080702 Health Informatics
Socio Economic Objective
970108 Expanding Knowledge in the Information and Computing Sciences
Unless expressly stated otherwise, the copyright for items in DRO is owned by the author, with all rights reserved.
Every reasonable effort has been made to ensure that permission has been obtained for items included in DRO.
If you believe that your rights have been infringed by this repository, please contact email@example.com.