Design and Implementation of an Open Source Indexing Solution for a Large Set of Radiological Reports and Images

Abstract

This paper hopes to share the insights we experienced during designing, building, and running an indexing solution for a large set of radiological reports and images in a production environment for more than 3 years. Several technical challenges were encountered and solved in the course of this project. One hundred four million words in 1.8 million radiological reports from 1989 to the present were indexed and became instantaneously searchable in a user-friendly fashion; the median query duration is only 31 ms. Currently, our highly tuned index holds 332,088 unique words in four languages. The indexing system is feature-rich and language-independent and allows for making complex queries. For research and training purposes it certainly is a valuable and convenient addition to our radiology informatics toolbox. Extended use of open-source technology dramatically reduced both implementation time and cost. All software we developed related to the indexing project has been made available to the open-source community covered by an unrestricted Berkeley Software Distribution-style license.

Building Blocks for a Clinical Imaging Informatics Environment

“…Running a complicated report on the RIS database during clinical hours can cause unacceptable performance declines resulting in a delay of clinical work. Many approaches to data warehousing radiology reports have been published [14][15][16]. The report warehouse itself utilizes several of the reusable components as demonstrated in Fig.…”