PubMed · 9929270
A graphical tool for ad hoc query generation.
Abstract
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.
Explore related subjects
Keep this discovery
Explore connections, maps & timelines
K Stoffel, J D Davis, G Rottman, J Saltz, J Dick, W Merz, R Miller. 1998. A graphical tool for ad hoc query generation.. https://pubmed.health/record/pubmed%3A9929270/a-graphical-tool-for-ad-hoc-query-generation
Citations retain the original authors and DOI and include this site’s record URL. If this discovery service contributed to your research, you can also cite PubMed Health by Indiciae: BibTeX · RIS.