A PACS archive server database structure enabling flexible queries

被引:1
|
作者
Shen, SZ [1 ]
Yaffe, M [1 ]
Chen, ZM [1 ]
Mawdsley, G [1 ]
机构
[1] Sunnybrook & Womens Coll, Hlth Sci Ctr, Toronto, ON M4N 3M5, Canada
来源
MEDICAL IMAGING 2003: PACS AND INTEGRATED MEDICAL INFORMATION SYSTEMS: DESIGN AND EVALUATION | 2003年 / 5033卷
关键词
DICOM server; DICOM database design; DICOM database configuration; DICOM database performance;
D O I
10.1117/12.480461
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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.
引用
收藏
页码:370 / 374
页数:5
相关论文
共 41 条
  • [21] PUDGE: a flexible, interactive server for protein structure prediction
    Norel, Raquel
    Petrey, Donald
    Honig, Barry
    NUCLEIC ACIDS RESEARCH, 2010, 38 : W550 - W554
  • [22] A fault tolerant 300 GB raid server and 2 TB tape jukebox PACS archive for under $20k
    Wendt, GJ
    Nagy, PG
    Peppler, WW
    Kahn, C
    Ehlers, K
    RADIOLOGY, 2001, 221 : 152 - 152
  • [23] FATCAT: a web server for flexible structure comparison and structure similarity searching
    Ye, YZ
    Godzik, A
    NUCLEIC ACIDS RESEARCH, 2004, 32 : W582 - W585
  • [24] Database Queries for Hospitalizations for Acute CHF: Flexible Methods and Validation Based on Set Theory
    Rosenman, Marc
    He, Jinghua
    Martin, Joel
    Nutakki, Kavitha
    Eckert, George
    Lane, Kathleen
    Gradus-Pizlo, Irmina
    Hui, Siu L.
    PHARMACOEPIDEMIOLOGY AND DRUG SAFETY, 2013, 22 : 269 - 270
  • [25] Database searching by flexible protein structure alignment
    Ye, YZ
    Godzik, A
    PROTEIN SCIENCE, 2004, 13 (07) : 1841 - 1850
  • [26] ViroBLAST: a stand-alone BLAST web server for flexible queries of multiple databases and user's datasets
    Deng, Wenjie
    Nickle, David C.
    Learn, Gerald H.
    Maust, Brandon
    Mullins, James I.
    BIOINFORMATICS, 2007, 23 (17) : 2334 - 2336
  • [27] Database queries for hospitalizations for acute congestive heart failure: flexible methods and validation based on set theory
    Rosenman, Marc
    He, Jinghua
    Martin, Joel
    Nutakki, Kavitha
    Eckert, George
    Lane, Kathleen
    Gradus-Pizlo, Irmina
    Hui, Siu L.
    JOURNAL OF THE AMERICAN MEDICAL INFORMATICS ASSOCIATION, 2014, 21 (02) : 345 - 352
  • [28] An analysis of compounds in HPSG (head-driven phrase structure grammar) for database queries
    McFetridge, P
    Popowich, F
    Fass, D
    DATA & KNOWLEDGE ENGINEERING, 1996, 20 (02) : 195 - 209
  • [29] A FLEXIBLE INDEXING STRUCTURE SUPPORTING MULTIATTRIBUTE DATABASE APPLICATIONS - MAIN
    KIM, B
    MOON, S
    MICROPROCESSING AND MICROPROGRAMMING, 1993, 39 (2-5): : 177 - 180
  • [30] mTM-align: a server for fast protein structure database search and multiple protein structure alignment
    Dong, Runze
    Pan, Shuo
    Peng, Zhenling
    Zhang, Yang
    Yang, Jianyi
    NUCLEIC ACIDS RESEARCH, 2018, 46 (W1) : W380 - W386