Skip to main content
Proceedings of the Annual Symposium on Computer Application in Medical Care logoLink to Proceedings of the Annual Symposium on Computer Application in Medical Care
. 1994:281–285.

Accessing the Columbia Clinical Repository.

S B Johnson 1, G Hripcsak 1, J Chen 1, P Clayton 1
PMCID: PMC2247734  PMID: 7949935

Abstract

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.

Full text

PDF

Selected References

These references are in PubMed. This may not be the complete list of references from this article.

  1. McDonald C. J., Blevins L., Tierney W. M., Martin D. K. The Regenstrief medical records. MD Comput. 1988 Sep-Oct;5(5):34–47. [PubMed] [Google Scholar]
  2. Pryor T. A. The HELP medical record system. MD Comput. 1988 Sep-Oct;5(5):22–33. [PubMed] [Google Scholar]
  3. Stead W. W., Hammond W. E. Computer-based medical records: the centerpiece of TMR. MD Comput. 1988 Sep-Oct;5(5):48–62. [PubMed] [Google Scholar]

Articles from Proceedings of the Annual Symposium on Computer Application in Medical Care are provided here courtesy of American Medical Informatics Association

RESOURCES