Evaluation of a flowchart-based EHR query system: a case study of RetroGuide

Area of Science:

• Health Informatics
• Human-Computer Interaction
• Database Querying

Background:

• Intuitive query systems for non-experts are a significant informatics challenge.
• Existing systems like Structured Query Language (SQL) can be difficult for users without extensive database experience.
• Electronic Health Record (EHR) data requires accessible querying methods for broader utilization.

Purpose of the Study:

• To evaluate the usability and effectiveness of RetroGuide, a novel flowchart-based query system.
• To compare RetroGuide's performance against SQL for non-expert users.
• To assess user acceptance and identify key factors influencing the adoption of new query technologies.

Main Methods:

• A mixed-method study involving 18 human subjects with limited database experience.
• Quantitative comparison of test scores between RetroGuide and SQL for query tasks.
• Qualitative analysis through questionnaires assessing user preference, ease of learning, and technology acceptance.

Main Results:

• Study subjects achieved significantly higher test scores using RetroGuide compared to SQL.
• 94% of subjects preferred RetroGuide, citing its ease of learning, better support for temporal tasks, and logical modeling paradigm.
• Technology acceptance model indicated high potential user acceptance for a fully developed RetroGuide system.

Conclusions:

• RetroGuide offers a more intuitive and effective approach to data querying for non-experts, particularly for EHR data.
• The flowchart-based, patient-centered design of RetroGuide enhances usability and user satisfaction over traditional SQL.
• Further development of RetroGuide-like systems is warranted, with potential for widespread adoption in health informatics.