Development and Validation of Queries Using Structured Query Language (SQL) to Determine the Utilization of Comparison Imaging in Radiology Reports Stored on PACS | Journal of Imaging Informatics in Medicine Skip to main content
Springer Nature Link
Log in

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

  • Published:
Journal of Digital Imaging Aims and scope Submit manuscript

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,754), 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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Subscribe and save

Springer+ Basic
¥17,985 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Price includes VAT (Japan)

Instant access to the full article PDF.

Institutional subscriptions

Fig 1
Fig 2
Fig 3
Fig 4
Fig 5
Fig 6
Fig 7
Fig 8
Fig 9
Fig 10
Fig 11
Fig 12
Fig 13

Similar content being viewed by others

Explore related subjects

Discover the latest articles, news and stories from top researchers in related subjects.

References

  1. K White WL Smith (1994) ArticleTitleThe role of previous radiographs and reports in the interpretation of current radiographs Invest Radiol 29 263–265 Occurrence Handle1:STN:280:ByuB38bpt1c%3D Occurrence Handle8175298

    CAS  PubMed  Google Scholar 

  2. UO Aideyan K Berbaum WL Smith (1995) ArticleTitleInfluence of prior radiologic information on the interpretation of radiographic examinations Acad Radiol 2 205–208 Occurrence Handle1:STN:280:DyaK1c%2FotVyiuw%3D%3D Occurrence Handle9419549

    CAS  PubMed  Google Scholar 

  3. JH Sumkin BL Holbert JS Herrmann CA Hakim MA Ganott WR Poller R Shah LA Hardesty D Gur (2003) ArticleTitleOptimal reference mammography: a comparison of mammograms obtained 1 and 2 years before the present examination Am J Roentgenol 180 343–346

    Google Scholar 

  4. MG Thurfjell B Vitak E Azavedo G Svane E Thurfjell (2000) ArticleTitleEffect of sensitivity and specificity of mammography screening with or without comparison of old mammograms Acta Radiol 41 52–56 Occurrence Handle10.1080/028418500127345884 Occurrence Handle1:STN:280:DC%2BD3c7islKgtQ%3D%3D Occurrence Handle10665871

    Article  CAS  PubMed  Google Scholar 

  5. CL Christiansen F Wang MB Barton W Kreuter JG Elmore AE Gelfand SW Fletcher (2000) ArticleTitlePredicting the cumulative risk of false-positive mammograms J Natl Cancer Inst 92 1657–1666 Occurrence Handle10.1093/jnci/92.20.1657 Occurrence Handle1:STN:280:DC%2BD3M%2FhvVagsw%3D%3D Occurrence Handle11036111

    Article  CAS  PubMed  Google Scholar 

  6. InstitutionalAuthorNameAmerican College of Radiology (2001) ACR Standard for Communication: Diagnostic Radiology American College of Radiology Reston, VA

    Google Scholar 

  7. InstitutionalAuthorNameAmerican College of Radiology (2001) ACR Standard for the Performance of Pediatric and Adult Chest Radiography American College of Radiology Reston, VA

    Google Scholar 

  8. MP Callaway CR Boggis SA Astley I Hutt (1997) ArticleTitleThe influence of previous films on screening mammographic interpretation and detection of breast carcinoma Clin Radiol 52 527–529 Occurrence Handle1:STN:280:ByiA1c3nt1Y%3D Occurrence Handle9240705

    CAS  PubMed  Google Scholar 

  9. LG Quekel R Goei AG Kessels JM Engelshoven Particlevan (2001) ArticleTitleDetection of lung cancer on the chest radiograph: impact of previous films, clinical information, double reading, and dual reading J Clin Epidemiol 54 1146–1150 Occurrence Handle10.1016/S0895-4356(01)00382-1 Occurrence Handle1:STN:280:DC%2BD3MrmvVSitQ%3D%3D Occurrence Handle11675166

    Article  CAS  PubMed  Google Scholar 

  10. TE Wilson VK Nijhawan MA Helvie (1996) ArticleTitleNormal mammograms and the practice of obtaining previous mammograms: usefulness and costs Radiology 198 661–663 Occurrence Handle1:STN:280:BymC1MvgslQ%3D Occurrence Handle8628851

    CAS  PubMed  Google Scholar 

  11. LW Bassett B Shayestehfar I Hirbawi (1994) ArticleTitleObtaining previous mammograms for comparison: usefulness and costs Am J Roentgenol 163 1083–1086 Occurrence Handle1:STN:280:ByqD28jks1Y%3D

    CAS  Google Scholar 

  12. DS Channin (2001) ArticleTitleIs it time for ‘PACSter’? J Digit Imaging 14 52–53 Occurrence Handle10.1007/s10278-001-0002-3 Occurrence Handle1:STN:280:DC%2BD38%2FhslSitg%3D%3D Occurrence Handle11440254

    Article  CAS  PubMed  Google Scholar 

  13. PM Ooijen ParticleVan AH Bongaerts R Witkamp A Wijker W Tukker M Oudkerk (2004) ArticleTitleMulti-detector computed tomography and 3-dimensional imaging in a multi-vendor picture archiving and communications systems (PACS) environment Acad Radiol 11 649–660 Occurrence Handle15172367

    PubMed  Google Scholar 

  14. BI Reiner EL Siegel FJ Hooper S Pomerantz A Dahlke D Rallis (2001) ArticleTitleRadiologists' productivity in the interpretation of CT scans: a comparison of PACS with conventional film Am J Roentgenol 176 861–864 Occurrence Handle1:STN:280:DC%2BD3M3hslaiug%3D%3D

    CAS  Google Scholar 

  15. CC Berry (1990) ArticleTitleA tutorial on confidence intervals for proportions in diagnostic radiology Am J Roentgenol 154 477–480 Occurrence Handle1:STN:280:By%2BC28vjtVE%3D

    CAS  Google Scholar 

  16. R Hustinx F Benard A Alavi (2002) ArticleTitleWhole-body FDG-PET imaging in the management of patients with cancer Semin Nucl Med 32 35–46 Occurrence Handle11839068

    PubMed  Google Scholar 

  17. PN Cascade L Berlin (1999) ArticleTitleMalpractice issues in radiology: American College of Radiology Standard for Communication Am J Roentgenol 173 1439–1442 Occurrence Handle1:STN:280:DC%2BD3c%2FkvFCksQ%3D%3D

    CAS  Google Scholar 

  18. L Berlin (1999) ArticleTitleComparing new radiographs with those obtained previously Am J Roentgenol 172 3–6 Occurrence Handle1:STN:280:DyaK1M7gtlyjsA%3D%3D

    CAS  Google Scholar 

  19. L Berlin (2000) ArticleTitleMust new radiographs be compared with all previous radiographs, or only with the most recently obtained radiographs? Am J Roentgenol 174 611–615 Occurrence Handle1:STN:280:DC%2BD3c7mtlGgsA%3D%3D

    CAS  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Radiology, University of Pennsylvania, Philadelphia, PA, USA

    Paras Lakhani M.D., Alberto F. Goldszal Ph.D. & Curtis P. Langlotz M.D., Ph.D.

  2. Hx Technologies Inc., Philadelphia, PA, USA

    Elliot D. Menschik M.D., Ph.D. & Joseph P. Murray M.S.

  3. Department of Medicine, University of Pennsylvania, Philadelphia, PA, USA

    Mark G. Weiner M.D.

  4. 719 Iron Post Road, Moorestown, NJ, 08057, USA

    Curtis P. Langlotz M.D., Ph.D.

Authors
  1. Paras Lakhani M.D.
    View author publications

    You can also search for this author inPubMed Google Scholar

  2. Elliot D. Menschik M.D., Ph.D.
    View author publications

    You can also search for this author inPubMed Google Scholar

  3. Alberto F. Goldszal Ph.D.
    View author publications

    You can also search for this author inPubMed Google Scholar

  4. Joseph P. Murray M.S.
    View author publications

    You can also search for this author inPubMed Google Scholar

  5. Mark G. Weiner M.D.
    View author publications

    You can also search for this author inPubMed Google Scholar

  6. Curtis P. Langlotz M.D., Ph.D.
    View author publications

    You can also search for this author inPubMed Google Scholar

Corresponding author

Correspondence to Curtis P. Langlotz M.D., Ph.D..

Rights and permissions

Reprints and permissions

About this article

Cite this article

Lakhani, P., Menschik, E.D., Goldszal, A.F. et al. Development and Validation of Queries Using Structured Query Language (SQL) to Determine the Utilization of Comparison Imaging in Radiology Reports Stored on PACS. J Digit Imaging 19, 52–68 (2006). https://doi.org/10.1007/s10278-005-7667-y

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10278-005-7667-y

Key words