Stitt F W
Department of Epidemiology, University of Miami School of Medicine, FL 33101, USA.
Medinfo. 1995;8 Pt 1:402.
To create a clinical data repository to interface the Veteran's Administration (VA) Decentralized Hospital Computer Program (DHCP) and a departmental clinical information system for the management of HIV patients. This system supports record-keeping, decision-making, reporting, and analysis. The database development was designed to overcome two impediments to successful implementations of clinical databases: (i) lack of a standard reference data model, and; (ii) lack of a universal standard for medical concept representation.
Health Level Seven (HL7) is a standard protocol that specifies the implementation of interfaces between two computer applications (sender and receiver) from different vendors or sources of electronic data exchange in the health care environment. This eliminates or substantially reduces the custom interface programming and program maintenance that would otherwise be required. HL7 defines the data to be exchanged, the timing of the interchange, and the communication of errors to the application. The formats are generic in nature and must be configured to meet the needs of the two applications involved. The standard conceptually operates at the seventh level of the ISO model for Open Systems Interconnection (OSI). The OSI simply defines the data elements that are exchanged as abstract messages, and does not prescribe the exact bit stream of the messages that flow over the network. Lower level network software developed according to the OSI model may be used to encode and decode the actual bit stream. The OSI protocols are not universally implemented and, therefore, a set of encoding rules for defining the exact representation of a message must be specified. The VA has created an HL7 module to assist DHCP applications in exchanging health care information with other applications using the HL7 protocol. The DHCP HL7 module consists of a set of utility routines and files that provide a generic interface to the HL7 protocol for all DHCP applications.
The VA's DHCP core modules are in standard use at 169 hospitals, and the role of the VA system in health care delivery has been discussed elsewhere. This development was performed at the Miami VA Medical Center Special Immunology Unit, where a database was created for an HIV patient registry in 1987. Over 2,300 patient have been entered into a database that supports a problem-oriented summary of the patient's clinical record. The interface to the VA DHCP was designed and implemented to capture information from the patient treatment file, pharmacy, laboratory, radiology, and other modules.
We obtained a suite of programs for implementing the HL7 encoding rules from Columbia-Presbyterian Medical Center in New York, written in ANSI C. This toolkit isolates our application programs from the details of the HL7 encoding rules, and allows them to deal with abstract messages and the programming level. While HL7 has become a standard for healthcare message exchange, SQL (Structured Query Language) is the standard for database definition, data manipulation, and query. The target database (Stitt F.W. The Problem-Oriented Medical Synopsis: a patient-centered clinical information system. Proc 17 SCAMC. 1993:88-93) provides clinical workstation functionality. Medical concepts are encoded using a preferred terminology derived from over 15 sources that include the Unified Medical Language System and SNOMed International ( Stitt F.W. The Problem-Oriented Medical Synopsis: coding, indexing, and classification sub-model. Proc 18 SCAMC, 1994: in press). The databases were modeled using the Information Engineering CASE tools, and were written using relational database utilities, including embedded SQL in C (ESQL/C). We linked ESQL/C programs to the HL7 toolkit to allow data to be inserted, deleted, or updated, under transaction control. A graphical format will be used to display the entity-rel
创建一个临床数据存储库,将退伍军人事务部(VA)的分散医院计算机程序(DHCP)与部门临床信息系统相连接,用于管理艾滋病患者。该系统支持记录保存、决策制定、报告和分析。数据库开发旨在克服临床数据库成功实施的两个障碍:(i)缺乏标准参考数据模型,以及(ii)缺乏医学概念表示的通用标准。
健康级别7(HL7)是一种标准协议,规定了医疗环境中不同供应商或电子数据交换源的两个计算机应用程序(发送方和接收方)之间接口的实现。这消除或大幅减少了原本所需的定制接口编程和程序维护。HL7定义了要交换的数据、交换的时间以及向应用程序报告错误的方式。这些格式本质上是通用的,必须进行配置以满足所涉及的两个应用程序的需求。该标准在概念上运行于开放系统互连(OSI)的ISO模型的第七层。OSI只是将交换的数据元素定义为抽象消息,并未规定在网络上流动的消息的确切比特流。根据OSI模型开发的较低层网络软件可用于对实际比特流进行编码和解码。OSI协议并未普遍实施,因此,必须指定一组用于定义消息确切表示的编码规则。VA创建了一个HL7模块,以协助DHCP应用程序使用HL7协议与其他应用程序交换医疗保健信息。DHCP HL7模块由一组实用程序和文件组成,为所有DHCP应用程序提供了与HL7协议的通用接口。
VA的DHCP核心模块在169家医院中标准使用,VA系统在医疗保健提供中的作用已在其他地方进行了讨论。此开发工作在迈阿密VA医疗中心特殊免疫学部门进行,该部门于1987年为艾滋病患者登记创建了一个数据库。超过2300名患者已录入一个支持以问题为导向的患者临床记录摘要的数据库。VA DHCP的接口经过设计和实施,以从患者治疗文件、药房、实验室、放射科和其他模块获取信息。
我们从纽约的哥伦比亚长老会医学中心获得了一套用于实施HL7编码规则的程序,用ANSI C编写。这个工具包使我们的应用程序与HL7编码规则的细节隔离开来,并允许它们处理抽象消息和编程层面的问题。虽然HL7已成为医疗保健消息交换的标准,但SQL(结构化查询语言)是数据库定义、数据操作和查询的标准。目标数据库(斯蒂特F.W. 以问题为导向的医学概要:一个以患者为中心的临床信息系统。第17届SCAMC会议论文集。1993年:88 - 93页)提供临床工作站功能。医学概念使用从包括统一医学语言系统和国际医学系统命名法(SNOMed International)在内的15多个来源派生的首选术语进行编码(斯蒂特F.W. 以问题为导向的医学概要:编码、索引和分类子模型。第18届SCAMC会议论文集,1994年:即将出版)。数据库使用信息工程CASE工具进行建模,并使用关系数据库实用程序编写,包括C语言中的嵌入式SQL(ESQL/C)。我们将ESQL/C程序与HL7工具包链接,以便在事务控制下插入、删除或更新数据。将使用图形格式显示实体关系。