Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Concept Videos

Fischer Projections02:18

Fischer Projections

16.6K
Learning to draw Fischer projections of molecules and understanding their relevance plays a crucial role in the visual depiction of organic molecules. A Fischer projection is a two-dimensional projection on a planar surface to simplify the three-dimensional wedge–dash representation of molecules. This is especially helpful in the case of molecules with multiple chiral centers that can be difficult to draw. Here, all the bonds of interest are represented as horizontal or vertical lines. While...
16.6K
Newman Projections02:06

Newman Projections

21.2K
Different notations are used to represent the three-dimensional structure of molecules on two-dimensional surfaces. One of the most commonly used representations is the dash-wedge formula. The dashed wedges, solid wedges, and the plane lines indicate the groups situated behind the plane, coming out of the plane, and in the plane, respectively.
The organic molecules rotate across the single bonds leading to numerous temporary three-dimensional structures of varying energy known as...
21.2K
Self-Help Support Groups01:28

Self-Help Support Groups

359
Self-help support groups are voluntary, community-based organizations that provide a platform for individuals with shared concerns to exchange support, insights, and practical strategies for coping with life challenges. Typically led by group members or paraprofessionals, these groups form a cornerstone of mental health care, especially in reaching populations that are underserved by traditional healthcare systems.
Accessibility and Cost-Effectiveness
One of the primary strengths of self-help...
359
Drug Discovery: Overview01:26

Drug Discovery: Overview

11.8K
Drug discovery is a multifaceted process involving extensive screening, testing, and optimization of lead compounds to identify potential new drugs for therapeutic use. It combines several approaches, including screening large numbers of natural products, chemical modification of known active molecules, identification of new drug targets, and rational design based on biological mechanisms and drug-receptor structure. These approaches are carried out in both academic research laboratories and...
11.8K
Coordinates and Map Projections01:29

Coordinates and Map Projections

623
Coordinates and map projections are essential tools in accurately representing the Earth's surface for various applications, ranging from navigation to spatial analysis. The latitude and longitude coordinate system is a universally recognized framework for defining locations. Latitude specifies the distance of a point north or south of the equator, measured in degrees from 0° at the equator to 90° at the poles. Longitude indicates a location's position east or west of the prime meridian,...
623
Support Reactions01:30

Support Reactions

1.5K
A coplanar force system refers to a set of forces that all lie in the same plane and are subject to different reactions between the point of contact and the supports. Understanding how different types of supports affect coplanar forces is crucial for designing safe and reliable structures that can withstand external loads.
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...
1.5K

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

NerveAI- a machine learning algorithm for detection of nerve pain in the head and neck.

Scientific reports·2026
Same author

A method to enable clinical and translational research teams with custom real-world data from electronic health record systems.

Journal of clinical and translational science·2026
Same author

LOINC implementation approaches in academic medical research centers - results from a survey of CTSA sites.

Journal of clinical and translational science·2025
Same author

Social Determinants of Health and Delirium in the PICU: Secondary Analysis of a 2014-2015 Observational Dataset.

Pediatric critical care medicine : a journal of the Society of Critical Care Medicine and the World Federation of Pediatric Intensive and Critical Care Societies·2025
Same author

Leveraging Generative AI for Clinical Evidence Synthesis Needs to Ensure Trustworthiness.

ArXiv·2025
Same author

Extracting post-acute sequelae of SARS-CoV-2 infection symptoms from clinical notes via hybrid natural language processing.

npj health systems·2025

Related Experiment Video

Updated: Feb 7, 2026

Competing-Risk Nomogram for Predicting Cancer-Specific Survival in Multiple Primary Colorectal Cancer Patients after Surgery
06:46

Competing-Risk Nomogram for Predicting Cancer-Specific Survival in Multiple Primary Colorectal Cancer Patients after Surgery

Published on: September 27, 2024

920

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.

Journal of Biomedical Informatics
|July 17, 2018
PubMed
Summary
This summary is machine-generated.

A new method for i2b2 (Informatics for Integrating Biology and the Bedside) patient cohort discovery uses SQL views to reduce data duplication. This approach significantly cuts disk space and processing time, enhancing scalability for multiple research projects using electronic health record (EHR) data.

Keywords:
Clinical data warehouseCohort discoveryElectronic health recordI2b2ScalabilitySecondary use

More Related Videos

Comprehensive Autopsy Program for Individuals with Multiple Sclerosis
09:41

Comprehensive Autopsy Program for Individuals with Multiple Sclerosis

Published on: July 19, 2019

12.0K
Candidate Gene Testing in Clinical Cohort Studies with Multiplexed Genotyping and Mass Spectrometry
05:53

Candidate Gene Testing in Clinical Cohort Studies with Multiplexed Genotyping and Mass Spectrometry

Published on: June 21, 2018

10.7K

Related Experiment Videos

Last Updated: Feb 7, 2026

Competing-Risk Nomogram for Predicting Cancer-Specific Survival in Multiple Primary Colorectal Cancer Patients after Surgery
06:46

Competing-Risk Nomogram for Predicting Cancer-Specific Survival in Multiple Primary Colorectal Cancer Patients after Surgery

Published on: September 27, 2024

920
Comprehensive Autopsy Program for Individuals with Multiple Sclerosis
09:41

Comprehensive Autopsy Program for Individuals with Multiple Sclerosis

Published on: July 19, 2019

12.0K
Candidate Gene Testing in Clinical Cohort Studies with Multiplexed Genotyping and Mass Spectrometry
05:53

Candidate Gene Testing in Clinical Cohort Studies with Multiplexed Genotyping and Mass Spectrometry

Published on: June 21, 2018

10.7K

Area of Science:

  • Biomedical Informatics
  • Health Data Management
  • Clinical Research Informatics

Background:

  • The popular i2b2 platform facilitates patient cohort discovery from electronic health record (EHR) data.
  • Standard i2b2 implementations for multiple projects lead to data duplication, increasing storage and processing demands, thus limiting scalability.
  • Efficient data management is crucial for large-scale clinical research.

Purpose of the Study:

  • To develop and evaluate a novel, scalable approach for managing multiple i2b2 projects.
  • To reduce the storage footprint and processing overhead associated with multi-project i2b2 deployments.
  • To maintain query performance while improving data management efficiency.

Main Methods:

  • Implemented a view-based data storage strategy within a single i2b2 fact table.
  • Utilized structured query language (SQL) views to partition data access for distinct projects.
  • Compared the performance and resource utilization of the view-based approach against the standard data duplication method.

Main Results:

  • The view-based approach reduced required disk space by 59%.
  • Extract-transfer-load (ETL) processing time was decreased by 46%.
  • Query performance remained largely unaffected compared to the standard approach.

Conclusions:

  • The novel view-based approach significantly enhances the scalability of multi-project i2b2 deployments.
  • This method offers substantial savings in disk space and ETL time for EHR data management.
  • The approach is generalizable to other data models and beneficial for institutions managing multiple research projects.