Related Experiment Video
Updated: May 17, 2026

Performing Data Mining And Integrative Analysis Of Biomarker in Breast Cancer Using Multiple Publicly Accessible Databases
Published on: May 17, 2019
Identifying clinical/translational research cohorts: ascertainment via querying an integrated multi-source database
John F Hurdle1, Stephen C Haroldsen, Andrew Hammer
1Department of Biomedical Informatics, University of Utah Health Sciences Center, Salt Lake City, UT 84112, USA. john.hurdle@utah.edu
Background:
Ascertainment of potential subjects has been a longstanding problem in clinical research. Various methods have been proposed, including using data in electronic health records. However, these methods typically suffer from scaling effects-some methods work well for large cohorts; others work for small cohorts only.
Objective:
We propose a method that provides a simple identification of pre-research cohorts and relies on data available in most states in the USA: merged public health data sources.
Materials And Methods:
The Utah Population Database Limited query tool allows users to build complex queries that may span several types of health records, such as cancer registries, inpatient hospital discharges, and death certificates; in addition, these can be combined with family history information. The architectural approach incorporates several coding systems for medical information. It provides a front-end graphical user interface and enables researchers to build and run queries and view aggregate results. Multiple strategies have been incorporated to maintain confidentiality.
Results:
This tool was rapidly adopted; since its release, 241 users representing a wide range of disciplines from 17 institutions have signed the user agreement and used the query tool. Three examples are discussed: pregnancy complications co-occurring with cardiovascular disease; spondyloarthritis; and breast cancer.
Discussion And Conclusions:
This query tool was designed to provide results as pre-research so that institutional review board approval would not be required. This architecture uses well-described technologies that should be within the reach of most institutions.
Related Concept Videos
Genomics
Clinical Trials: Overview
Clinical Trials
There are four phases in a clinical trial. A phase one...
Types of Biopharmaceutical Studies: Controlled and Non-Controlled Approaches
Non-controlled studies, commonly employed for initial exploration, lack a control group, rendering them susceptible to biases and external influences. In contrast, controlled...

