Searching Full-Text Anatomic Pathology Reports Using Business Intelligence Software.
Searching Full-Text Anatomic Pathology Reports Using Business Intelligence Software.
复制标题
DOI：
10.1016/j.jpi.2022.100014
复制
发表时间：
2022
影响因子：
--
通讯作者：
Araj E
中科院分区：
文献类型：
--
作者：
Arvisais-Anhalt S;Lehmann CU;Bishop JA;Balani J;Boutte L;Morales M;Park JY;Araj E
尽管实验室信息系统已经在很大程度上解决了存储解剖病理学报告并在整个医疗保健系统中传播其内容的问题，但是解剖病理学报告的回顾性查询仍然是实验室信息系统供应商需要改进的领域。我们的机构希望能够查询我们的解剖病理学报告库，用于临床，操作，研究和教育目的。为了满足这一需求，我们使用商业智能软件Tableau开发了一个全文解剖病理学搜索工具。我们的搜索工具允许用户使用商业智能工具的内置正则表达式功能从我们的机构临床关系数据库中查询333，685份解剖病理学报告。用户可以使用任何网络浏览器安全地访问搜索工具，从而避免在用户计算机上安装或维护软件的成本。该工具与实验室信息系统供应商无关，由于许多机构已经订购了商业智能软件，我们相信该解决方案可以在其他机构和其他临床部门轻松复制。
Although the laboratory information system has largely solved the problem of storing anatomic pathology reports and disseminating their contents across the healthcare system, the retrospective query of anatomic pathology reports remains an area for improvement across laboratory information system vendors. Our institution desired the ability to query our repository of anatomic pathology reports for clinical, operational, research, and educational purposes. To address this need, we developed a full-text anatomic pathology search tool using the business intelligence software, Tableau. Our search tool allows users to query the 333,685 anatomic pathology reports from our institutional clinical relational database using the business intelligence tool’s built-in regular expression functionality. Users securely access the search tool using any web browser, thereby avoiding the cost of installing or maintaining software on users’ computers. This tool is laboratory information system vendor agnostic and as many institutions already subscribe to business intelligence software, we believe this solution could be easily reproduced at other institutions and in other clinical departments.