Import additional DICOM tags into MySQL

[twellma]

Is it possible to import additional DICOM tags to the MySQL database so that more complex queries can be formulated?

For our R&D activities, we want to store annotation and image data (DICOM tags) in the same MySQL database. With the additional DICOM tags we want to select cases based on annotation and technical information. One example would be "SELECT all breast MR cases WHERE flip angle = 10 AND slice thickness < 1mm AND contains malignant tumor".
It would be nice to have a configuration fine in which the user can specify which DICOM tags should be stored in the MySql database.

Thanks for your support!

Thorsten

[pacsone]

It is certainly possible to parse information from Dicom tags of the received images, but it seems to be more difficult to determine which informational model level, e.g., patient, study, series or instance, the parsed information should be stored, as they usually depend on the particular Dicom tag from which the information is extracted.

[twellma]

We are mostly interested in querying technical information like resolution, reconstruction kernel, flip angle, relaxation time etc. These tags usually make only sense on the series level.

[pacsone]

You can send us (mailto:pacsone@pacsone.net) a list of such Dicom tags along with the preferred level of information model where the tag should belong, and we'll try to add it to a future release of PacsOne Server.