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

Converting a legacy system database into relational format to enhance query efficiency

J C Prather1, D F Lobach, J W Hales

  • 1Duke University Medical Center, Durham, North Carolina, USA.

Proceedings. Symposium on Computer Applications in Medical Care
|January 1, 1995
PubMed
Summary
This summary is machine-generated.

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

Education.

Yearbook of medical informatics·2016
Same author

Hospital Information Systems: A Review in Perspective.

Yearbook of medical informatics·2016
Same author

Research Reproducibility in Longitudinal Multi-Center Studies Using Data from Electronic Health Records.

AMIA Joint Summits on Translational Science proceedings. AMIA Joint Summits on Translational Science·2016
Same author

Discussion of "Biomedical informatics: we are what we publish".

Methods of information in medicine·2013
Same author

Factors influencing uptake of pharmacogenetic testing in a diverse patient population.

Public health genomics·2009
Same author

Standards for the electronic health record, emerging from health care's Tower of Babel.

Proceedings. AMIA Symposium·2002

Converting legacy clinical data systems to relational databases improves data accessibility and query performance. This study evaluates the impact and identifies key considerations for successful legacy system data migration.

Area of Science:

  • Health Informatics
  • Database Management
  • Clinical Data Analysis

Background:

  • Electronic clinical data holds significant value for healthcare process insights.
  • Legacy systems hinder accessibility and data sharing of electronic clinical information.
  • Improved methods are crucial for accessing data stored in legacy databases.

Purpose of the Study:

  • To convert a legacy database into a relational format for enhanced data accessibility.
  • To evaluate the impact of this conversion on query performance.
  • To identify critical considerations for legacy system database conversion.

Main Methods:

  • Database conversion from legacy format to a relational model.
  • Implementation within a personal computer environment.

Related Experiment Videos

  • Performance evaluation of data queries post-conversion.

    • Main Results:

    • Demonstrated improved data accessibility through relational conversion.
    • Evaluated the performance impact on query execution.
    • Identified practical issues and considerations for legacy system migration.

    Conclusions:

    • Relational conversion enhances clinical data accessibility from legacy systems.
    • Query performance is a key factor to consider during migration.
    • Successful conversion requires careful planning and consideration of identified issues.