title: Accessing the Columbia Clinical Repository.
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.
authors.affiliation: Center for Medical Informatics, Columbia Presbyterian Medical Center, New York, NY 10032.
authors.forename: S B
authors.initials: SB
authors.lastname: Johnson
authors.forename: G
authors.initials: G
authors.lastname: Hripcsak
authors.forename: J
authors.initials: J
authors.lastname: Chen
authors.forename: P
authors.initials: P
authors.lastname: Clayton
mesh_terms: D002984:Clinical Laboratory Information Systems / Q000592:standards*; D003204:Computers, Mainframe; D016208:Databases, Factual; D006751:Hospital Information Systems / Q000592:standards*; D006786:Hospitals, Urban; D006801:Humans; D016347:Medical Records Systems, Computerized / Q000592:standards*; D009519:New York City; D011381:Programming Languages; D012984:Software / Q000592:standards*