Rubin Daniel L, Desser Terry S
Stanford Medical Informatics, Stanford, California 94305, USA.
J Am Coll Radiol. 2008 Mar;5(3):210-7. doi: 10.1016/j.jacr.2007.09.004.
Much of the information needed for radiology teaching and research is not in the picture archiving and communication system but distributed in hospital information systems throughout the medical enterprise. Our objective is to describe the design, methodology, and implementation of a data warehouse to integrate and make accessible the types of medical data pertinent to radiology research and teaching, and to encourage implementation of similar approaches throughout the radiologic community.
We identified desiderata of radiology data warehouses and designed and implemented a prototype system (RadBank) to meet these needs. RadBank was built with open-source software tools on a Linux platform with a relational database. We created a text report parsing module that recognizes the structure of radiology reports and makes individual sections available for indexing and search. A database schema was designed to link radiology and pathology reports and to enable users to retrieve cases using flexible queries.
Our system contains more than 2 million radiology and pathology reports, and allows full text search by patient history, findings, and diagnosis by radiology and pathology. RadBank has helped radiologists at our institution find teaching cases and identify research cohorts.
Data warehouses can provide radiologists access to important clinical information contained in radiology and pathology reports, and supplement the image information in picture archiving and communication system workstations. We believe that data warehouses similar to our system can be implemented in other radiology departments within a reasonable budget to make their vast radiologic-pathologic case material accessible for education and research.
放射学教学与研究所需的许多信息并非存于图像存档与通信系统中，而是分散在整个医疗企业的医院信息系统里。我们的目标是描述一个数据仓库的设计、方法及实施情况，该数据仓库用于整合并提供与放射学研究和教学相关的各类医学数据，同时鼓励放射学界采用类似方法。
我们确定了放射学数据仓库的需求，并设计和实施了一个原型系统（RadBank）来满足这些需求。RadBank是在Linux平台上使用开源软件工具和关系数据库构建的。我们创建了一个文本报告解析模块，该模块能够识别放射学报告的结构，并使各个部分可供索引和搜索。设计了一个数据库架构，用于链接放射学和病理学报告，并允许用户通过灵活的查询检索病例。
我们的系统包含超过200万份放射学和病理学报告，并允许通过患者病史、检查结果以及放射学和病理学诊断进行全文搜索。RadBank帮助我们机构的放射科医生找到教学病例并确定研究队列。
数据仓库可以为放射科医生提供访问放射学和病理学报告中重要临床信息的途径，并补充图像存档与通信系统工作站中的图像信息。我们相信，类似我们系统的数据仓库可以在其他放射科以合理的预算实施，以便能够获取大量的放射学 - 病理学病例资料用于教育和研究。
