# US 10,120,976 B2 · Methods, systems, and computer readable media for integrating medical imaging data in a data warehouse > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 10,120,976 B2 - Document ID: US10120976B2 - Status: Granted - Kind: B2 - Application number: 14/682,066 - Filed: 2015-04-08 - Published: 2016-10-13 - Granted: 2018-11-06 - Earliest claimed: 2015-04-08 - Assignees: Oracle International Corporation - Applicants: Oracle International Corporation - Inventors: Prashant Natarajan; Brian A. Pederson - Web page: https://patentgrep.com/patent/US10120976B2 ## CPC - G16H 30/20: for handling medical images, e.g. DICOM, HL7 or PACS - G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses} - G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP} - G16H 30/40: for processing medical images, e.g. editing - G16H: HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract Methods, systems, and computer readable media for integrating medical imaging data in a data warehouse are disclosed. According to one method, the method occurs at a data warehouse management server that manages a data warehouse system. The data warehouse management server includes at least one processor. The method includes receiving medical imaging data including imaging metadata from an imaging related data source. The method also includes storing the imaging metadata in the data warehouse. The method further includes performing data processing using the imaging metadata and other healthcare related data stored in the data warehouse, wherein the other healthcare related data is from one or more different data sources. ## Claims ### Claim 1 A method for integrating medical imaging data in a data warehouse, the method comprising: in a data warehouse management server that manages a data warehouse, the data warehouse management server including at least one processor: receiving medical imaging data including imaging metadata from an imaging related data source; storing, using data conversion rules, the imaging metadata in the data warehouse, wherein storing the imaging metadata includes generating image instance data objects comprising image attributes for image instances and an imaging device data object comprises attributes for an imaging device, wherein each image instance data object includes a time stamp and at least one image quality attribute, wherein the at least one imaging device data object includes an image device identifier, maintenance data, and related image instance identifiers; performing data processing using the imaging metadata and other healthcare related data stored in the data warehouse, wherein the other healthcare related data is from one or more different data sources, wherein performing the data processing includes analyzing imaging metadata of image instance data objects associated with the related image instance identifiers of the imaging device data object and determining, using the imaging metadata and the other healthcare related data, a workload performed by the associated imaging device; detecting imaging quality issues associated with the associated imaging device by analyzing image quality attributes of image instance data objects associated with the workload; and notifying, via a communications interface and based on the detected imaging quality issues, an operator for imaging device calibration, imaging device training, or imaging device maintenance. ### Claim 2 (depends on 1) The method of claim 1 wherein the imaging metadata includes digital imaging and communications in medicine (DICOM) data. ### Claim 3 (depends on 2) The method of claim 2 wherein the DICOM data includes information about an image, information about an imaging device, information about an image series, information about an image study, or information about a patient. ### Claim 4 (depends on 2) The method of claim 2 wherein storing the imaging metadata in the data warehouse includes identifying a DICOM tag among the DICOM data and storing information associated with the DICOM tag in at least one imaging related data object. ### Claim 5 (depends on 4) The method of claim 4 wherein the at least one imaging related data object includes a patient data object, an image instance data object, an image study data object, an image series data object, or an imaging device data object. ### Claim 6 (depends on 4) The method of claim 4 wherein the at least one imaging related data object is a subtype of a non-imaging related data object. ### Claim 7 (depends on 1) The method of claim 1 wherein storing the imaging metadata in the data warehouse includes converting a vendor specific metadata portion into a different format. ### Claim 8 (depends on 1) The method of claim 1 wherein performing data processing using the imaging metadata and the other healthcare related data stored in the data warehouse includes performing analytics processing, business intelligence processing, data warehouse related processing, report generation, a quality assurance analysis, a cost analysis, a load analysis, a quality control analysis, resource planning, personnel scheduling, or a financial analysis. ### Claim 9 (depends on 1) The method of claim 1 wherein the other healthcare related data includes information from an electronic heath record (EHR) system, a hospital information system (HIS), an enterprise resource planning (ERP) system, a healthcare related scheduling system, or a healthcare related financial system. ### Claim 10 A system for integrating medical imaging data in a data warehouse, the system comprising at least one processor; and a data warehouse management server that manages a data warehouse, the data warehouse management server including the at least one processor, wherein the data warehouse management server is configured to receive medical imaging data including imaging metadata from an imaging related data source, to store, using data conversion rules, the imaging metadata in the data warehouse, wherein storing the imaging metadata includes generating image instance data objects comprising image attributes for image instances and an imaging device data object comprises attributes for an imaging device, wherein each image instance data object includes a time stamp and at least one image quality attribute, wherein the at least one imaging device data object includes an image device identifier, maintenance data, and related image instance identifiers, to perform data processing using the imaging metadata and other healthcare related data stored in the data warehouse, wherein the other healthcare related data is from one or more different data sources, wherein performing the data processing includes analyzing imaging metadata of image instance data objects associated with the related image instance identifiers of the imaging device data object and determining, using the imaging metadata and the other healthcare related data, a workload performed by the associated imaging device, detecting imaging quality issues associated with the associated imaging device by analyzing image quality attributes of image instance data objects associated with the workload, and notifying, via a communications interface and based on the detected imaging quality issues, an operator for imaging device calibration, imaging device training, or imaging device maintenance. ### Claim 11 (depends on 10) The system of claim 10 wherein the imaging metadata includes digital imaging and communications in medicine (DICOM) data. ### Claim 12 (depends on 11) The system of claim 11 wherein the DICOM data includes information about an image, information about an imaging device, information about an image series, information about an image study, or information about a patient. ### Claim 13 (depends on 11) The system of claim 11 wherein the data warehouse management server is configured to identify a DICOM tag among the DICOM data and storing information associated with the DICOM tag in at least one imaging related data object. ### Claim 14 (depends on 13) The system of claim 13 wherein the at least one imaging related data object includes a patient data object, an image instance data object, an image study data object, an image series data object, or an imaging device data object. ### Claim 15 (depends on 13) The system of claim 13 wherein the at least one imaging related data object is a subtype of a non-imaging related data object. ### Claim 16 (depends on 10) The system of claim 10 wherein the data warehouse management server is configured to convert a vendor specific metadata portion into a different format. ### Claim 17 (depends on 10) The system of claim 10 wherein the data warehouse management server is configured to perform analytics processing, business intelligence processing, data warehouse related processing, report generation, a quality assurance analysis, a cost analysis, a load analysis, a quality control analysis, resource planning, personnel scheduling, or a financial analysis. ### Claim 18 (depends on 10) The system of claim 10 wherein the at least one other data object includes information from an electronic heath record (EHR) system, a hospital information system (HIS), an enterprise resource planning (ERP) system, a healthcare related scheduling system, or a healthcare related financial system. ### Claim 19 A non-transitory computer readable medium having stored thereon executable instructions that when executed by a processor of a data warehouse management server that manages a data warehouse cause the data warehouse management server to perform steps comprising: receiving medical imaging data including imaging metadata from an imaging related data source; storing, using data conversion rules, the imaging metadata in the data warehouse, wherein storing the imaging metadata includes generating image instance data objects comprising image attributes for image instances and an imaging device data object comprises attributes for an imaging device, wherein each image instance data object includes a time stamp and at least one image quality attribute, wherein the at least one imaging device data object includes an image device identifier, maintenance data, and related image instance identifiers; performing data processing using the imaging metadata and other healthcare related data stored in the data warehouse, wherein the other healthcare related data is from one or more different data sources, wherein performing the data processing includes analyzing imaging metadata of image instance data objects associated with the related image instance identifiers of the imaging device data object and determining, using the imaging metadata and the other healthcare related data, a workload performed by the associated imaging device; detecting imaging quality issues associated with the associated imaging device by analyzing image quality attributes of image instance data objects associated with the workload; and notifying, via a communications interface and based on the detected imaging quality issues, an operator for imaging device calibration, imaging device training, or imaging device maintenance. ### Claim 20 (depends on 19) The non-transitory computer readable medium of claim 19 wherein the imaging metadata includes digital imaging and communications in medicine (DICOM) data.