Integrating medical data and images in a database management system

• US 7,853,621 B2
• Filed: 11/23/2005
• Issued: 12/14/2010
• Est. Priority Date: 11/23/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Guo, Dongbai
• Primary Examiner(s): Ali; Mohammad
• Assistant Examiner(s): Corbo; Griselle
• Application Number:
  US11/285,977
• Publication Number:
  US 20070118540A1
• Time in Patent Office: 1,847 Days
• Field of Search: 707/100
• US Class Current: 707/803
• CPC Class Codes: G06F 16/58 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G16H 30/20 for handling medical images, e.g. DICOM, HL7 or PACS

Abstract

A method of integrating syntactically valid medical images into a database management system. A database table is created and a database object is initialized with a medical image object. The medical image object is parsed. An XML representation of metadata associated with the medical image object is created and the database object is inserted in the table.

Claims

1. A method of integrating Digital Imaging and Communication in Medicine (DICOM) images into a database management system comprising:

creating, in a memory, a database table with at least one table column of a database object type for at least one DICOM image object encapsulated with the database object type including at least one shared attribute and at least one application specific attribute that comprises a schema-bound XML representation of metadata associated with a corresponding DICOM image object;

parsing, using at least a processor, the corresponding DICOM image object using a database stored procedure and generating the schema-bound XML representation of metadata associated with the corresponding DICOM image object where the schema-bound XML representation of metadata includes shared attribute elements organized hierarchically and allows the shared attribute elements to be addressed by a fixed path, and application specific attribute elements organized in a list according to a value representative of the application specific attribute elements and allows the application specific attribute elements to be addressed by an element tag;

enabling bi-directional mapping of the schema-bound XML representation of metadata and the corresponding DICOM image object, where the schema-bound XML representation is convertible back into a syntactically valid DICOM image object using the bi-directional mapping;

saving the metadata in the schema-bound XML representation of metadata associated with the corresponding DICOM image object; and

inserting the database object in the at least one table column, of the database object type, of the table.

2. The method of claim 1 where parsing the DICOM image object further comprises:

looking up an attribute definition for each attribute;

creating a data type instance for each attribute and parsing the binary content of the data type instance; and

saving each attribute together with the data type instance in a data structure.

3. The method of claim 1 where creating the schema-bound XML representation of metadata associated with the DICOM image object comprises:

creating an empty XML document;

obtaining a mapping document;

looking up, in the mapping document, a target for each attribute by the tag; and

inserting each attribute in a data structure.

4. The method of claim 3 wherein a unique identifier comprises an SOP instance UID.

5. The method of claim 1 further comprising building an index on an image column in the database.

6. The method of claim 1 further comprising mapping a single DICOM object into multiple XML formats to serve different application needs.

7. The method of claim 1 further comprising that the XML schema definition of metadata associated with the DICOM image object includes a fixed core segment and an extensible segment, the fixed core segment composed of DICOM object attributes and the extensible segment composed of specific DICOM implementations to define a one to one bi-directional mapping between a DICOM datatype and the XML schema definition.

8. A method of using a database management system to manage Digital Imaging and Communication in Medicine (DICOM) images comprising:

creating a database table with at least one column for a database object of a database object type that includes a schema-bound XML representation of a DICOM image object;

designing a metadata schema for the XML representation of the DICOM image object and associating the schema with an XML namespace designated to a default XML metadata schema where the default XML metadata schema includes shared attribute elements organized hierarchically and allows the shared attribute elements to be addressed by a fixed path, and application specific attribute elements organized in a list according to a value representative of the application specific attribute elements and allows the application specific attribute elements to be addressed by an element tag;

loading the database object with the default XML metadata schema into the database;

inserting the database object into the table with a unique identifier; and

enabling bi-directional mapping of the XML representation to-and-from the DICOM image object, where a resultant DICOM image object that is generated from transforming the schema-bound XML representation is bitwise identical to the DICOM image object.

9. The method of claim 8 where designing the metadata schema further comprises:

parsing attributes of the DICOM image object;

encoding the attributes into XML; and

returning the XML encoding of the DICOM image object to be associated with the database object.

10. The method of claim 9 where parsing attributes of the DICOM image object further comprises:

reading a tag associated with each attribute;

associating an attribute definition with each attribute;

creating a data type instance and parsing a binary content of the data type instance; and

saving each attribute in a data structure.

11. A method of creating an XML schema definition for a Digital Imaging and Communication in Medicine (DICOM) image comprising:

defining shared attributes;

defining application specific attributes;

mapping the shared attributes and the application specific attributes; and

