AJR ARRS Member Benefits
HOME HELP FEEDBACK SUBSCRIPTIONS ARCHIVE SEARCH TABLE OF CONTENTS
 QUICK SEARCH:   [advanced]


     


This Article
Right arrow Abstract Freely available
Right arrow Figures Only
Right arrow Full Text (PDF)
Right arrow Alert me when this article is cited
Right arrow Alert me if a correction is posted
Right arrow Citation Map
Services
Right arrow Email this article to a friend
Right arrow Similar articles in this journal
Right arrow Similar articles in PubMed
Right arrow Alert me to new issues of the journal
Right arrow Download to citation manager
Right arrow reprints & permissions
Citing Articles
Right arrow Citing Articles via HighWire
Right arrow Citing Articles via Google Scholar
Google Scholar
Right arrow Articles by Tran, T. H. D.
Right arrow Articles by Thune, M.
Right arrow Search for Related Content
PubMed
Right arrow PubMed Citation
Right arrow Articles by Tran, T. H. D.
Right arrow Articles by Thune, M.
Social Bookmarking
 Add to CiteULike   Add to Complore   Add to Connotea   Add to Del.icio.us   Add to Digg   Add to Reddit   Add to Technorati  
What's this?
AJR 2000; 175:325-327
© American Roentgen Ray Society


Computers in Radiology

Creating a Digital Radiographic Teaching File and Database Using a PC and Common Software

Thomas Hien Dieu Tran1, Neil A. Roach2, Patrick L. O'Kane2 and Michael Thune2,3

1 Department of Medical Education, Frankford Hospital Health System, 2412 Ashwood Ave., Philadelphia, PA 19154.
2 Department of Diagnostic Imaging, Temple University, Broad and Ontario Sts., Philadelphia, PA 19140.
3 Present address: Department of Radiology, Southampton Hospital, 240 Meeting House Ln., Southampton, NY 11968.

Received August 16, 1999; accepted after revision January 4, 2000.

 
Address correspondence to N. A. Roach.


Abstract
Top
Abstract
Introduction
Materials and Methods
Discussion
References
 
OBJECTIVE. We wanted to design an inexpensive, convenient database to store digital radiographic images of multiple formats.

CONCLUSION. We designed a database that could be saved in a standard format using readily available software. Users of our database can save images in a Joint Photographic Experts Group (JPEG) format, allowing their easy incorporation into other programs.


Introduction
Top
Abstract
Introduction
Materials and Methods
Discussion
References
 
Maintaining a collection of radiographic teaching images is cumbersome and expensive. Recent advances in digital diagnostic imaging and filmless radiography offer the potential for a better method of maintaining such a collection [1].

