- Poster presentation
- Open Access
Improving the efficiency of testing database functionality through statistical involvement
Trials volume 16, Article number: P30 (2015)
As a registered clinical trials unit we develop customised databases to collect and store study data and manage clinical trials; these databases need rigorous testing to ensure they function as intended, that data validation is implemented correctly and that study data extracts are complete and accurate. We describe how, with statistical involvement, the testing has been streamlined and the timelines reduced.
The database specification, produced at the start of the database development process, details how data should be stored in the study database. Statistical programs have been written to create datasets from this specification document that are then used to test the database extracts. These datasets created are imported directly into the study databases by the IT team, thereby eliminating the need for test data to be entered manually. Once uploaded, extracts are produced and compared statistically with the original datasets. This process allows any issues, including incorrect mapping of labels to numeric values and extracting of variables under incorrect names, to be quickly identified and resolved.
The process for testing has evolved from a time-consuming data entry based approach to one that can be fully automated and completed in a shorter timeframe. Involvement of the statistics team has helped maximise efficiency through the use of existing specification documents for this process and ensures consistency in testing across different study databases.
This research is supported by a National Institute for Health Research (NIHR) Bristol Cardiovascular Biomedical Research Unit. The views and opinions expressed therein are those of the authors and do not necessarily reflect those of the NIHR, NHS or the Department of Health.
About this article
Cite this article
Clayton, G., Pike, K., Nash, R. et al. Improving the efficiency of testing database functionality through statistical involvement. Trials 16, P30 (2015). https://doi.org/10.1186/1745-6215-16-S2-P30
- Study Data
- Rigorous Testing
- Original Dataset
- Registered Clinical Trial
- Study Database