A practical approach for inexpensive searches of radiology report databases.
OBJECTIVE
We present a method to perform full text searches of radiology reports for the large number of departments that do not have this ability as part of their radiology or hospital information system.


METHODS
A tool written in Microsoft Access (front-end) has been designed to search a server (back-end) containing the indexed backup weekly copy of the full relational database extracted from a radiology information system (RIS). This front end-/back-end approach has been implemented in a large academic radiology department, and is used for teaching, research and administrative purposes.


RESULTS
The weekly second backup of the 80 GB, 4 million record RIS database takes 2 hours. Further indexing of the exported radiology reports takes 6 hours. Individual searches of the indexed database typically take less than 1 minute on the indexed database and 30-60 minutes on the nonindexed database. Guidelines to properly address privacy and institutional review board issues are closely followed by all users.


CONCLUSIONS
This method has potential to improve teaching, research, and administrative programs within radiology departments that cannot afford more expensive technology.
Desjardins
Benoit
B
Department of Radiology, University of Michigan, Ann Arbor, MI 48109-0326, USA. benoitd@umich.edu
Hamilton
R Curtis
RC
D000043:Abstracting and Indexing; D000046:Academic Medical Centers; D003199:Computer Systems / Q000191:economics; D016208:Databases, Factual; D006801:Humans; D016247:Information Storage and Retrieval / Q000379:methods*; D008499:Medical Records / Q000145:classification; D011872:Radiology Department, Hospital / Q000458:organization & administration*; D011873:Radiology Information Systems; D012985:Software Design; D014584:User-Computer Interface