DCMQRSCP and SQL

[fanying]

This is a continuation from the post

viewtopic.php?p=12728#12728

about DCMQRSCP and ON_THE_FLY_COMPRESSION.

A response by J. Riesmeier stated about integrating DCMQRSCP with SQL. However since that was not related with ON_THE_FLY_COMPRESSION, I believe that will be best done on a separate post.

I do wish to say that our organization has already implemented SQL integration into DCMQRSCP have been successfully using it since 2006.

Here are the details of the software setup.

* Customized version of DCMTK version 3.5.4, the latest at the time.
* PostgreSQL version 8.0.1, since upgraded to PostgreSQL 8.4.0
* libpqxx version 2.6.8, must be 2.6.8 since we had problems with later versions.
* CentOS 5.7 x86_64 Linux distribution

Using this setup here are the dicom repository details.

* ~17 million dicom files on three repositories, all indexed within PostgreSQL
* ~22TB of storage spread over 11 volumes, volumes are not continuous.

With a repository this size would have cost using commercial PACS solutions close to six figures in US dollars with four figures in yearly licensing not to mention vendor interoperability issues.

We would like to contribute our work to the DCMTK and make further progress in DCMTK as a viable alternative to expensive limited commercial PACs systems.[/url]

[J. Riesmeier]

Thank you for your kind offer. Please send the source code with your modifications by email to dicom/at/offis/dot/de.
A patch (showing the differences based on DCMTK 3.5.4) would be the preferred way.

[sumedh_dcm_user]

As of now, is any SQL database backend (alternate to dcmqrdb module) available in dcmtk?

Thank you for your kind offer. Please send the source code with your modifications by email to dicom/at/offis/dot/de.
A patch (showing the differences based on DCMTK 3.5.4) would be the preferred way.

[J. Riesmeier]

No, at least not one that is publicly available from the DCMTK team. There are various SQL backends that are used for commercial products (ICSMED AG), for research projects (OFFIS e.V.) or developed by some students... but as I said none is available to the public.