Proc Annu Symp Comput Appl Med Care. 1991:386-90.

Evaluation of an SQL model of the HELP patient database.

Huff SM, Berthelsen CL, Pryor TA, Dudley AS.

Source

Department of Medical Informatics, LDS Hospital/University of Utah, Salt Lake City 84143.

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.

PMID:: 1807629; [PubMed - indexed for MEDLINE]
PMCID:: PMC2247560

Free PMC Article

Publication Types, MeSH Terms

Publication Types

Comparative Study

MeSH Terms

LinkOut - more resources

Full Text Sources

Other Literature Sources

COS Scholar Universe

Supplemental Content

Save items

Related citations in PubMed

Structured Query Language (SQL) fundamentals. [Curr Protoc Bioinformatics. 2003]
Structured Query Language (SQL) fundamentals.
Jamison DC. Curr Protoc Bioinformatics. 2003 Feb; Chapter 9:Unit9.2.
A standards-based clinical information system for HIV/AIDS. [Medinfo. 1995]
A standards-based clinical information system for HIV/AIDS.
Stitt FW. Medinfo. 1995; 8 Pt 1:402.
[Statistics and evaluation of a graphic SQL user interface in an anesthesia information management system (AIMS)]. [Anasthesiol Intensivmed Notfal...]
[Statistics and evaluation of a graphic SQL user interface in an anesthesia information management system (AIMS)].
Benson M, Junger A, Quinzio L, Jost A, Hempelmann G. Anasthesiol Intensivmed Notfallmed Schmerzther. 1999 Jan; 34(1):24-32.
Review Database and knowledge base integration--a data mapping method for Arden Syntax knowledge modules. [Methods Inf Med. 1996]
Review Database and knowledge base integration--a data mapping method for Arden Syntax knowledge modules.
Johansson B, Shahsavar N, Ahlfeldt H, Wigertz O. Methods Inf Med. 1996 Dec; 35(4-5):302-8.
Review A review of content-based image retrieval systems in medical applications-clinical benefits and future directions. [Int J Med Inform. 2004]
Review A review of content-based image retrieval systems in medical applications-clinical benefits and future directions.
Müller H, Michoux N, Bandon D, Geissbuhler A. Int J Med Inform. 2004 Feb; 73(1):1-23.

See reviews... See all...

Cited by 2 PubMed Central articles

Review Generic design of Web-based clinical databases. [J Med Internet Res. 2003]
Review Generic design of Web-based clinical databases.
Anhøj J. J Med Internet Res. 2003 Nov 4; 5(4):e27. Epub 2003 Nov 4.
A comparison of the temporal expressiveness of three database query methods. [Proc Annu Symp Comput Appl Med...]
A comparison of the temporal expressiveness of three database query methods.
Das AK, Musen MA. Proc Annu Symp Comput Appl Med Care. 1995; :331-7.

Related information

Related Citations
Calculated set of PubMed citations closely related to the selected article(s) retrieved using a word weight algorithm. Related articles are displayed in ranked order from most to least relevant, with the “linked from” citation displayed first.
References for this PMC Article
Citation referenced in PubMed article. Only valid for PubMed citations that are also in PMC.
Free in PMC
Free full text articles in PMC
Cited in PMC
Full-text articles in the PubMed Central Database that cite the current articles.

Recent activity

Clear Turn Off Turn On

Evaluation of an SQL model of the HELP patient database.
Evaluation of an SQL model of the HELP patient database.
Proc Annu Symp Comput Appl Med Care. 1991 :386-90.

PubMed
Dosage compensation in the mouse balances up-regulation and silencing of X-linke...
Dosage compensation in the mouse balances up-regulation and silencing of X-linked genes.
PLoS Biol. 2007 Dec ;5(12):e326.

PubMed
Clustered environments and randomized genes: a fundamental distinction between c...
Clustered environments and randomized genes: a fundamental distinction between conventional and genetic epidemiology.
PLoS Med. 2007 Dec ;4(12):e352.

PubMed
The consumption of khat and other drugs in Somali combatants: a cross-sectional ...
The consumption of khat and other drugs in Somali combatants: a cross-sectional study.
PLoS Med. 2007 Dec ;4(12):e341.

PubMed
The effect of single versus multiple sets on strength.
The effect of single versus multiple sets on strength.
J Strength Cond Res. 2007 Nov ;21(4):1003-6.

PubMed

Your browsing activity is empty.

Activity recording is turned off.

Turn recording back on

PubMed

Result Filters

Display Settings:

Send to: