ArticleJournal of biomedical informatics2021
ELII: A novel inverted index for fast temporal query, with application to a large Covid-19 EHR dataset.
Article in Journal of biomedical informatics, 2021. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 14 papers.
What it found
Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.
The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.
The trial behind it
Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.
Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.
Who cites it
14 citing papers in PubMed.
- Leveraging SNOMED CT for patient cohort identification over heterogeneous EHR data.AMIA Joint Summits on Translational Science proceedings. AMIA Joint Summits on Translational Science · 2025Article
- Quantitatively assessing the impact of the quality of SNOMED CT subtype hierarchy on cohort queries.Journal of the American Medical Informatics Association : JAMIA · 2025Article
- An Interactive Information Visualization System for Temporal Queries in a Large-scale COVID-19 EHR Dataset (COVID-SPHERE): development and qualitative evaluation.AMIA ... Annual Symposium proceedings. AMIA Symposium · 2024Article
- VisualSphere: a Web-based Interactive Visualization System for Clinical Research Data.AMIA Joint Summits on Translational Science proceedings. AMIA Joint Summits on Translational Science · 2024Article
- Optimizing Medication Querying Using Ontology-Driven Approach with OMOP: with an application to a large-scale COVID-19 EHR dataset.AMIA ... Annual Symposium proceedings. AMIA Symposium · 2024Article
- Representing and utilizing clinical textual data for real world studies: An OHDSI approach.Journal of biomedical informatics · 2023Article
- A Query Engine for Self-controlled Case Series, with an application to COVID-19 EHR data.AMIA Joint Summits on Translational Science proceedings. AMIA Joint Summits on Translational Science · 2023Article
- Data Mining Pipeline for COVID-19 Vaccine Safety Analysis Using a Large Electronic Health Record.AMIA Joint Summits on Translational Science proceedings. AMIA Joint Summits on Translational Science · 2023Article
- Age and sex-specific stroke epidemiology in COVID-19.Frontiers in stroke · 2023Article
- Novel informatics approaches to COVID-19 Research: From methods to applications.Journal of biomedical informatics · 2022Article
- Temporal Cohort Logic.AMIA ... Annual Symposium proceedings. AMIA Symposium · 2022Article
- COVID-19 Outcomes in Myasthenia Gravis Patients: Analysis From Electronic Health Records in the United States.Frontiers in neurology · 2022Article
- Comparing automated vs. manual data collection for COVID-specific medications from electronic health records.International journal of medical informatics · 2022Article
- COVID-19 severity and outcome in multiple sclerosis: Results of a national, registry-based, matched cohort study.Multiple sclerosis and related disorders · 2021Article
Corrections and comments
PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.
Authors and funding
3 authors.
Funding
No grant is acknowledged in the PubMed record.
Abstract
Fast temporal query on large EHR-derived data sources presents an emerging big data challenge, as this query modality is intractable using conventional strategies that have not focused on addressing Covid-19-related research needs at scale. We introduce a novel approach called Event-level Inverted Index (ELII) to optimize time trade-offs between one-time batch preprocessing and subsequent open-ended, user-specified temporal queries. An experimental temporal query engine has been implemented in a NoSQL database using our new ELII strategy. Near-real-time performance was achieved on a large Covid-19 EHR dataset, with 1.3 million unique patients and 3.76 billion records. We evaluated the performance of ELII on several types of queries: classical (non-temporal), absolute temporal, and relative temporal. Our experimental results indicate that ELII accomplished these queries in seconds, achieving average speed accelerations of 26.8 times on relative temporal query, 88.6 times on absolute temporal query, and 1037.6 times on classical query compared to a baseline approach without using ELII. Our study suggests that ELII is a promising approach supporting fast temporal query, an important mode of cohort development for Covid-19 studies.
Indexed as
Identifiers
What OpenQuestion holds
Registered trials
Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.