472,133 Members | 1,488 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,133 software developers and data experts.

Triggers to a remote database

Hello all!

We make use of a PACS (Picture Archiving and Communication System) and
system to store DICOM (Digital Imaging and Communication in Medicine)
images (like CT scans, MR images etc.) in our Oncology Center. This PACS
system uses mysql as it's native database, in which it stores certain
data as date and time of the examination, it uses InnoDB tables.

We are building another application around it, which will use data from
the PACS tables and will hold additional data in a seperate database in
it's own tables.

Every study has it's own unique identifier which is stored in the PACS
database. Additional data is stored in the additional database, under
the same unique identifier to be able to keep track of the data and link
it to each other.

Now I would like to know if it is possible to add a trigger to the PACS
database which will delete the related information in the additional
database if a record in the PACS database is dropped. This trigger will
have to delete the records in the additional tables before dropping the
data in it's own database, so we can maintain a more compact database
and don't store data which we cannot link to the PACS system anymore.

Hope someone can help me.

Thanks in advance,

Jul 31 '06 #1
0 2418

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by jason_s_ford | last post: by
7 posts views Thread by ajomara | last post: by
reply views Thread by debasisdas | last post: by
4 posts views Thread by --CELKO-- | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.