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
. 1991:386–390.

Evaluation of an SQL model of the HELP patient database.

S M Huff 1, C L Berthelsen 1, T A Pryor 1, A S Dudley 1
PMCID: PMC2247560  PMID: 1807629

Abstract

We tested a new model of the HELP patient database that makes use of relational tables to store patient data and provides access to data using SQL (Structured Query Language). The SQL database required more storage space and had many more physical records than the HELP database, but it was faster and more efficient in storing data than the standard HELP utilities. The HELP utilities used disk space more efficiently and were faster than the SQL tools when retrieving data for typical clinical reports. However, the SQL model provides networking capabilities, general report writing tools, detailed user documentation, and an ability for creating secondary indexes that offset its poorer performance.

Full text

PDF
388

Selected References

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

  1. Pryor T. A., Gardner R. M., Clayton P. D., Warner H. R. The HELP system. J Med Syst. 1983 Apr;7(2):87–102. doi: 10.1007/BF00995116. [DOI] [PubMed] [Google Scholar]
  2. Pryor T. A. The HELP medical record system. MD Comput. 1988 Sep-Oct;5(5):22–33. [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