Oracle Multimedia stores dicom in the ORDDicom Column

OracleMultimedia DICOM can be used to integrate Oracle database storage, medical images in DICOM-related formats, and other enterprise information into other related objects. If you want to know how Oracle Multimedia DICOM implements this process, you can click the following article.

Oracle Multimedia DICOM supports medical digital imaging and Communication (DICOM), that is, Medical Image standards. This tutorial provides a simple PL/SQL example to describe how to use Oracle Multimedia to upload, store, operate, and export medical image data in the database. Oracle Multimedia stores DICOM data in ORDDicom columns of the database table. The ORDDicom object in the database table is illustrated as an example.

Prerequisites

Before starting this tutorial, you should:

1. Install Oracle database version 11.1 with Oracle Multimedia.

2. Install the Oracle Database 11g product using the supporting CD ).

3.download and decompress the dicom.zip file to the working directory.

Create a directory object for Import and Export

To avoid unnecessary database connections, you should create directory objects and permissions required for the import and export activities. Perform the following steps:

1. Make sure that the PM user is not locked and has the create any directory permission. Open an SQL * Plus session and run the following command:

Java code

 
 

  
  
sqlplus sys/<syspassword>@<sid> as sysdba   
  
  
alter user PM identified by PM account unlock;   
  
  
grant create any directory to PM;  
  
  
sqlplus sys/<syspassword>@<sid> as sysdba  
  
  
alter user PM identified by PM account unlock;  
  
  
grant create any directory to PM; 
 
 

2. Now, you can create directory objects as a PM user. In the SQL * Plus session, run the following command:

Java code

 
 

  
  
connect PM/PM@<Sid>   
  
  
create or replace directory IMAGEDIR as '<file_directory>';  
  
  
connect PM/PM@<Sid> 
  
  
create or replace directory IMAGEDIR as '<file_directory>'; 
 
 

Here, Is the location of all scripts/files required in this tutorial, such as/home/oracle/dicom. Note: If the directory does not exist, you must create one. | The above is an introduction to the practical application steps of Oracle Multimedia DICOM supporting medical digital imaging and communication (DICOM). I hope you will gain some benefits.