Visualizing healthcare system dynamics in biomedical big data
Welcome to the website for "Visualizing healthcare system dynamics in biomedical big data", an NIH-funded project in the Weber Lab in the Department of Biomedical Informatics at Harvard Medical School. Biomedical Big Data, such as electronic health records (EHR) and administrative claims, are records of patients' interactions with the healthcare system; for example, the date of a diagnosis is when a physician entered the code into the EHR, not when the patient developed the disease. Most researchers are either unaware of the distinction or naively treat it as noise. However, the proposed research will show, using a novel Data Visualization, that these subtle effects of the healthcare system on observational clinical data actually contain valuable information that could benefit biomedical research, clinical care, and health care policy.
Project dates: Jun 1, 2015 - May 31, 2019
For more information: Please contact Griffin M Weber, MD, PhD
Electronic health records (EHR) and administrative claims databases are transforming medical research by giving investigators access to data on millions of individual patients. Compared to manual paper chart review, these databases reduce the time and cost of clinical studies by orders of magnitude, enabling types of research that were unfeasible in the past. However, investigators often incorrectly treat EHR and claims data as simply big versions of clinical trials data. Yet, there are important differences: During clinical trials, patient information is obtained and recorded in a standardized way and checked for accuracy and completeness. In contrast, EHR and claims are observational databases, which reflect not only the health of the patients, but also their interactions with the healthcare system. For example, the date associated with a code for diabetes is when the physician made the diagnosis, not when the patient first developed the disease. These observations are influenced by the dynamics of the healthcare system--when physicians schedule visits with their patients, which tests physicians decide to order, what codes need to be recorded to get reimbursed for procedures, etc. By ignoring this dimension of the data or naively treating it as noise, investigators risk both misinterpreting the true patient pathophysiology and losing valuable information content. In prior work we showed that analysis of the "healthcare system dynamics" (HSD) dimension of observational databases can actually be more useful than the patient pathophysiology in predicting survival, selecting matched control cohorts, identifying healthy patients, and defining normal ranges of laboratory tests. Yet, conveying the concept of HSD to researchers and helping them use it effectively is difficult. Therefore, focusing on the topic area of Data Visualization, this proposal addresses this challenge of separating healthcare system dynamics from pathophysiology in observational databases, so that Big Data researchers can use both dimensions to generate new knowledge about patient health. To do this, we bring together informatics and data visualization experts who developed two widely adopted open source software platforms for querying clinical data repositories (Informatics for Integrating Biology and the Bedside, i2b2) and developing modular data analysis and visualization tools (Science of Science, Sci2). We will leverage these systems to perform three Specific Aims: (1) Create an extensible ontology for visualizing the HSD dimensions of biomedical Big Data. (2) Develop a prototype interactive visualization to enable investigators to study HSD in Big Data. The visualization will be simple and familiar to investigators, but innovative in that for the first time HSD will be treated as its own informative component of the data. By literally placing HSD on its own dimension, the visualization will show investigators its value and teach them how to use it for research. (3) Demonstrate and evaluate the visualizations using three sources of biomedical Big Data: EHR data from two hospital systems in Boston with a total of 7 million patients and nationwide claims data from Aetna health insurance with 34 million patients.
- Agniel D, Kohane IS, Weber GM. Biases in electronic health record data due to processes within the healthcare system: retrospective observational study. BMJ. 2018 Apr 30;361:k1479. doi: 10.1136/bmj.k1479. PubMed PMID: 29712648; PubMed Central PMCID: PMC5925441.
- Yu W, Weber GM. HyperMinHash: MinHash in LogLog space. March 28, 2018. arXiv:1710.08436.
HSD Extensions for i2b2
The script below adds HSD concepts to i2b2 version 1.7 or higher. The first part of the script should be run on the i2b2 clinical research chart (CRC) cell, and the second part should be run on the i2b2 ontology (ONT) cell. The script requires Microsoft SQL Server 2012 (or newer).
The following HSD concepts are included in the database script:
- Fact Count (the total number of data facts a patient has)
- Fact Count Percentile (in the range 0%-99%)
- Time Period - Hour (hour of the day, 12am to 11pm)
- Time Period - Weekday (day of the week, Sunday to Saturday)
- Time Period - Month (month of the year, January to December)
- Repeat Interval - Time since the same lab test was last ordered
Download database script: HSD_Extensions_For_i2b2.txt
The following zip file contains i2b2 web client plugins for an HSD "fact count" visualization and an HSD laboratory test visualization.
Download web client plugins: HSD_i2b2_ClientSide_Plugins.zip
HSD Demonstration Website:
Launch an i2b2 instance with the HSD ontology and visualizations in a new browser window/tab. Use the default username and password. The underlying data is the demo dataset that comes with the i2b2 software, available at http://www.i2b2.org.
The items below illustrate our newest software tools. However, they are still under development, and therefore will be unavailable at certain times and might differ from the final software.
- Our development i2b2 HSD website implements the HSD ontology in alternative ways (e.g., adding database views or using modifiers instead of concepts).
- Try a stand-alone example of our laboratory test heatmap visualization illustrating patient survival rates following a white blood cell (WBC) count laboratory test. Patients are grouped by the value of the test result as well as the time of day of the test, in either 24 one-hour blocks or 3 eight-hour blocks.
SumTree Visualization of i2b2 Ontologies
Standard medical ontologies, such as ICD-10 diagnoses and RxNorm medications, have many thousands of concepts. Existing tree-based visualizations enable users to expand a "parent" concept to view its "child" concepts. However, this only shows a tiny portion of the entire ontology. We created a "SumTree" visualization that extends a traditional tree view by graphically showing next to each concept summary statistics about the full subtree under that concept. With SumTrees, users can simultaneously see both the overall structure of an entire ontology and details of individual concepts.
Real-Time Queries of Large i2b2 Databases
A challenge of creating interactive data visualizations of population-wide health data for millions of patients is being able to query the underlying clinical databases in real-time. We leveraged "streaming algorithms", which compress big data into small probabilistic data structures called "sketches", to gain orders of magnitude in query performance compared to conventional methods. An implementation of the "HyperMinHash" streaming algorithm that we developed for this project is available on GitHub.
Consistent with our Data Sharing Policy, we are pleased to share datasets that we have been using to develop and test our software.
- Our first dataset contains 100,000 records for each of 97 common laboratory tests and 1 million white blood cell (WBC) count tests. The data come from Brigham and Women's Hospital and Massachusetts General Hospital in Boston, Massachusetts, between 1986 and 2004. Please complete the Data Use Agreement to obtain access to this dataset.
- Our second dataset contains more than 8 million records for 272 laboratory tests, along with three-year survival rates and 30-day readmission rates of the patients. Please complete the Data Use Agreement to obtain access to this dataset.