We created a cost-effective database of radiographic teaching images using a PC. The database allows the incorporation of the actual images. Previous databases contained only relevant statistical information and referenced images that were not saved in the databases. Using available resources, our database allows the input of digital images and relevant information associated with the images (i.e., the patient's sex, age, history, and diagnosis). The complete database can be saved on a transportable, standard medium such as a Zip disk (Iomega, Roy, UT) or a CD-ROM [2]. Our images were saved in a standard Joint Photographic Experts Group (JPEG) format to allow their incorporation into other computer applications, such as presentation programs, word processing programs, or Web page design programs [3].


Materials and Methods
Top
Abstract
Introduction
Materials and Methods
Discussion
References
 
Our digital radiographic images were gathered with an AFGA IMPAX (AGFA-Gevaert, Mortsel, Belgium) digital imaging system. The images were in Digital Imaging and COmmunications in Medicine (DICOM) format and converted to either bitmap or tagged image file format (TIFF) by AGFA CS5000 software. The final resolution of the images depends on the monitor and the video card installed in the computer used to display the images. For example, our desktop monitor had a resolution of 800 x600 pixels.

On a PC, the images were converted to either a JPEG format or graphical interchange format (GIF) using Adobe Photoshop version 5.0 (Adobe, San Jose, CA). We generally preferred the JPEG images over the GIF images because the JPEG images were subjectively of the same quality as the GIF images but used approximately 10% less memory. Although, in theory, JPEG is a lossy compression system, it did not detract from visible image quality (in fact, the American College of Radiology learning file CDs use the JPEG format). Additionally, our database allows images to be saved as TIFFs if necessary.

We adjusted the gray-scale values of our images with Adobe Photoshop software. It is possible to re-adjust the gray-scale values while viewing the images in photograph-editing software. Images embedded in the database can be copied from the database by extracting them or using the copy-paste feature; these tasks do not degrade the images.

Our database was designed on a PC equipped with the following software: Windows NT Workstation version 4.0 (Microsoft, Redmond, WA), Microsoft Office 97 (Microsoft), and Adobe Photoshop. The PC had a Pentium (Intel, Santa Clara, CA) 166-MHz microprocessor, 64 MB of random access memory, a 4-MB video card, a 9-GB hard drive, a 100-MB internal Zip drive (Iomega), and an internal CD-ROM Writer 7200 Series (Hewlett-Packard, Loveland, CO).

Our database was created using Microsoft Access 97 (Microsoft) with the following fields: patient's last name, patient's first name, date of birth, date of study, sex, age on date of study, history, diagnosis, other diagnoses, referring physician, location of study (e.g., hospital, outpatient clinic), image package, order of images in series, medical record number, modality of study, American College of Radiology code, and anatomic region. The database was intentionally designed with many fields so that users could enter large amounts of information and have greater flexibility when submitting queries. Examples of how the database works in practice are shown in Figures 1 and 2. Figure 3 shows a radiographic image from the database. Figure 4 shows the database design view of table 1 from Figure 1. The data type for all fields was text except for the age, date, and image fields. The data type for the age field was a number; the data type for the date fields was date/time; and the data type for the image field was object linking and embedding object (required format).



View larger version (114K):
[in this window]
[in a new window]
[as a PowerPoint slide]
 
Fig. 1. —Screen capture of database table created with embedded image of patient with aspergilloma. (Reprinted with permission from Microsoft [Redmond, WA])

 


View larger version (89K):
[in this window]
[in a new window]
[as a PowerPoint slide]
 
Fig. 2. —Screen capture of query to database, searching for patient with aspergilloma. (Reprinted with permission from Microsoft [Redmond, WA])

 


View larger version (150K):
[in this window]
[in a new window]
[as a PowerPoint slide]
 
Fig. 3. —Radiograph of 45-year-old woman with aspergilloma.

 


View larger version (88K):
[in this window]
[in a new window]
[as a PowerPoint slide]
 
Fig. 4. —Screen capture shows database design view of Table 1. Note that data type for image field must be Object Linking and Embedding object. (Reprinted with permission from Microsoft [Redmond, WA])

 

To view images in a database created with Microsoft Access, the graphic filters for Microsoft Access should be installed during the initial installation of Microsoft Office [4]. If in doubt as to whether this was done, simply reinstall Microsoft Office and choose all the features of the "Custom" installation (instead of the "Typical" installation).


Discussion
Top
Abstract
Introduction
Materials and Methods
Discussion
References
 
Once information has been entered, the system allows the user to take advantage of the strengths of an electronic database. For example, a search can be generalized by disease entity or restricted to images of a specific diagnosis in a specific group of patients. Figure 2 shows a screen capture of a query result. Additionally, a report can be generated on the basis of search parameters. The advantage of storing images in a database is the flexibility with which the database can be queried. After assigning information to the images in each data record, a query can be submitted to obtain images using general or specific criteria.

An alternative method of organizing data is to place items in a directory hierarchy. However, this type of system tends to become unwieldy as the number of images increases. In a large image collection, the user may have to browse through many layers to find the image needed. Additionally, one can get lost in the many sublayers of a hierarchy.

The decision to use JPEG images, despite their lossy format, was a practical one. TIFF, GIF, or bitmap files are larger and use more memory. Nevertheless, our database can accommodate multiple image types; therefore, if an abnormality can be seen only on a TIFF image, we can leave it in TIFF format.

JPEG images have the additional advantage of being transportable to other desktop computer applications. Word processing programs could incorporate the images in a written document such as a radiology report. The images could also be inserted in a presentation program for a slide show. Furthermore, JPEG is one of two standard formats used for images appearing on the Internet (GIF being the other). Having the images in JPEG format allows easy incorporation into a Web page. Web programs that allow easy conversion of existing databases to server side format are also available (Cold Fusion; Allaire, Cambridge, MA).

We stored 50 JPEG radiographic images of 10 patients with relevant information in our database. This database used 14 MB of storage space and was backed up on a Zip disk. Therefore, with a 640-MB CD-ROM, approximately 2000 images could be stored.

Using a CD as a storage medium has obvious advantages. First, a CD is portable. A 1-oz CD containing 2000 images is easier to transport and store than 2000 images printed on film. Additionally, locating images is easier on CD than in a file cabinet. A CD can be used in almost every PC, even a laptop. Finally, the cost of collecting teaching images on a CD is only a fraction of that of maintaining the same images on film. For example, most of the expense of storing digital images on a CD is the initial cost of computer hardware and software: users of our database would need to purchase a PC ($600), monitor ($200), CD-Writer ($200), Zip drive ($100), Microsoft Windows NT ($300), Microsoft Office ($500), Adobe Photoshop ($550), and one CD ($2), for a total of $2452 [5]. The cost of printing 2000 images on film would total $3420 (2000 x $1.71 per film [price of one AGFA 14 x 17 inch film purchased in bulk from a local vendor]). Therefore, in the long run, the overall cost of printing 2000 radiographic images and storing them far exceeds that of storing 2000 images on one CD.

We succeeded in creating an inexpensive electronic database of digital radiographic teaching images using commercially available software. We also showed the cost-effectiveness of storing a collection of radiographic images on a CD-ROM using a commercially available system that allows access on most PCs. Additionally, because the images are stored in a conventional JPEG format, they can be easily incorporated into other computer applications for word processing, presentations, and Web page design.


Acknowledgments
 
We thank Nancy Washburne for her assistance in the preparation of this article.


References
Top
Abstract
Introduction
Materials and Methods
Discussion
References
 

  1. Richardson ML, Gillespy T. An inexpensive computer-based digital imaging teaching file. AJR 1993;160:1299 -1301[Abstract/Free Full Text]
  2. Nayler J. A clinical image library using PhotoCD. J Audiov Media Med 1998;21:99 -103[Medline]
  3. Khorasani R, Lester JM, Davis SD, et al. Web-based digital radiology teaching file: facilitating case input at time of interpretation. AJR 1998;170:1165 -1167[Abstract/Free Full Text]
  4. Kaufeld J. Access 97 for Windows for Dummies. Foster City, CA: IDG Books Worldwide, 1996
  5. PC-Magazine. Ziff-Davis, Advertisements 18:12 June 22, 1999

Add to CiteULike CiteULike   Add to Complore Complore   Add to Connotea Connotea   Add to Del.icio.us Del.icio.us   Add to Digg Digg   Add to Reddit Reddit   Add to Technorati Technorati    What's this?


This article has been cited by other articles:


Home page
RadioGraphicsHome page
N. Nakata, S. Kandatsu, N. Suzuki, and K. Fukuda
Informatics in Radiology (infoRAD): Mobile Wireless DICOM Server System and PDA with High-Resolution Display: Feasibility of Group Work for Radiologists
RadioGraphics, January 1, 2005; 25(1): 273 - 283.
[Abstract] [Full Text] [PDF]


Home page
Am. J. Roentgenol.Home page
C.-S. Yam, J. Kruskal, A. Sitek, and M. Larson
A Web-Based ACR Index for Radiological Diagnoses
Am. J. Roentgenol., November 1, 2004; 183(5): 1517 - 1521.
[Abstract] [Full Text] [PDF]


Home page
RadioGraphicsHome page
A. Rosset, O. Ratib, A. Geissbuhler, and J.-P. Vallee
Integration of a Multimedia Teaching and Reference Database in a PACS Environment
RadioGraphics, November 1, 2002; 22(6): 1567 - 1577.
[Abstract] [Full Text] [PDF]


Home page
RadioGraphicsHome page
R. D. Ernst, B. R. Baumgartner, E. P. Tamm, and W. E. Torres
Development of a Teaching File by Using a DICOM Database
RadioGraphics, January 1, 2002; 22(1): 217 - 221.
[Abstract] [Full Text] [PDF]


Home page
J. Nucl. Med. Technol.Home page
E. Robinson and W.-J. Shih
Making Slides of Nuclear Medicine Images Using a Scanner, Personal Computer, Commercial Software, and a Laser Graphic Printer
J. Nucl. Med. Technol., March 1, 2001; 29(1): 46 - 49.
[Abstract] [Full Text]


This Article
Right arrow Abstract Freely available
Right arrow Figures Only
Right arrow Full Text (PDF)
Right arrow Alert me when this article is cited
Right arrow Alert me if a correction is posted
Right arrow Citation Map
Services
Right arrow Email this article to a friend
Right arrow Similar articles in this journal
Right arrow Similar articles in PubMed
Right arrow Alert me to new issues of the journal
Right arrow Download to citation manager
Right arrow reprints & permissions
Citing Articles
Right arrow Citing Articles via HighWire
Right arrow Citing Articles via Google Scholar
Google Scholar
Right arrow Articles by Tran, T. H. D.
Right arrow Articles by Thune, M.
Right arrow Search for Related Content
PubMed
Right arrow PubMed Citation
Right arrow Articles by Tran, T. H. D.
Right arrow Articles by Thune, M.
Social Bookmarking
 Add to CiteULike   Add to Complore   Add to Connotea   Add to Del.icio.us   Add to Digg   Add to Reddit   Add to Technorati  
What's this?


HOME HELP FEEDBACK SUBSCRIPTIONS ARCHIVE SEARCH TABLE OF CONTENTS