PubMed Health⌕ Search
Home/Archive/PubMed

PubMed · 8563305

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

J C Prather·D F Lobach·J W Hales·M L Hage·S J Fehrs·W E Hammond
View original source ↗Export metadata ↓

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.

Explore related subjects

Computer SystemsHumansInformation Storage and RetrievalMedical Records Systems, ComputerizedMicrocomputersSoftwareSystems IntegrationJournal ArticleResearch Support, U.S. Gov't, P.H.S.

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

J C Prather, D F Lobach, J W Hales, M L Hage, S J Fehrs, W E Hammond. 1995. Converting a legacy system database into relational format to enhance query efficiency.. https://pubmed.ncbi.nlm.nih.gov/8563305/

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related citations

PubMed1996

Ultrasound image fusion for external beam radiotherapy for prostate cancer.

PURPOSE: To determine whether real-time ultrasound imaging and targeting system for the treatment of prostate cancer was feasible. The initial phase of this project included a study to develop and determine (a) software for the fusion of ultrasound images to standard x-rays obtained during simulation, and (b) the potential reduction in field size with real-time imaging. METHODS AND MATERIALS: During 13 patient simulations a transrectal ultrasound image was obtained. Orthogonal x-ray films were acquired with the rectal probe in place. Both the x-ray and ultrasound images were digitized and a fusion image was created of the prostate position in relation to the probe, bladder, and rectum. The two-dimensional area of the rectum, bladder, and prostate was determined in the lateral projection. Potential conformal blocks were designed for the lateral portals in a four-field treatment technique. RESULTS: The transrectal ultrasound probe enabled real-time prostate imaging. The lateral field size can be reduced to 6.08 x 5.68 cm2 +/- 0.62 x 0.48 cm2 from the standard 8 x 8 cm2 field. The posterior rectal wall was physically displaced out of the lateral field. The area of the rectum included in the lateral field is 1.75 cm2 +/- 0.85 cm2. CONCLUSION: The prostate position can be determined with certainty on a regular basis with transrectal ultrasonography. The amount of normal tissue in the high dose volume can be reduced. This approach may reduce acute and chronic morbidity and allow further dose escalation.

Computer Systems↗