Skip to main content
Proceedings of the Annual Symposium on Computer Application in Medical Care logoLink to Proceedings of the Annual Symposium on Computer Application in Medical Care
. 1995:372–376.

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

J C Prather 1, D F Lobach 1, J W Hales 1, M L Hage 1, S J Fehrs 1, W E Hammond 1
PMCID: PMC2579117  PMID: 8563305

Abstract

The analysis of clinical data collected over time can provide important insight into the health care process. Unfortunately, much of the electronic clinical data that exists today is stored in legacy systems, making it difficult to access and share the information. An approach is needed to improve the accessibility of electronic data stored in legacy system databases. In this study, a legacy database is converted into a relational format in the personal computer environment. The impact of such a conversion on query performance is evaluated, and issues that need to be considered when converting a legacy system database are identified.

Full text

PDF
372

Selected References

These references are in PubMed. This may not be the complete list of references from this article.

  1. Burkett M. E. The tertiary center and health departments in cooperation: the Duke University experience. J Perinat Neonatal Nurs. 1989 Jan;2(3):11–19. doi: 10.1097/00005237-198901000-00004. [DOI] [PubMed] [Google Scholar]
  2. Fisher L. D., Gillespie M. J., Jones M., McBride R. Design of clinical database management systems and associated software to facilitate medical statistical research. Crit Rev Med Inform. 1988;1(4):323–331. [PubMed] [Google Scholar]
  3. Fries J. F. The chronic disease data bank model: a conceptual framework for the computer-based medical record. Comput Biomed Res. 1992 Dec;25(6):586–601. doi: 10.1016/0010-4809(92)90012-y. [DOI] [PubMed] [Google Scholar]
  4. Hlatky M. A., Lee K. L., Harrell F. E., Jr, Califf R. M., Pryor D. B., Mark D. B., Rosati R. A. Tying clinical research to patient care by use of an observational database. Stat Med. 1984 Oct-Dec;3(4):375–387. doi: 10.1002/sim.4780030415. [DOI] [PubMed] [Google Scholar]
  5. Safran C. Using routinely collected data for clinical research. Stat Med. 1991 Apr;10(4):559–564. doi: 10.1002/sim.4780100407. [DOI] [PubMed] [Google Scholar]
  6. Tierney W. M., McDonald C. J. Practice databases and their uses in clinical research. Stat Med. 1991 Apr;10(4):541–557. doi: 10.1002/sim.4780100406. [DOI] [PubMed] [Google Scholar]

Articles from Proceedings of the Annual Symposium on Computer Application in Medical Care are provided here courtesy of American Medical Informatics Association

RESOURCES