Abstract:BACKGROUND: Because of the increased adoption rate of electronic medical record (EMR) systems, more health care records have been increasingly accumulating in clinical data repositories. Therefore, querying the data stored in these repositories is crucial for retrieving the knowledge from such large volumes of clinical data.OBJECTIVE: The aim of this study is to develop a Web-based approach for enriching the capabilities of the data-querying system along the three following considerations: (1) the interface design used for query formulation, (2) the representation of query results, and (3) the models used for formulating query criteria.METHODS: The Guideline Interchange Format version 3.5 (GLIF3.5), an ontology-driven clinical guideline representation language, was used for formulating the query tasks based on the GLIF3.5 flowchart in the Protégé environment. The flowchart-based data-querying model (FBDQM) query execution engine was developed and implemented for executing queries and presenting the results through a visual and graphical interface. To examine a broad variety of patient data, the clinical data generator was implemented to automatically generate the clinical data in the repository, and the generated data, thereby, were employed to evaluate the system. The accuracy and time performance of the system for three medical query tasks relevant to liver cancer were evaluated based on the clinical data generator in the experiments with varying numbers of patients.RESULTS: In this study, a prototype system was developed to test the feasibility of applying a methodology for building a query execution engine using FBDQMs by formulating query tasks using the existing GLIF. The FBDQM-based query execution engine was used to successfully retrieve the clinical data based on the query tasks formatted using the GLIF3.5 in the experiments with varying numbers of patients. The accuracy of the three queries (ie, "degree of liver damage," "degree of liver damage when applying a mutually exclusive setting," and "treatments for liver cancer") was 100% for all four experiments (10 patients, 100 patients, 1000 patients, and 10,000 patients). Among the three measured query phases, (1) structured query language operations, (2) criteria verification, and (3) other, the first two had the longest execution time.CONCLUSIONS: The ontology-driven FBDQM-based approach enriched the capabilities of the data-querying system. The adoption of the GLIF3.5 increased the potential for interoperability, shareability, and reusability of the query tasks.

DBease: Making Databases User-Friendly and Easily Accessible.

Keyword-based Search and Exploration on Databases

Data Warehouse Native Feature Based OLAP Querying with Keywords

Supporting Search-As-You-Type Using SQL in Databases

Interactive SQL query suggestion: Making databases user-friendly

Form-Based Instant Search and Query Autocompletion on Relational Data

SQL Query Completion for Data Exploration

Reverse engineering database queries from examples: State-of-the-art, challenges, and research opportunities

Efficient Interactive Fuzzy Keyword Search.

Effective Keyword-Based Selection of Relational Databases.

An Effective and Versatile Keyword Search Engine on Heterogenous Data Sources.

Efficient fuzzy full-text type-ahead search

Baihe: SysML Framework for AI-driven Databases

A Web-Based Data-Querying Tool Based on Ontology-Driven Methodology and Flowchart-Based Model

Dartgrid : a Semantic Web Toolkit for Integrating Heterogeneous Relational Databases

Abdp: An Archetype-Driven Biomedical Data Platform On Relational Database

Web Database Schema Identification Through Simple Query Interface

Enhancing the Usability of Complex Structured Data by Supporting Keyword Searches

Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLs

A New Query Processing Scheme In A Web Data Engine