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).
Download full-text PDF |
Source |
|---|---|
| http://dx.doi.org/10.1016/j.jbi.2018.07.010 | DOI Listing |
Publication Analysis
Top Keywords
Similar Publications
Thalamic deep brain stimulation for central poststroke pain syndrome: an international multicenter study.
J Neurosurg
January 2025
1Department of Neurosurgery, Inselspital, Bern University Hospital, University Bern, Switzerland.
Objective: The effectiveness and optimal stimulation site of deep brain stimulation (DBS) for central poststroke pain (CPSP) remain elusive. The objective of this retrospective international multicenter study was to assess clinical as well as neuroimaging-based predictors of long-term outcomes after DBS for CPSP.
Methods: The authors analyzed patient-based clinical and neuroimaging data of previously published and unpublished cohorts from 6 international DBS centers.
Major Adverse Kidney Events in Hospitalized Older Patients With Acute Kidney Injury: Machine Learning-Based Model Development and Validation Study.
J Med Internet Res
January 2025
Department of Nephrology, Hunan Key Laboratory of Kidney Disease and Blood Purification, The Second Xiangya Hospital of Central South University, Changsha, China.
Background: Acute kidney injury (AKI) is a common complication in hospitalized older patients, associated with increased morbidity, mortality, and health care costs. Major adverse kidney events within 30 days (MAKE30), a composite of death, new renal replacement therapy, or persistent renal dysfunction, has been recommended as a patient-centered endpoint for clinical trials involving AKI.
Objective: This study aimed to develop and validate a machine learning-based model to predict MAKE30 in hospitalized older patients with AKI.
The pediatric Brain Injury Guidelines: a retrospective clinical validation study.
J Neurosurg Pediatr
January 2025
4Department of Neurosurgery, Children's Hospital Colorado Anschutz Medical Campus, Aurora; and.
Objective: Pediatric traumatic brain injury (TBI) represents a significant public health concern and source of resource utilization. The aim of this study was to establish the ability of the previously published pediatric Brain Injury Guidelines (pBIG) to identify patients with traumatic intracranial hemorrhage (ICH) who might not require routine repeat neuroimaging, neurosurgical consultation, or hospital admission in a large level I and level II trauma cohort.
Methods: Pediatric patients who presented with traumatic ICH between 2018 and 2022 at the included institutions were retrospectively reviewed and sorted into pBIG categories using clinical and radiographic criteria.
Association between age-related hearing loss and depression: A systematic review and meta-analysis.
PLoS One
January 2025
Department of Otolaryngology Head and Neck Surgery, Yanbian University Affiliated Hospital, Yanji City, Yanbian Korean Autonomous Prefecture, Jilin Province, China.
Introduction: This meta-analysis examined the relationship between age-related hearing loss (ARHL) and depression in older adults, and further explored whether this relationship is moderated by age and gender.
Methods: We searched in 4 English databases: PubMed, Embase, Web of Science, and Cochrane Library. Ultimately, we identified 9 studies, involving 3 cohort studies and 6 cross-sectional studies.
Profile and Usefulness of Serum Cytokines to Predict Prognosis in Myelin Oligodendrocyte Glycoprotein Antibody-Associated Disease.
Neurol Neuroimmunol Neuroinflamm
March 2025
Hospices Civils de Lyon, Service de Neurologie, Sclérose en Plaques, Pathologies de la Myéline et Neuro-Inflammation-Hôpital Neurologique Pierre Wertheimer, Bron Cedex.
Objectives: To characterize the serum cytokine profile in myelin oligodendrocyte glycoprotein antibody-associated disease (MOGAD) at onset and during follow-up and assess their utility for predicting relapses and disability.
Methods: This retrospective multicentric cohort study included patients aged 16 years and older meeting MOGAD 2023 criteria, with serum samples collected at baseline (≤3 months from disease onset) and follow-up (≥6 months from the baseline), and age-matched and time to sampling-matched patients with multiple sclerosis (MS). Eleven cytokines were assessed using the ELLA system.
Want AI Summaries of new PubMed Abstracts delivered to your In-box?
Enter search terms and have AI summaries delivered each week - change queries or unsubscribe any time!