Prog Med Phys.  2020 Dec;31(4):172-178. 10.14316/pmp.2020.31.4.172.

Structure of an Oncology Information System Based on a Cost-Effective Relational Database for Small Departments of Radiation Oncology

• Jeon H
• Kim DW
• Joo JH
• Ki Y
• Kim W
• Park D
• Nam J
• Kim DH

• KMID: 2510478
• DOI: http://doi.org/10.14316/pmp.2020.31.4.172

Abstract

Purpose
Radiation oncology information systems (ROIS) have evolved toward connecting and integrating information between radiation treatment procedures. ROIS can play an important role in utilizing modern radiotherapy techniques that have high complexity and require a large amount of information.
Methods
Using Access^TM software, we have developed a relational database that is highly optimized for a radiotherapeutic workflow.
Results
The prescription table was chosen as the core table to which the other tables were connected, and three types of forms-charts, worklists, and calendars- were suggested. A fast and reliable channel for delivering orders and remarks according to changes in the situation was also designed.
Conclusions
We expect our ROIS design to inspire those who need to develop and manage an individual ROIS suitable for their radiation oncology departments at a low cost.

Keyword

Radiation oncology information system; Relational database; Microsoft access

Figure

• 

  Fig. 1 Overall workflow for radiation treatments. CT, computed tomography.

• 

  Fig. 2 Overall connections between the relational tables for radiation oncology information systems (ROIS).

• 

  Fig. 3 Three kinds of forms for reviewing and editing radiation oncology information systems (ROIS) data.

• 

  Fig. 4 (a) The main chart of a single patient, (b) the corresponding setup-photo viewer, and (c) the schedule chart for reception staff.

• 

  Fig. 5 Two worklist forms for (a) radiation treatment planning rooms and (b) treatment rooms as examples.

• 

  Fig. 6 Calendar-style forms for managing schedules of (a) exams and (b) computed tomography (CT) simulations.

Reference

References

1. Rosenbloom ME, Killick LJ, Bentley RE. 1977; Verification and recording of radiotherapy treatments using a small computer. Br J Radiol. 50:637–644. DOI: 10.1259/0007-1285-50-597-637. PMID: 901975.

2. Fredrickson DH, Karzmark CJ, Rust DC, Tuschman M. 1979; Experience with computer monitoring, verification and record keeping in radiotherapy procedures using a Clinac-4. Int J Radiat Oncol Biol Phys. 5:415–418. DOI: 10.1016/0360-3016(79)91225-2. PMID: 110748.

3. Morrey D, Smith CW, Belcher RA, Harding T, Sutherland WH. 1982; A microcomputer system for prescription, calculation, verification and recording of radiotherapy treatments. Br J Radiol. 55:283–288. DOI: 10.1259/0007-1285-55-652-283. PMID: 7066639.

4. Fong de Los Santos LE, Herman MG. 2012; Radiation oncology information systems and clinical practice compatibility: workflow evaluation and comprehensive assessment. Pract Radiat Oncol. 2:e155–e164. DOI: 10.1016/j.prro.2012.02.002. PMID: 24674179.

5. Han Y, Huh SJ, Ju SG, Ahn YC, Lim DH, Lee JE, et al. 2005; Impact of an electronic chart on the staff workload in a radiation oncology department. Jpn J Clin Oncol. 35:470–474. DOI: 10.1093/jjco/hyi129. PMID: 16024532.

6. Codd EF. 1970; A relational model of data for large shared data banks. Commun ACM. 13:377–387. PMID: 9617087.

7. Lim S, Kim K, Ahn S, Lee SH, Lee R, Cho S. 2018; Database for patient information management in radiation oncology department. Prog Med Phys. 29:23–28.