| General Information |
| Source |
$ORACLE_HOME/ord/im/admin/ordcpksp.sql
$ORACLE_HOME/ord/im/admin/ordcrpsp.sql |
| First Available |
11.1.0.6 |
| Dependencies |
conn / as sysdba
SELECT object_name
FROM dba_objects_ae
WHERE lower(object_name) LIKE '%dicom%';
SELECT object_type, COUNT(*)
FROM dba_objects_ae
WHERE lower(object_name) LIKE '%dicom%'
GROUP BY object_type;
OBJECT_TYPE COUNT(*)
------------ --------
PACKAGE 5
PACKAGE BODY 5
TYPE BODY 1
SYNONYM 459
JAVA CLASS 456
TYPE 7
SELECT owner, object_name
FROM dba_objects_ae
WHERE lower(object_name) LIKE '%dicom%'
AND object_type = 'PACKAGE'
ORDER BY 2;
OWNER OBJECT_NAME
----- -------------------
ORDSYS ORD_DICOM
ORDSYS ORD_DICOM_ADMIN
ORDSYS ORD_DICOM_ADMIN_PRV
ORDSYS ORD_DICOM_CT
ORDSYS ORD_DICOM_PKG |
| Storage Structure |
DICOM_IMAGE
ORD_DICOM_HEADER
VERSION
DICOM_STANDARD_VERSION
DICOM_STANDARD_RELEASE
FILE_META_HEADER
MEDIA_STORAGE_SOP_CLASS_UID
MEDIA_STORAGE_SOP_INSTANCE_UID
TRANSFER_SYNTAX_UID
IMPLEMENTATION_CLASS_UID
IMPLEMENTATION_VERSION_NAME
SOURCE_APPLICATION_ENTITY_TITLE
PATIENT
NAME
ID
BIRTH_DATE
SEX
GENERAL_STUDY
INSTANCE_UID
DATE
TIME
REFERING_PHYSICIANS_NAME
ID
ACCESSION_NUMBER
DESCRIPTION?
PATIENT_STUDY?
ADMITTING_DIAGNOSES_DESCRIPTION
ADMITTING_DIAGNOSES_CODE_SEQUENCE
GENERAL_SERIES
MODALITY
INSTANCE_UID
DATE
TIME
PERFORMING_PHYSICIANS_NAME
BODY_PART_EXAMINED
PATIENT_POSITION
PERFORMED_PROCEDURE_STEP_ID
PERFORMED_PROCEDURE_STEP_START_DATE
PERFORMED_PROCEDURE_STEP_START_TIME
PERFORMED_PROCEDURE_STEP_DESCRIPTION
PERFORMED_PROTOCOL_CODE_SEQUENCE
GENERAL_EQUIPMENT?
MANUFACTURER
GENERAL_IMAGE?
INSTANCE_NUMBER
ACQUISITION_NUMBER
ACQUISITION_DATE
ACQUISITION_TIME
ACQUISITION_DATETIME
PATIENT_ORIENTATION
FRAME_LATERALITY
ANATOMIC_REGION
IMAGE_PIXEL?
SAMPLES_PER_PIXEL
PHOTOMETRIC_INTERPRETATION
ROWS
COLUMNS
BIT_ALLOCATED
BIT_STORED
HIGH_BIT
PIXEL_REPRESENTATION
PLANAR_CONFIGURATION
PIXEL_ASPECT_RATIO
SOP_COMMON
CLASS_UID
INSTANCE_UID
SPECIFIC_CHARACTER_SET |
| |
| DICOM Demo |
| Sample DICOM Image Files |
Download free DICOM images [Click Here]
Download a free DICOM image viewer [Click Here] |
| Create Directory Object |
conn / as sysdba
CREATE OR REPLACE DIRECTORY ctemp AS 'c:\temp';
GRANT read ON DIRECTORY ctemp TO uwclass;
-- place a dicom image named image1.dcm into the directory pointed to by the Oracle Directory object CTEMP |
| Create table to hold DICOM images |
conn uwclass/uwclass
CREATE TABLE medicalImages(
image_id NUMBER,
description VARCHAR2(40),
metadata XMLType,
image ORDSYS.ORDIMAGE,
thumb ORDSYS.ORDIMAGE)
LOB (image.source.localdata) STORE AS (chunk 32K)
-- store images with 32K chunk
LOB (thumb.source.localdata)
STORE AS (chunk 16K)
-- but the thumbnails with only 16K
-- bind the XMLType columns to the interMedia metadata columns
XMLType column metadata
XMLSCHEMA "http://xmlns.oracle.com/ord/meta/dicomImage"
ELEMENT "DICOM_IMAGE";
ALTER TABLE medicalimages
ADD CONSTRAINT pk_medicalimages
PRIMARY KEY(image_id)
USING INDEX;
desc medicalImages
set describe depth all linenum on indent on
desc medicalImages
set describe depth 1
SELECT object_name, object_type
FROM user_objects
WHERE created > SYSDATE-10/1440
ORDER BY 1,2;
desc user_lobs
SELECT table_name, segment_name, index_name, chunk, in_row
FROM user_lobs;
SELECT index_name, index_type, table_type
FROM user_indexes
WHERE table_name = 'MEDICALIMAGES'
ORDER BY 1;
-- explore what ORDDICOM is
conn ordsys/ordsys
-- if you can not log on then do the following:
-- conn / as sysdba
-- alter user ordsys account unlock identified by ordsys
-- grant create session to ordsys;
SELECT object_type
FROM user_objects
WHERE object_name = 'ORDDICOM';
SELECT DISTINCT object_name
FROM user_arguments
WHERE package_name = 'ORDDICOM'
ORDER BY 1; |
| Load DICOM image file |
conn uwclass/uwclass
INSERT INTO medicalimages
(image_id, description, metadata, image)
VALUES
(1, 'TEST', NULL, ordsys.ordimage.init());
-- this does not work
SELECT *
FROM medicalimages;
-- this does
SELECT image_id, description
FROM medicalimages;
set serveroutput on
DECLARE
obj1 ordsys.ordimage;
BEGIN
SELECT image
INTO obj1
FROM medicalImages
WHERE image_id = 1
FOR UPDATE;
obj1.setSource('FILE', 'CTEMP', 'image1.dcm');
dbms_output.put_line(obj1.getSource || ' has been loaded');
UPDATE medicalImages
SET image=obj1
WHERE image_id=1;
COMMIT;
END;
/
-- this does not work
SELECT dbms_lob.getlength(image)
FROM medicalimages;
-- remember this is being stored as ordsys.ordimage not as a BLOB
desc medicalimages |
| Create metadata extract procedure |
CREATE OR REPLACE PROCEDURE extractDicomMetadata(inID IN INTEGER) AUTHID DEFINER IS
local_image ORDSYS.ORDIMAGE;
local_id INTEGER;
dicom_metadata XMLType := NULL;
BEGIN
SELECT image
INTO local_image
FROM medicalImages
WHERE image_id = inID;
-- extract DICOM metadata
dicom_metadata := local_image.getDicomMetadata('imageGeneral');
IF (dicom_metadata IS NULL) THEN
dbms_output.put_line('metadata is NULL');
ELSE
UPDATE medicalImages
SET metadata = dicom_metadata
WHERE image_id = inID;
END IF;
-- print the namespace of the XML document containing the DICOM metadata just extracted
dbms_output.put_line('namespace: ' || dicom_metadata.getNamespace());
END extractDicomMetadata;
/
-- this may take a ~60 seconds the first time on a Windows machine
exec extractDicomMetadata(1); |
| View metadata |
SELECT DISTINCT package_name, object_name
FROM all_arguments
WHERE package_name LIKE '%DICOM%'
ORDER BY 1;
set long 1000000
SELECT metadata FROM medicalimages; |
