Development and Validation of Queries Using Structured Query Language (SQL) to Determine the Utilization of Comparison Imaging in Radiology Reports Stored on PACS.

The purpose of this research was to develop queries that quantify the utilization of comparison imaging in free-text radiology reports. The queries searched for common phrases that indicate whether comparison imaging was utilized, not available, or not mentioned. The queries were iteratively refined...

Descripción completa

Detalles Bibliográficos
Publicado en:Journal of Digital Imaging Vol. 19; no. 1; pp. 52 - 69
Autores principales: Lakhani P, Menschik E, Goldszal A, Murray J, Weiner M, Langlotz C
Formato: research tables/charts Journal Article
Publicado: Springer Nature Mar2006
Acceso en línea:Ver este registro en EBSCOhost
fields @attributes:
  recordID: 1
pdfLink:
plink: https://search.ebscohost.com/login.aspx?direct=true&db=ccm&AN=106200209&site=ehost-live
header:
  @attributes:
    shortDbName: ccm
    uiTerm: 106200209
    longDbName: CINAHL Complete
    uiTag: AN
  controlInfo:
    bkinfo:
    dissinfo:
    jinfo:
      jid:
        08971889
        DOQ
      jtl: Journal of Digital Imaging
      issn: 08971889
      maglogo: N
    pubinfo:
      dt: Mar2006
      vid: 19
      iid: 1
      pid: 237
      pub: Springer Nature
      place: New York, New York
    artinfo:
      ui:
        106200209
        2009220702
        10.1007/s10278-005-7667-y
        NLM16132483
        106200209
      ppf: 52
      ppct: 17
      formats:
        fmt:
          @attributes:
            type: P
      tig:
        atl: Development and Validation of Queries Using Structured Query Language (SQL) to Determine the Utilization of Comparison Imaging in Radiology Reports Stored on PACS.
      aug:
        au:
          Lakhani P
          Menschik E
          Goldszal A
          Murray J
          Weiner M
          Langlotz C
      sug:
        subj:
          Image Processing, Computer Assisted
          Information Retrieval Methods
          Management Information Systems
          Natural Language Processing
          Picture Archiving and Communication Systems
          Reproducibility of Results
          Software
          Validation Studies
          Human
      ab: The purpose of this research was to develop queries that quantify the utilization of comparison imaging in free-text radiology reports. The queries searched for common phrases that indicate whether comparison imaging was utilized, not available, or not mentioned. The queries were iteratively refined and tested on random samples of 100 reports with human review as a reference standard until the precision and recall of the queries did not improve significantly between iterations. Then, query accuracy was assessed on a new random sample of 200 reports. Overall accuracy of the queries was 95.6%. The queries were then applied to a database of 1.8 million reports. Comparisons were made to prior images in 38.69% of the reports (693,955/1,793,7541), were unavailable in 18.79% (337,028/1,793,754), and were not mentioned in 42.52% (762,771/1,793,754). The results show that queries of text reports can achieve greater than 95% accuracy in determining the utilization of prior images.
      pubtype: Academic Journal
      doctype:
        research
        tables/charts
        Journal Article
      ougenre: Article
    language: English
    refInfo:
    holdings:
      @attributes:
        islocal: N