Abstract
In 2010, the DICOM Data Warehouse (DDW) was launched as a data warehouse for DICOM meta-data. Its chief design goals were to have a flexible database schema that enabled it to index standard patient and study information, modality specific tags (public and private), and create a framework to derive computable information (derived tags) from the former items. Furthermore, it was to map the above information to an internally standard lexicon that enables a non-DICOM savvy programmer to write standard SQL queries and retrieve the equivalent data from a cohort of scanners, regardless of what tag that data element was found in over the changing epochs of DICOM and ensuing migration of elements from private to public tags. After 5 years, the original design has scaled astonishingly well. Very little has changed in the database schema. The knowledge base is now fluent in over 90 device types. Also, additional stored procedures have been written to compute data that is derivable from standard or mapped tags. Finally, an early concern is that the system would not be able to address the variability DICOM-SR objects has been addressed. As of this writing the system is indexing 300 MR, 600 CT, and 2000 other (XA, DR, CR, MG) imaging studies per day. The only remaining issue to be solved is the case for tags that were not prospectively indexed—and indeed, this final challenge may lead to a noSQL, big data, approach in a subsequent version.
Similar content being viewed by others
References
Langer SG: A flexible database architecture for mining DICOM objects: the DICOM data warehouse”. JDI 25(2):206–212, 2012
Wang S, Pavlicek W, Roberts CC, Langer SG, Zhang M, Hu M, Morin RL, Schueler BA, Wellnitz CV, Wu T: An automated DICOM database capable of arbitrary data mining (including radiation dose indicators) for quality monitoring. JDI 24(2):223–33, 2011
Langer SG, Tellis W, Carr C, Daly M, Erickson BJ, Mendelson D, Moore S, Perry J, Shastri K, Warnock M, Zhu W: The RSNA image sharing network. JDI 28(1):53–61, 2015. doi:10.1007/s10278-014-9714-z
DDW at https://github.com/sglanger/ddw . last viewed June 2015.
Langer SG: Challenges for data storage in medical imaging research. J Digit Imaging 24(2):203–7, 2011. doi:10.1007/s10278-010-9311-8
Rascovsky SJ, Delgado JA, Sanz A, Calvo VD: Castrillón G. Informatics in radiology: use of CouchDB for document-based storage of DICOM objects. Radiographics 32(3):913–27, 2012. doi:10.1148/rg.323115049
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Langer, S.G. DICOM Data Warehouse: Part 2. J Digit Imaging 29, 309–313 (2016). https://doi.org/10.1007/s10278-015-9830-4
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10278-015-9830-4