Mr. Sam Zhongmin Shen Profile

Sam Zhongmin Shen

Medical Physicist at Sunnybrook & Womens College

SPIE Involvement:

Author

Publications (1)

This will count as one of your downloads.

You will have access to both the presentation and article (if available).

DOWNLOAD NOW

This content is available for download via your institution's subscription. To access this item, please sign in to your personal account.

Email or Username Forgot your username?

Password Forgot your password?

Show

Keep me signed in

No SPIE account? Create an account

Proceedings Article | 19 May 2003 Paper

PACS archive server database structure enabling flexible queries

Sam Shen, Martin Yaffe, Zhongming Chen, Gordon Mawdsley

Proceedings Volume 5033, (2003) https://doi.org/10.1117/12.480461

KEYWORDS: Databases, Picture Archiving and Communication System, Data modeling, Image filtering, Molybdenum, Statistical modeling, Medical imaging, Health sciences, Magnesium, Computing systems

Read Abstract +

An innovative DICOM meta information database has been developed to support PACS archive servers. Contrary to mainstream designs using a relational database with one table for each information level (namely: patient, study, series, image), we present a boolean-based design that supports the same information model with one table. In this table, the data are stored with the DICOM tags and auxiliary indices required for the information model. Each representative value in a DICOM data set is stored as a record in the table. When a new SOP Class is added, it is unnecessary to rebuild the entire database because no new columns are needed in the table. The new tag, i.e. new information, is added into the table as an additional record. With our current implementation of this model, the same query is typically almost as fast as the 4-table design. In tests using simulated data with a server holding 10,000 patients, each with 2 studies and 2 series of images, it takes less than 6 seconds to query all the patient names starting with “B” on our new database. It takes 5 seconds on a comparable server using the 4 table design. Searching for a value at image level requires a similar amount of time, depending on the amount of data returned.

My Library

You currently do not have any folders to save your paper to! Create a new folder below.

Folder Name

Folder Description

View contact details

UPDATE YOUR PROFILE

Is this your profile? Update it now.

Sign into your SPIE.org account

Don’t have a profile and want one?

Create an account on SPIE.org

Access to the requested content is limited to institutions that have purchased or subscribe to SPIE eBooks. You are receiving this notice because your organization may not have SPIE eBooks access.*

*Shibboleth/Open Athens users─please sign in to access your institution's subscriptions.

To obtain this item, you may purchase the complete book in print or electronic format on SPIE.org.

ORGANIZATIONAL
Sign in with credentials provided by your organization.

Organizational Username

Organizational Password

Show/Hide Password

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available

Members:

Non-members: ADD TO CART

Keywords/Phrases

Search In:

Publication Years