skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: SU-E-T-255: Development of a Michigan Quality Assurance (MQA) Database for Clinical Machine Operations

Abstract

Purpose: A unified database system was developed to allow accumulation, review and analysis of quality assurance (QA) data for measurement, treatment, imaging and simulation equipment in our department. Recording these data in a database allows a unified and structured approach to review and analysis of data gathered using commercial database tools. Methods: A clinical database was developed to track records of quality assurance operations on linear accelerators, a computed tomography (CT) scanner, high dose rate (HDR) afterloader and imaging systems such as on-board imaging (OBI) and Calypso in our department. The database was developed using Microsoft Access database and visual basic for applications (VBA) programming interface. Separate modules were written for accumulation, review and analysis of daily, monthly and annual QA data. All modules were designed to use structured query language (SQL) as the basis of data accumulation and review. The SQL strings are dynamically re-written at run time. The database also features embedded documentation, storage of documents produced during QA activities and the ability to annotate all data within the database. Tests are defined in a set of tables that define test type, specific value, and schedule. Results: Daily, Monthly and Annual QA data has been taken in parallelmore » with established procedures to test MQA. The database has been used to aggregate data across machines to examine the consistency of machine parameters and operations within the clinic for several months. Conclusion: The MQA application has been developed as an interface to a commercially available SQL engine (JET 5.0) and a standard database back-end. The MQA system has been used for several months for routine data collection.. The system is robust, relatively simple to extend and can be migrated to a commercial SQL server.« less

Authors:
 [1]
  1. University of Michigan Hospital, Ann Arbor, MI (United States)
Publication Date:
OSTI Identifier:
22548313
Resource Type:
Journal Article
Journal Name:
Medical Physics
Additional Journal Information:
Journal Volume: 42; Journal Issue: 6; Other Information: (c) 2015 American Association of Physicists in Medicine; Country of input: International Atomic Energy Agency (IAEA); Journal ID: ISSN 0094-2405
Country of Publication:
United States
Language:
English
Subject:
60 APPLIED LIFE SCIENCES; 61 RADIATION PROTECTION AND DOSIMETRY; BIOMEDICAL RADIOGRAPHY; BUILDUP; COMPUTERIZED TOMOGRAPHY; DATA ANALYSIS; DOSE RATES; LINEAR ACCELERATORS; PARTICLE TRACKS; QUALITY ASSURANCE; RADIATION DOSES; REVIEWS

Citation Formats

Roberts, D. SU-E-T-255: Development of a Michigan Quality Assurance (MQA) Database for Clinical Machine Operations. United States: N. p., 2015. Web. doi:10.1118/1.4924617.
Roberts, D. SU-E-T-255: Development of a Michigan Quality Assurance (MQA) Database for Clinical Machine Operations. United States. https://doi.org/10.1118/1.4924617
Roberts, D. 2015. "SU-E-T-255: Development of a Michigan Quality Assurance (MQA) Database for Clinical Machine Operations". United States. https://doi.org/10.1118/1.4924617.
@article{osti_22548313,
title = {SU-E-T-255: Development of a Michigan Quality Assurance (MQA) Database for Clinical Machine Operations},
author = {Roberts, D},
abstractNote = {Purpose: A unified database system was developed to allow accumulation, review and analysis of quality assurance (QA) data for measurement, treatment, imaging and simulation equipment in our department. Recording these data in a database allows a unified and structured approach to review and analysis of data gathered using commercial database tools. Methods: A clinical database was developed to track records of quality assurance operations on linear accelerators, a computed tomography (CT) scanner, high dose rate (HDR) afterloader and imaging systems such as on-board imaging (OBI) and Calypso in our department. The database was developed using Microsoft Access database and visual basic for applications (VBA) programming interface. Separate modules were written for accumulation, review and analysis of daily, monthly and annual QA data. All modules were designed to use structured query language (SQL) as the basis of data accumulation and review. The SQL strings are dynamically re-written at run time. The database also features embedded documentation, storage of documents produced during QA activities and the ability to annotate all data within the database. Tests are defined in a set of tables that define test type, specific value, and schedule. Results: Daily, Monthly and Annual QA data has been taken in parallel with established procedures to test MQA. The database has been used to aggregate data across machines to examine the consistency of machine parameters and operations within the clinic for several months. Conclusion: The MQA application has been developed as an interface to a commercially available SQL engine (JET 5.0) and a standard database back-end. The MQA system has been used for several months for routine data collection.. The system is robust, relatively simple to extend and can be migrated to a commercial SQL server.},
doi = {10.1118/1.4924617},
url = {https://www.osti.gov/biblio/22548313}, journal = {Medical Physics},
issn = {0094-2405},
number = 6,
volume = 42,
place = {United States},
year = {Mon Jun 15 00:00:00 EDT 2015},
month = {Mon Jun 15 00:00:00 EDT 2015}
}