defining the XML metadata schema representing the DICOM image, the XML metadata schema having a fixed core segment that organizes shared attribute elements hierarchically and allows the shared attribute elements to be addressed by a fixed XPath and an extensible segment that organizes application specific attribute elements in a list according to a value representative of the application specific attribute elements and allows the application specific attribute elements to be addressed by an element tag;

enabling bi-directional mapping of the DICOM image with an XML metadata schema representation by utilizing the XML metadata schema.

12. The method of claim 11 wherein the shared attributes are patient, specimen, clinical trials, general study, patient study, general series, clinical trial series, general equipment, image pixel, waveform identification, waveform and SOP common attributes.

13. The method of claim 11 wherein the XSD conforms to a VR definition and explicitly lists all subfields, defining a complex type comprising three subcomponents, a unibyte, a ideographic and a phonetic subcomponent.

14. The method of claim 11 where any valid XML document can be encoded into a syntactically valid DICOM standalone file and a syntactically valid DICOM standalone file can be mapped into a valid XML document.

15. The method of claim 11, where providing the bi-directional mapping of the XML metadata schema and the corresponding DICOM image object includes:

generating a bi-directional mapping where the XML metadata schema representing the DICOM image object is convertible with lossless transformation back into the DICOM image object based at least in part on the bi-directional mapping; and

storing the bi-directional mapping in a memory.

16. A method for managing digital images and communication in Digital Imaging and Communication in Medicine (DICOM) objects in a database comprising:

defining a XML schema comprising a fixed core segment that organizes shared attribute elements hierarchically and allows the shared attribute elements to be addressed by a fixed XPath and an extensible segment that organizes application specific attribute elements in a list according to a value representative of the application specific attribute elements and allows the application specific attribute elements to be addressed by an element tag;

including only attributes common to all DICOM objects in the fixed core segment;

including a sequence of data element descriptors in the extensible segment;

extracting metadata from the corresponding DICOM image object;

encoding the extracted metadata into an XML representation of the metadata and associate the XML representation with the XML schema; and

enabling bi-directional mapping of the DICOM image object with the XML representation.

17. The method of claim 16 wherein attributes in the fixed core segment are patient, series or study.

18. A system for managing Digital Imaging and Communication in Medicine (DICOM) image data comprising:

a relational database stored in a memory including tables that store DICOM images and data; and

at least one DICOM image object stored in a memory that is mapped to an XML metadata document by defining a XML schema comprising a fixed core segment that organizes shared attribute elements hierarchically and allows the shared attribute elements to be addressed by a fixed XPath and an extensible segment that organizes application specific attribute elements in a list according to a value representative of the application specific attribute elements and allows the application specific attribute elements to be addressed by an element tag;

including only attributes common to all DICOM objects in the fixed core segment;

including a sequence of data element descriptors in the extensible segment;

extracting metadata from the corresponding DICOM image object;

encoding the extracted metadata into an XML representation of the metadata and associate the XML representation with the XML schema; and

enabling bi-directional mapping of the DICOM image object with the XML representation by utilizing the XML metadata schema.

19. The system of claim 18 further comprising an XML mapping document for converting the DICOM image object into an XML element.

20. The system of claim 18 further comprising:

a data dictionary including a set of DICOM image attribute definitions;

a mapping document defining mapping rules for mapping the DICOM image attributes into a metadata document; and

a constraint document for validating a standard conformance of the metadata document with DICOM imaging standards.

21. A computer-readable medium that stores executable instructions that are non-transitory and that when executed by an apparatus cause the apparatus to perform a method, the method comprising:

creating, in a memory, a database table with at least one table column of a database object type for at least one DICOM image object encapsulated with a database object type including at least shared one attribute and at least one application specific attribute that comprises a schema-bound XML representation of metadata associated with the corresponding DICOM image object;

parsing, using at least a processor, the corresponding DICOM image object using a database stored procedure and generating the schema-bound XML representation of metadata associated with the corresponding DICOM image object where the schema-bound XML representation of metadata includes shared attribute elements organized hierarchically and allows the shared attribute elements to be addressed by a fixed path and application specific attribute elements organized in a list according to a value representative of the application specific attribute elements and allows the application specific attribute elements to be addressed by an element tag;

enabling bi-directional mapping of the schema-bound XML representation of metadata and the corresponding DICOM image object, where the schema-bound XML representation is convertible back into a syntactically valid DICOM image object using the bi-directional mapping;

saving the metadata in the schema-bound representation of metadata associated with the corresponding DICOM image object; and

inserting the database object in the at least one table column, of the database object type, of the table.