dqhdpppm02183 2016-07-19 03:08
浏览 300
已采纳

如何构建一个dicom数据库

language: php database: mysql.

I have searched for some files about dicom database, but it just doesn't tell me a simple example.

Here are some I summarized: simple database 5 tables:

  1. patient(patientid to be the major key)
  2. study(study instance UID to be the major key)
  3. series(series instance UID to be the major key)
  4. image(image instance UID to be the major key)
  5. link the four tables'major key and write into this table, and of course the .dcm files will be stored in the server folder

So do I need to modify somewhere if you think it's wrong? Are there some key data I've already missed? Thanks!

  • 写回答

1条回答 默认 最新

  • donglongqiao9595 2016-07-19 05:55
    关注

    The patient id is not proper key, because it is not an unique identifier.

    Study, Series, Image UID are unique and would work as key, but in view of performance it is may be not the best choice, because it is simply a too long string.

    You should think about an internal assigned (auto-incremental) key.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 为什么apriori的运行时间会比fp growth的运行时间短呢
  • ¥15 帮我解决一下膳食平衡的线性规划模型的数据实例
  • ¥40 万年历缺少农历,需要和阳历同时显示
  • ¥250 雷电模拟器内存穿透、寻基址和特征码的教学
  • ¥200 比特币ord程序wallet_constructor.rs文件支持一次性铸造1000个代币,并将它们分配到40个UTXO上(每个UTXO上分配25个代币),并设置找零地址
  • ¥15 关于Java的学习问题
  • ¥15 如何使用chatgpt完成文本分类任务?
  • ¥15 已知速度v关于位置s的等式,怎么转化为已知位置求速度v的等式
  • ¥15 我有个餐饮系统,用wampserver把环境配置好了,但是后端的网页却进去,是为什么,能不能帮远程一下?
  • ¥15 R运行没有名称为"species"的插槽对于此对象类"SDMmodelCV"