Johnson S B, Hripcsak G, Chen J, Clayton P
Center for Medical Informatics, Columbia Presbyterian Medical Center, New York, NY 10032.
Proc Annu Symp Comput Appl Med Care. 1994:281-5.
The Columbia Clinical Repository is the foundation of the Clinical Information System at the Columbia Presbyterian Medical Center (CPMC). The Repository is implemented as a relational database on an IBM mainframe, using a generic design that employs a small number of tables. Client applications on remote platforms send and receive data through Database Access Modules (DAMs), which support the HL7 protocol, while applications on the mainframe manipulate data through DAMs supporting a locally defined "query template". Implementation using static (compiled) SQL is compared to dynamic (ad hoc) SQL in terms of efficiency and flexibility.
哥伦比亚临床知识库是哥伦比亚长老会医学中心(CPMC)临床信息系统的基础。该知识库在IBM大型机上作为关系数据库实现,采用通用设计,使用少量表格。远程平台上的客户端应用程序通过支持HL7协议的数据库访问模块(DAM)发送和接收数据,而大型机上的应用程序则通过支持本地定义的“查询模板”的DAM来操作数据。在效率和灵活性方面,将使用静态(编译)SQL的实现与动态(即席)SQL进行了比较。