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
Summary
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.
- 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.