Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

Accessing the Columbia Clinical Repository

S B Johnson1, G Hripcsak, J Chen

  • 1Center for Medical Informatics, Columbia Presbyterian Medical Center, New York, NY 10032.

Proceedings. Symposium on Computer Applications in Medical Care
|January 1, 1994
PubMed
Summary

The Columbia Clinical Repository uses a generic relational database design for its Clinical Information System. This study compares static and dynamic SQL for data access efficiency and flexibility.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

MAO inhibitory activity of bromo-2-phenylbenzofurans: synthesis, <i>in vitro</i> study, and docking calculations.

MedChemComm·2018
Same author

Estimating summary statistics for electronic health record laboratory data for use in high-throughput phenotyping algorithms.

Journal of biomedical informatics·2018
Same author

Decision Support, Knowledge Representation and Management.

Yearbook of medical informatics·2016
Same author

Health and Clinical Management.

Yearbook of medical informatics·2016
Same author

Systems pharmacology augments drug safety surveillance.

Clinical pharmacology and therapeutics·2015
Same author

Similarity-based modeling applied to signal detection in pharmacovigilance.

CPT: pharmacometrics & systems pharmacology·2014

Area of Science:

  • Health Informatics
  • Database Management Systems
  • Clinical Information Systems

Background:

  • The Columbia Clinical Repository (CCR) serves as the core of the Clinical Information System at Columbia Presbyterian Medical Center (CPMC).
  • The CCR is built upon a relational database architecture hosted on an IBM mainframe, featuring a generalized design with a limited set of tables.

Purpose of the Study:

  • To evaluate the performance differences between static (compiled) SQL and dynamic (ad hoc) SQL within the CCR environment.
  • To assess the trade-offs in efficiency and flexibility offered by each SQL implementation method for clinical data management.

Main Methods:

  • Implementation of the CCR using a relational database on an IBM mainframe.
  • Utilizing Database Access Modules (DAMs) to facilitate data exchange between client applications and the mainframe.

Related Experiment Videos

  • Supporting HL7 protocol for remote data transfer and a local "query template" for mainframe applications.
  • Comparative analysis of static SQL versus dynamic SQL for data manipulation and retrieval.

    • Main Results:

    • Static SQL offers greater efficiency for predefined queries due to pre-compilation.
    • Dynamic SQL provides enhanced flexibility for ad hoc data retrieval and complex query structures.
    • The choice between static and dynamic SQL impacts system performance and adaptability.

    Conclusions:

    • The selection of SQL implementation (static vs. dynamic) in the CCR depends on the specific requirements for data access, balancing efficiency needs with flexibility demands.
    • Optimizing the Clinical Information System involves careful consideration of SQL strategy for robust clinical data management.