Literature DB >> 8563305

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

J C Prather1, D F Lobach, J W Hales, M L Hage, S J Fehrs, W E Hammond.   

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.

Mesh：

Year:  1995        PMID： 8563305      PMCID： PMC2579117     

Source DB:  PubMed          Journal:  Proc Annu Symp Comput Appl Med Care        ISSN： 0195-4210


  6 in total

1.  The chronic disease data bank model: a conceptual framework for the computer-based medical record.

Authors:  J F Fries
Journal:  Comput Biomed Res       Date:  1992-12

Review 2.  Practice databases and their uses in clinical research.

Authors:  W M Tierney; C J McDonald
Journal:  Stat Med       Date:  1991-04       Impact factor: 2.373

3.  Using routinely collected data for clinical research.

Authors:  C Safran
Journal:  Stat Med       Date:  1991-04       Impact factor: 2.373

4.  Design of clinical database management systems and associated software to facilitate medical statistical research.

Authors:  L D Fisher; M J Gillespie; M Jones; R McBride
Journal:  Crit Rev Med Inform       Date:  1988

5.  The tertiary center and health departments in cooperation: the Duke University experience.

Authors:  M E Burkett
Journal:  J Perinat Neonatal Nurs       Date:  1989-01       Impact factor: 1.638

6.  Tying clinical research to patient care by use of an observational database.

Authors:  M A Hlatky; K L Lee; F E Harrell; R M Califf; D B Pryor; D B Mark; R A Rosati
Journal:  Stat Med       Date:  1984 Oct-Dec       Impact factor: 2.373
  6 in total
  5 in total

1.  How the past teaches the future: ACMI distinguished lecture.

Authors:  W E Hammond
Journal:  J Am Med Inform Assoc       Date:  2001 May-Jun       Impact factor: 4.497

2.  Data extraction and ad hoc query of an entity-attribute-value database.

Authors:  P M Nadkarni; C Brandt
Journal:  J Am Med Inform Assoc       Date:  1998 Nov-Dec       Impact factor: 4.497

3.  Medical data mining: knowledge discovery in a clinical data warehouse.

Authors:  J C Prather; D F Lobach; L K Goodwin; J W Hales; M L Hage; W E Hammond
Journal:  Proc AMIA Annu Fall Symp       Date:  1997

4.  Web client and ODBC access to legacy database information: a low cost approach.

Authors:  N W Sanders; N H Mann; D M Spengler
Journal:  Proc AMIA Annu Fall Symp       Date:  1997

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

Authors:  K W Scully; R D Pates; G S Desper; A F Connors; F E Harrell; K S Pieper; R L Hannan; R E Reynolds
Journal:  Proc AMIA Annu Fall Symp       Date:  1997
  5 in total

北京卡尤迪生物科技股份有限公司 © 2022-2023.