A graphical tool for ad hoc query generation.

K. Stoffel, J. D. Davis, G. Rottman, J. Saltz, J. Dick, W. Merz, R. Miller

Research output: Contribution to journalArticlepeer-review

2 Scopus citations


Medical data are characterized by complex taxonomies and evolving terminology. Questions that clinicians, medical administrators, and researchers may wish to answer using medical databases are not easily formulated as SQL queries. In this paper we describe a graphical tool that facilitates formulation of ad hoc questions as SQL queries. This tool manages multiple attribute hierarchies and creates SQL query strings by navigating through the hierarchies. This interactive tool has been optimized using indexing to improve the overall speed of the query building and the data retrieval process. Indexed queries performed 5 to 100 times faster than query strings. However, query string generation time depends on the size of the taxonomies describing the hierarchies, while the index generation time depends on the size of the data warehouse.

Original languageEnglish (US)
Pages (from-to)503-507
Number of pages5
JournalProceedings / AMIA ... Annual Symposium. AMIA Symposium
StatePublished - 1998
Externally publishedYes

ASJC Scopus subject areas

  • Medicine(all)


Dive into the research topics of 'A graphical tool for ad hoc query generation.'. Together they form a unique fingerprint.

Cite this