Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

A graphical tool for ad hoc query generation

K Stoffel1, J D Davis, G Rottman

  • 1Computer Science Department, University of Maryland, College Park 20742, USA.

Proceedings. AMIA Symposium
|February 3, 1999
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Experiences of Personalized Dementia Risk Education: A Qualitative Study to Refine the TEACH (Tailored Education for Aging and Cognitive Health) Behavioral Intervention.

medRxiv : the preprint server for health sciences·2026
Same author

Validation of a photoelectric sensor system to detect oviposition timing in individually caged broiler breeder hens.

Poultry science·2025
Same author

Effects of reduced crude protein diets while maintaining essential amino acid concentrations on growth performance, nitrogen output, ammonia production, and meat yield.

Poultry science·2024
Same author

Analysis of complications in 97 periprosthetic Vancouver B2 fractures treated either by internal fixation or revision arthroplasty.

Archives of orthopaedic and trauma surgery·2024
Same author

Standardized artificially created stable pertrochanteric femur fractures present more homogenous results compared to osteotomies for orthopaedic implant testing.

BMC musculoskeletal disorders·2021
Same author

A phase 2, open-label study of single-dose dupilumab in children aged 6 months to <6 years with severe uncontrolled atopic dermatitis: pharmacokinetics, safety and efficacy.

Journal of the European Academy of Dermatology and Venereology : JEADV·2020
Same journal

Progressive display of very high resolution images using wavelets.

Proceedings. AMIA Symposium·2002
Same journal

The Chronus II temporal database mediator.

Proceedings. AMIA Symposium·2002
Same journal

Gene expression levels in different stages of progression in oral squamous cell carcinoma.

Proceedings. AMIA Symposium·2002
Same journal

An assessment of the visibility of MeSH-indexed medical web catalogs through search engines.

Proceedings. AMIA Symposium·2002
Same journal

Filtering for medical news items using a machine learning approach.

Proceedings. AMIA Symposium·2002
Same journal

Enriching the structure of the UMLS semantic network.

Proceedings. AMIA Symposium·2002
See all related articles

Clinicians and researchers can now easily query complex medical databases using a new graphical tool. This tool simplifies ad hoc question formulation into SQL queries, improving data retrieval speed by up to 100 times.

Area of Science:

  • Medical Informatics
  • Database Management
  • Clinical Research Tools

Background:

  • Medical data presents challenges due to complex taxonomies and evolving terminology.
  • Formulating complex questions for medical databases as standard SQL queries is difficult for users.

Purpose of the Study:

  • To introduce a graphical tool for simplifying the creation of ad hoc SQL queries from medical databases.
  • To enhance the speed and efficiency of data retrieval for clinical and research purposes.

Main Methods:

  • Development of an interactive graphical tool to manage multiple attribute hierarchies.
  • Navigation through hierarchies to generate SQL query strings.
  • Optimization of the tool using indexing to accelerate query building and data retrieval.

Related Experiment Videos

Main Results:

  • Indexed queries demonstrated a significant speed improvement, performing 5 to 100 times faster than non-indexed query strings.
  • Query string generation time is dependent on taxonomy size; index generation time depends on data warehouse size.

Conclusions:

  • The graphical tool effectively simplifies the process of formulating complex questions for medical databases.
  • Indexing significantly enhances the performance of data retrieval, making medical data more accessible for analysis.