title: A practical approach for inexpensive searches of radiology report databases.
abstract: 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.
authors.affiliation: Department of Radiology, University of Michigan, Ann Arbor, MI 48109-0326, USA. benoitd@umich.edu
authors.forename: Benoit
authors.initials: B
authors.lastname: Desjardins
authors.forename: R Curtis
authors.initials: RC
authors.lastname: Hamilton
mesh_terms: 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