存储 DICOM Metadata 在 SQL 和 NoSQL 数据库中使用 C#
医学图像应用程序往往需要有效地搜索和查询DICOM的代数据,而DicOM文件存储富有的代码,将其提取到数据库,可以快速查找,分析和与医院信息系统的整合。 为什么 DICOM 存储数据在数据库中? DICOM 文件包含大量的代数据,但搜索数千个文件是缓慢的。 快速查询:按患者、日期、模式或任何属性立即查找研究 分析:报告和统计数据集成 集成:将图像数据连接到EMR/EHR系统 Scalability:以适当的索引处理数百万项研究 全文本搜索:用描述关键词找到研究 DICOM Metadata Extraction 基金会 首先,创建一个将 DICOM 转换为数据库准备的对象的数据提取器: using Aspose.Medical.Dicom; public class DicomMetadataExtractor { public DicomStudyRecord ExtractStudyRecord(string filePath) { DicomFile dicomFile = DicomFile.Open(filePath); var dataset = dicomFile.Dataset; return new DicomStudyRecord { // Identifiers StudyInstanceUID = dataset.GetString(DicomTag.StudyInstanceUID), SeriesInstanceUID = dataset.GetString(DicomTag.SeriesInstanceUID), SOPInstanceUID = dataset.GetString(DicomTag.SOPInstanceUID), AccessionNumber = dataset.GetString(DicomTag.AccessionNumber), // Patient PatientID = dataset.GetString(DicomTag.PatientID), PatientName = dataset.GetString(DicomTag.PatientName), PatientBirthDate = ParseDicomDate(dataset.GetString(DicomTag.PatientBirthDate)), PatientSex = dataset.GetString(DicomTag.PatientSex), // Study StudyDate = ParseDicomDate(dataset.GetString(DicomTag.StudyDate)), StudyTime = dataset.GetString(DicomTag.StudyTime), StudyDescription = dataset.GetString(DicomTag.StudyDescription), ReferringPhysicianName = dataset.GetString(DicomTag.ReferringPhysicianName), // Series Modality = dataset.GetString(DicomTag.Modality), SeriesDescription = dataset.GetString(DicomTag.SeriesDescription), SeriesNumber = ParseInt(dataset.GetString(DicomTag.SeriesNumber)), BodyPartExamined = dataset.GetString(DicomTag.BodyPartExamined), // Image InstanceNumber = ParseInt(dataset.GetString(DicomTag.InstanceNumber)), Rows = ParseInt(dataset.GetString(DicomTag.Rows)), Columns = ParseInt(dataset.GetString(DicomTag.Columns)), // Equipment Manufacturer = dataset.GetString(DicomTag.Manufacturer), InstitutionName = dataset.GetString(DicomTag.InstitutionName), StationName = dataset.GetString(DicomTag.StationName), // File Info FilePath = filePath, FileSize = new FileInfo(filePath).Length, IndexedAt = DateTime.UtcNow }; } private DateTime? ParseDicomDate(string dicomDate) { if (string.IsNullOrEmpty(dicomDate) || dicomDate.Length != 8) return null; if (DateTime.TryParseExact(dicomDate, "yyyyMMdd", null, System.Globalization.DateTimeStyles.None, out var date)) { return date; } return null; } private int? ParseInt(string value) { if (int.TryParse(value, out var result)) return result; return null; } } public class DicomStudyRecord { public string StudyInstanceUID { get; set; } public string SeriesInstanceUID { get; set; } public string SOPInstanceUID { get; set; } public string AccessionNumber { get; set; } public string PatientID { get; set; } public string PatientName { get; set; } public DateTime? PatientBirthDate { get; set; } public string PatientSex { get; set; } public DateTime? StudyDate { get; set; } public string StudyTime { get; set; } public string StudyDescription { get; set; } public string ReferringPhysicianName { get; set; } public string Modality { get; set; } public string SeriesDescription { get; set; } public int? SeriesNumber { get; set; } public string BodyPartExamined { get; set; } public int? InstanceNumber { get; set; } public int? Rows { get; set; } public int? Columns { get; set; } public string Manufacturer { get; set; } public string InstitutionName { get; set; } public string StationName { get; set; } public string FilePath { get; set; } public long FileSize { get; set; } public DateTime IndexedAt { get; set; } } SQL Server 集成 存储在 SQL Server 中使用 Entity Framework Core 的 DICOM 数据: ...
