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 Digital Imaging

Volumn 19, Issue 1, 2006, Pages 52-68

  Lakhani, Paras ^a   Menschik, Elliot D ^b   Goldszal, Alberto F ^a   Murray, Joseph P ^b   Weiner, Mark G ^a   Langlotz, Curtis P ^a,c  

^a UNIVERSITY OF PENNSYLVANIA   (United States)

^b HxTechnologies   (United States)

^c NONE   (United States)

Author keywords

Databases; Query; Structured query language (SQL)

Indexed keywords

ITERATIVE METHODS; MEDICAL IMAGING; RADIOLOGY;

QUERY ACCURACY; RANDOM SAMPLES; STRUCTURED QUERY LANGUAGE (SQL);

QUERY LANGUAGES;

ARTICLE; COMPARATIVE STUDY; DATA BASE; DIAGNOSTIC ACCURACY; DIGITAL IMAGING; IMAGE ANALYSIS; IMAGE PROCESSING; IMAGING SYSTEM; PRIORITY JOURNAL; RADIOLOGY; SAMPLING; STANDARD; STRUCTURED QUERY LANGUAGE; UTILIZATION REVIEW; VALIDATION PROCESS;

DATABASE MANAGEMENT SYSTEMS; HUMANS; IMAGE PROCESSING, COMPUTER-ASSISTED; INFORMATION STORAGE AND RETRIEVAL; NATURAL LANGUAGE PROCESSING; RADIOLOGY INFORMATION SYSTEMS; REPRODUCIBILITY OF RESULTS; SOFTWARE;

EID: 33644918594     PISSN: 08971889     EISSN: 1618727X     Source Type: Journal    
DOI: 10.1007/s10278-005-7667-y     Document Type: Article

References (19)

1. K White WL Smith 1994 The role of previous radiographs and reports in the interpretation of current radiographs Invest Radiol 29 263 265
2. UO Aideyan K Berbaum WL Smith 1995 Influence of prior radiologic information on the interpretation of radiographic examinations Acad Radiol 2 205 208
3. JH Sumkin BL Holbert JS Herrmann CA Hakim MA Ganott WR Poller R Shah LA Hardesty D Gur 2003 Optimal reference mammography: a comparison of mammograms obtained 1 and 2 years before the present examination Am J Roentgenol 180 343 346
4. MG Thurfjell B Vitak E Azavedo G Svane E Thurfjell 2000 Effect of sensitivity and specificity of mammography screening with or without comparison of old mammograms Acta Radiol 41 52 56
5. CL Christiansen F Wang MB Barton W Kreuter JG Elmore AE Gelfand SW Fletcher 2000 Predicting the cumulative risk of false-positive mammograms J Natl Cancer Inst 92 1657 1666
6. American College of Radiology 2001 ACR Standard for Communication: Diagnostic Radiology American College of Radiology Reston, VA
7. American College of Radiology 2001 ACR Standard for the Performance of Pediatric and Adult Chest Radiography American College of Radiology Reston, VA
8. MP Callaway CR Boggis SA Astley I Hutt 1997 The influence of previous films on screening mammographic interpretation and detection of breast carcinoma Clin Radiol 52 527 529
9. LG Quekel R Goei AG Kessels JM van Engelshoven 2001 Detection of lung cancer on the chest radiograph: impact of previous films, clinical information, double reading, and dual reading J Clin Epidemiol 54 1146 1150
10. TE Wilson VK Nijhawan MA Helvie 1996 Normal mammograms and the practice of obtaining previous mammograms: usefulness and costs Radiology 198 661 663
11. LW Bassett B Shayestehfar I Hirbawi 1994 Obtaining previous mammograms for comparison: usefulness and costs Am J Roentgenol 163 1083 1086
12. DS Channin 2001 Is it time for 'PACSter'? J Digit Imaging 14 52 53
13. PM Van Ooijen AH Bongaerts R Witkamp A Wijker W Tukker M Oudkerk 2004 Multi-detector computed tomography and 3-dimensional imaging in a multi-vendor picture archiving and communications systems (PACS) environment Acad Radiol 11 649 660
14. BI Reiner EL Siegel FJ Hooper S Pomerantz A Dahlke D Rallis 2001 Radiologists' productivity in the interpretation of CT scans: a comparison of PACS with conventional film Am J Roentgenol 176 861 864
15. CC Berry 1990 A tutorial on confidence intervals for proportions in diagnostic radiology Am J Roentgenol 154 477 480
16. R Hustinx F Benard A Alavi 2002 Whole-body FDG-PET imaging in the management of patients with cancer Semin Nucl Med 32 35 46
17. PN Cascade L Berlin 1999 Malpractice issues in radiology: American College of Radiology Standard for Communication Am J Roentgenol 173 1439 1442
18. L Berlin 1999 Comparing new radiographs with those obtained previously Am J Roentgenol 172 3 6
19. L Berlin 2000 Must new radiographs be compared with all previous radiographs, or only with the most recently obtained radiographs? Am J Roentgenol 174 611 615