ACCESSING THE COLUMBIA CLINICAL REPOSITORY

Authors
JOHNSON SB HRIPCSAK G CHEN J CLAYTON P
Citation
Sb. Johnson et al., ACCESSING THE COLUMBIA CLINICAL REPOSITORY, Journal of the American Medical Informatics Association, 1994, pp. 281-285
Citations number
12
Categorie Soggetti
Information Science & Library Science","Medicine Miscellaneus","Computer Science Information Systems
Journal title
Journal of the American Medical Informatics Association → ACNP
ISSN journal
10675027
Year of publication
1994
Supplement
S
Pages
281 - 285
Database
ISI
SICI code
1067-5027(1994):<281:ATCCR>2.0.ZU;2-A
Abstract
The Columbia Clinical Repository is the foundation of the Clinical Inf ormation System at the Columbia Presbyterian Medical Center (CPMC). Th e Repository is implemented as a relational database on an IBM mainfra me, using a generic design that employs a small number of tables. Clie nt applications on remote platforms send and receive data through Data base Access Modules (DAMs), which support the HL7 protocol, while appl ications on the mainframe manipulate data through DAMs supporting a lo cally defined ''query template''. Implementation using static (compile d) SQL is compared to dynamic (ad hoc) SQL in terms of efficiency and flexibility.