Search tips
Search criteria 


Logo of procascamcLink to Publisher's site
Proc Annu Symp Comput Appl Med Care. 1995 : 62–66.
PMCID: PMC2579056

Supporting ad-hoc queries in an integrated clinical database.


Whether caring for patients or conducting research, medical decision-makers need access to clinical data. To fulfill that need, commercial software developers have produced a wide range of database query tools that differ greatly in functionality and cost. Generally, tools that have a greater ability to conceal database complexity from the user also require more effort for administrative setup. We describe a cost-effective, commercially-available query tool that requires no special setup to perform most simple queries, yet can be customized to satisfy users' more complex querying requirements.

Full text

Full text is available as a scanned copy of the original print version. Get a printable copy (PDF file) of the complete article (1.1M), or click on a page image below to browse page by page. Links to PubMed are also available for Selected References.

Selected References

These references are in PubMed. This may not be the complete list of references from this article.
  • Marrs KA, Steib SA, Abrams CA, Kahn MG. Unifying heterogeneous distributed clinical data in a relational database. Proc Annu Symp Comput Appl Med Care. 1993:644–648. [PMC free article] [PubMed]
  • Kahn MG, Steib SA, Fraser VJ, Dunagan WC. An expert system for culture-based infection control surveillance. Proc Annu Symp Comput Appl Med Care. 1993:171–175. [PMC free article] [PubMed]
  • Stevens LE, Huff SM, Haug PJ. The development of a virtual database to provide on-line access to a large archive of clinical data. Proc Annu Symp Comput Appl Med Care. 1992:600–604. [PMC free article] [PubMed]
  • Safran C, Porter D, Rury CD, Herrmann FR, Lightfoot J, Underhill LH, Bleich HL, Slack WV. ClinQuery: searching a large clinical database. MD Comput. 1990 May-Jun;7(3):144–153. [PubMed]
  • Clayton PD, Anderson RK, Hill C, McCormack M. An initial assessment of the cost and utilization of the Integrated Academic Information System (IAIMS) at Columbia Presbyterian Medical Center. Proc Annu Symp Comput Appl Med Care. 1991:109–113. [PMC free article] [PubMed]
  • Mason RN, Pugh CB, Boyer SB, Stiening KK. Computerized documentation of pharmacists' interventions. Am J Hosp Pharm. 1994 Sep 1;51(17):2131–2138. [PubMed]
  • Burnakis TG. Translating mainframe computer data to spreadsheet format. Am J Hosp Pharm. 1991 Dec;48(12):2619–2622. [PubMed]
  • Smith SL, Lubiejewski T, Farnum J. Spreadsheet interface for transfer of drug-use data from a mainframe to a personal computer. Am J Hosp Pharm. 1990 Nov;47(11):2488–2492. [PubMed]

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