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

Development of an enterprise-wide clinical data repository: merging multiple legacy databases

K W Scully1, R D Pates, G S Desper

  • 1University of Virginia Health System, Charlottesville, USA.

Proceedings : a Conference of the American Medical Informatics Association. AMIA Fall Symposium
|January 1, 1997
PubMed
Summary

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

The effect of obesity on outcome of unrelated cord blood transplant in children with malignant diseases.

Bone marrow transplantation·2010
Same author

Departures from the protocol during conduct of a clinical trial: a pattern from the data record consistent with a learning curve.

Quality & safety in health care·2010
Same author

Unrelated umbilical cord blood transplantation in children with immune deficiency: results of a multicenter study.

Bone marrow transplantation·2009
Same author

Short- and long-term outcomes following atrial fibrillation in patients with acute coronary syndromes with or without ST-segment elevation.

Heart (British Cardiac Society)·2008
Same author

Physician experience caring for dying patients and its relationship to patient outcomes.

Journal of palliative medicine·2005
Same author

Penalized maximum likelihood estimation to directly adjust diagnostic and prognostic prediction models for overoptimism: a clinical example.

Journal of clinical epidemiology·2004

This study details a new clinical data repository at UVAHS, integrating diverse data for improved patient care surveillance and research. The system offers a low-cost, accessible tool for data sharing and analysis across departments.

Area of Science:

  • Health Informatics
  • Clinical Data Management
  • Database Systems

Background:

  • Legacy mainframe systems at the University of Virginia Health System (UVAHS) hindered comprehensive data access.
  • Integrating disparate data sources (administrative, billing, clinical) is crucial for effective healthcare management.

Purpose of the Study:

  • To develop a unified clinical data repository integrating multiple data sources.
  • To create a user-friendly interface for efficient data querying and analysis.
  • To support patient care surveillance, clinical research, and data sharing.

Main Methods:

  • Assembled four years of inpatient administrative and billing data from UVAHS legacy systems.
  • Linked cardiac surgery clinical database and physician billing data (inpatient/outpatient).

Related Experiment Videos

  • Utilized Sybase relational database management system on an IBM RS/6000, creating a 2.5 GB repository for ~100,000 admissions.
  • Developed a custom World Wide Web (WWW) user interface generating Structured Query Language (SQL) for data retrieval.

    • Main Results:

    • Successfully integrated diverse datasets into a centralized repository.
    • Demonstrated rapid reporting capabilities using coronary artery bypass graft (CABG) surgery patient data.
    • Established a foundation for a comprehensive clinical database.

    Conclusions:

    • The developed information system provides a convenient and low-cost method to enhance data availability at UVAHS.
    • The system empowers clinicians with a tool for monitoring patient care and outcomes.
    • It serves as a core for future clinical research and facilitates data sharing among departments.