Related Experiment Video
Updated: Feb 7, 2026

Competing-Risk Nomogram for Predicting Cancer-Specific Survival in Multiple Primary Colorectal Cancer Patients after Surgery
Published on: September 27, 2024
A scalable method for supporting multiple patient cohort discovery projects using i2b2
Evan T Sholle1, Marcos A Davila1, Joseph Kabariti1
1Information Technologies & Services Department, Weill Cornell Medicine, New York, NY, USA.
Abstract:
Although i2b2, a popular platform for patient cohort discovery using electronic health record (EHR) data, can support multiple projects specific to individual disease areas or research interests, the standard approach for doing so duplicates data across projects, requiring additional disk space and processing time, which limits scalability. To address this deficiency, we developed a novel approach that stored data in a single i2b2 fact table and used structured query language (SQL) views to access data for specific projects. Compared to the standard approach, the view-based approach reduced required disk space by 59% and extract-transfer-load (ETL) time by 46%, without substantially impacting query performance. The view-based approach has enabled scalability of multiple i2b2 projects and generalized to another data model at our institution. Other institutions may benefit from this approach, code of which is available on GitHub (https://github.com/wcmc-research-informatics/super-i2b2).
Related Concept Videos
Fischer Projections
Newman Projections
The organic molecules rotate across the single bonds leading to numerous temporary three-dimensional structures of varying energy known as...
Self-Help Support Groups
Accessibility and Cost-Effectiveness
One of the primary strengths of self-help...
Drug Discovery: Overview
Coordinates and Map Projections
Support Reactions
The purpose of the supports is to prevent the translational motion of the system by applying an equal and opposite force and to prevent the system's rotation by applying...

