Vinith Raj

Engineering reliable systems that help people do meaningful work.

  • About me
  • Articles
  • Contact me

JSONB

From Schemaless DICOM Metadata to Clinician-Friendly Relational Tables in PostgreSQL

December 17, 2025 / Leave a Comment

Introduction In a previous article, we explored a zero-code approach to storing DICOM metadata by persisting vendor-specific and modality-specific tags as JSONB in an extradicomtags column. This approach embraces the reality of clinical imaging data: the schema is heterogeneous, nested, and constantly evolving. By storing the raw metadata as a JSON document and applying GIN … [Read more…]

Posted in: Articles, DICOM modeling, Healthcare Data Architecture, Medical Imaging Infrastructure, metadata, normalization, Research Computing Infrastructure, schemas Tagged: Clinical Data Engineering, Clinical Research Infrastructure, Data Platforms, Database Normalization, DICOM, DICOM Metadata, GIN Index, Healthcare Analytics, Healthcare IT, JSONB, Medical Data Platforms, Medical Imaging Data, PL/pgSQL, PostgreSQL, Radiation Oncology, Relational Schema Design, Research Computing, Research Data Systems, SQL Data Modeling