Evidence map›Paper›PMID 22970696›Full record

ArticleBMC medical informatics and decision making2012

Text data extraction for a prospective, research-focused data mart: implementation and validation.

Monique Hinchcliff, Eric Just, Sofia Podlusky, John Varga, Rowland W Chang, Warren A Kibbe

Abstract readValidation Study
In one paragraph

Article in BMC medical informatics and decision making, 2012. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 11 papers, 1 of them a synthesis that pooled it.

0numbers the graph read from it
0cells of the map it votes in
11citing papers in PubMed, 1 pooled it
–field-weighted citation impact
1 · What the graph read from it

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.

2 · The registry

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.

3 · Its place in the literature

Who cites it

11 citing papers in PubMed, 1 synthesis or guideline pooled it.

  1. Pooled it
  2. Article
  3. Article
  4. Article
  5. Article
  6. Article
  7. Disease Staging and Prognosis in Smokers Using Deep Learning in Chest Computed Tomography.American journal of respiratory and critical care medicine · 2018
    Article
  8. Article
  9. Article
  10. Article
  11. Article
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

6 authors.

Monique HinchcliffDepartment of Medicine, Division of Rheumatology, Northwestern University Feinberg School of Medicine, Chicago, USA. m-hinchcliff@northwestern.edu
Eric Just
Sofia Podlusky
John Varga
Rowland W Chang
Warren A Kibbe

Funding

MULTIDISCIPLINARY CLINICAL AND TRANSLATIONAL SCIENCE (MCTS) PROGRAM (UL1)UL1RR025741 · NCRR · NORTHWESTERN UNIVERSITY AT CHICAGO · PI GREENLAND, PHILIP · 2008 to 2011
$24.7M
Study of Lupus Vascular and Bone Longterm EndpointsP60AR048098 · NIAMS · NORTHWESTERN UNIVERSITY AT CHICAGO · PI PASCHE, BORIS · 2002 to 2011
$11.4M
Multidisciplinary Clinical and Translational Science (MCTS) Program (UL1)UL1TR000150 · NCATS · NORTHWESTERN UNIVERSITY AT CHICAGO · PI LLOYD-JONES, DONALD M · 2012 to 2013
$10.1M
Career Development in Women's Health (CDWH)K12HD055884 · NICHD · NORTHWESTERN UNIVERSITY AT CHICAGO · PI DUNAIF, ANDREA E · 2007 to 2016
$4.2M
NCATS NIH HHS UL1 TR000150NCRR NIH HHS UL1RR025741NIAMS NIH HHS P60 AR48098NICHD NIH HHS K12 HD055884
6 · The paper itself

Abstract

backgroundTranslational research typically requires data abstracted from medical records as well as data collected specifically for research. Unfortunately, many data within electronic health records are represented as text that is not amenable to aggregation for analyses. We present a scalable open source SQL Server Integration Services package, called Regextractor, for including regular expression parsers into a classic extract, transform, and load workflow. We have used Regextractor to abstract discrete data from textual reports from a number of 'machine generated' sources. To validate this package, we created a pulmonary function test data mart and analyzed the quality of the data mart versus manual chart review.

methodsEleven variables from pulmonary function tests performed closest to the initial clinical evaluation date were studied for 100 randomly selected subjects with scleroderma. One research assistant manually reviewed, abstracted, and entered relevant data into a database. Correlation with data obtained from the automated pulmonary function test data mart within the Northwestern Medical Enterprise Data Warehouse was determined.

resultsThere was a near perfect (99.5%) agreement between results generated from the Regextractor package and those obtained via manual chart abstraction. The pulmonary function test data mart has been used subsequently to monitor disease progression of patients in the Northwestern Scleroderma Registry. In addition to the pulmonary function test example presented in this manuscript, the Regextractor package has been used to create cardiac catheterization and echocardiography data marts. The Regextractor package was released as open source software in October 2009 and has been downloaded 552 times as of 6/1/2012.

conclusionsCollaboration between clinical researchers and biomedical informatics experts enabled the development and validation of a tool (Regextractor) to parse, abstract and assemble structured data from text data contained in the electronic health record. Regextractor has been successfully used to create additional data marts in other medical domains and is available to the public.

Indexed as

Translational Research, BiomedicalData MiningElectronic Data ProcessingElectronic Health RecordsHumansMedical InformaticsRespiratory Function TestsScleroderma, SystemicSclerosisSoftwareUnited States

Identifiers

PMID22970696
PMCPMC3537747

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

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.