基于后结构化电子病历的胰腺癌科研数据平台设计

Design of pancreatic cancer research data platform based on post-structured electronic medical records

目的:设计一种基于后结构化电子病历的胰腺癌科研数据平台,为胰腺癌科研项目提供数据支持。方法:该平台基于SQL Server 2015数据库,采用浏览器/服务器(Browser/Server,B/S)架构进行设计。采用SQL Server Integration Services 2015工具抽取结构化后的电子病历数据和临床信息系统产生的异构数据;采用SQL Server Reporting Services 2015工具开发浏览器界面,实现数据查询和可视化。整个平台包括数据抽取、数据处理和查询分析3个功能模块。结果:该平台可将散落在各个系统中的非结构化数据和半结构化数据集成到一起,为胰腺癌科研项目提供真实可靠的数据,并能对数据进行管理、统计、筛选和生成各类图表。结论:该平台能基本满足胰腺癌科研工作的需求,为构建类似需求的其他病历研究平台提供了借鉴。

Objective To design a post-structured electronic medical record-based pancreatic cancer research data platform to provide data support for pancreatic cancer research projects.Methods A pancreatic cancer data platform was developed with SQL Server 2015 database and B/S architecture.SQL Server Integration Services 2015 tool was used to extract the structured electronic medical record data and the heterogeneous data generated by the clinical information system;a browser interface was established with SQL Server Reporting Services 2015 tool to realize data query and visualization.The whole platform was composed of three functional modules for data extraction,data processing and query analysis.Results The platform integrated unstructured data and semi-structured data scattered in various systems to provide real and reliable data for pancreatic cancer research projects,which could manage,count,filter and generate various charts for the data.Conclusion The platform developed can approximately meet the needs of pancreatic cancer researches,and references are provided for building other medical record research platforms with similar needs.