A practical approach for inexpensive searches of radiology report databases
- PMID: 17502263
- DOI: 10.1016/j.acra.2007.02.008
A practical approach for inexpensive searches of radiology report databases
Abstract
Rationale and objectives: 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.
Materials and 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.
Similar articles
-
[Quality improvement of resources in radiology on the internet].Rofo. 2005 Apr;177(4):569-75. doi: 10.1055/s-2005-857904. Rofo. 2005. PMID: 15838764 German.
-
Integrating your radiology information system in a complex computing environment.Radiol Manage. 2000 Jul-Aug;22(4):22-4, 26, 28. Radiol Manage. 2000. PMID: 11186495
-
A data warehouse for integrating radiologic and pathologic data.J Am Coll Radiol. 2008 Mar;5(3):210-7. doi: 10.1016/j.jacr.2007.09.004. J Am Coll Radiol. 2008. PMID: 18312970
-
Information systems in the management of the radiology department.Rays. 2003 Jan-Mar;28(1):63-72. Rays. 2003. PMID: 14509180 Review.
-
Ergonomics in radiology.Clin Radiol. 2009 Feb;64(2):119-26. doi: 10.1016/j.crad.2008.08.003. Epub 2008 Oct 2. Clin Radiol. 2009. PMID: 19103340 Review.
Cited by
-
Evaluation of negation and uncertainty detection and its impact on precision and recall in search.J Digit Imaging. 2011 Apr;24(2):234-42. doi: 10.1007/s10278-009-9250-4. Epub 2009 Nov 10. J Digit Imaging. 2011. PMID: 19902298 Free PMC article.
MeSH terms
LinkOut - more resources
Full Text Sources