1/32

Contents

Expand All · Collapse All

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Syntax Descriptions

Changes in This Release for Oracle Multimedia DICOM Developer's Guide

• Changes in Oracle Database 12c Release 1 (12.1)

Part I DICOM Common Usage and Reference

1 Introduction to Oracle Multimedia DICOM

• 1.1 Medical Imaging and Communication
  • 1.1.1 History of the DICOM Standard
  • 1.1.2 Overview of DICOM Content
• 1.2 Oracle Multimedia and DICOM
  • 1.2.1 Oracle Multimedia DICOM Format Support
  • 1.2.2 DICOM Database Network Component for the DICOM Protocol Adapter
  • 1.2.3 ORDDicom Object Type
  • 1.2.4 DICOM Metadata Extraction
  • 1.2.5 DICOM Conformance Validation
  • 1.2.6 DICOM Image Processing
  • 1.2.7 Making Confidential Data in DICOM Content Anonymous
  • 1.2.8 Creating ORDDicom Objects from Images or Video and Metadata
  • 1.2.9 Run-Time, Updatable DICOM Data Model
  • 1.2.10 Integration of Oracle Multimedia DICOM With Oracle WebCenter Content

2 Oracle Multimedia DICOM Concepts

• 2.1 Oracle Multimedia DICOM Architecture
• 2.2 Oracle Multimedia DICOM Storage
• 2.3 Model-Driven Design
• 2.4 DICOM Data Model Repository
  • 2.4.1 Configuration Documents in the Repository
  • 2.4.2 Administrator and User Sessions in the Repository
  • 2.4.3 DICOM Data Model Repository in a CDB
• 2.5 Extraction of Metadata from DICOM Content
  • 2.5.1 Overview of the Metadata Extraction and XML Mapping Process
  • 2.5.2 Sample XML Documents Used in the Extraction and Mapping Process
• 2.6 Validation of DICOM Content
• 2.7 Image Conversion and Creation of New DICOM Content
• 2.8 Making DICOM Content Anonymous
• 2.9 Extraction of DICOM Metadata for Partitioning

3 Overview of DICOM Development

• 3.1 The DICOM Development Environment
  • 3.1.1 APIs for Use With Oracle Multimedia DICOM
  • 3.1.2 Views in the DICOM Repository
• 3.2 DICOM Developer and Administrator Tasks
  • 3.2.1 Task 1: Load the Repository
  • 3.2.2 Task 2: Load the DICOM Content
  • 3.2.3 Task 3: Extract the DICOM Metadata
    • 3.2.3.1 Extracting Metadata: Administrator Tasks
    • 3.2.3.2 Extracting Metadata: Developer Tasks
  • 3.2.4 Task 4: Search and Retrieve DICOM Attributes
  • 3.2.5 Task 5: Write and Edit DICOM Metadata
  • 3.2.6 Task 6: Process, Convert, and Compress DICOM Data
  • 3.2.7 Task 7: Create DICOM Content from Secondary Capture Images and Video
  • 3.2.8 Task 8: Validate Conformance with DICOM Constraints
    • 3.2.8.1 Validating Conformance: Administrator Tasks
    • 3.2.8.2 Validating Conformance: Developer Tasks
  • 3.2.9 Task 9: Protect Confidential Patient Data
    • 3.2.9.1 Protecting Privacy: Administrator Tasks
    • 3.2.9.2 Protecting Privacy: Developer Tasks
  • 3.2.10 Task 10: Improve Storage When Extracting DICOM Attributes

4 DICOM Protocol Support

• 4.1 Overview of DICOM Protocol Support for Oracle Database
• 4.2 Contents of the Oracle DICOM Protocol Adapter Suite
  • 4.2.1 The Oracle DICOM Protocol Adapter
  • 4.2.2 The Oracle DICOM Crawler
  • 4.2.3 The Oracle DICOM WADO Proxy
• 4.3 Deploying the Oracle DICOM Protocol Adapter Suite
  • 4.3.1 Deploying the Archive Files
  • 4.3.2 Performing a Standard Deployment
  • 4.3.3 Performing an Advanced Deployment
  • 4.3.4 Modifying the Component Archive Files
    • 4.3.4.1 Modifying the DICOM Adapter Archive File
    • 4.3.4.2 Modifying the DICOM Crawler Archive File
    • 4.3.4.3 Modifying the DICOM WADO Proxy Archive File
• 4.4 Configuring the Oracle DICOM Protocol Adapter
  • 4.4.1 Configuring the Oracle DICOM Protocol Adapter
  • 4.4.2 Configuring the Oracle DICOM Crawler
  • 4.4.3 Configuring the Oracle DICOM WADO Proxy
• 4.5 Configuring DICOM Protocol Support for Oracle Database
• 4.6 Image Versioning with the DICOM Protocol Adapter
• 4.7 Extracting Private Attributes from DICOM Data with the DICOM Protocol Adapter
• 4.8 Improving DICOM Metadata Extraction for BLOB Storage

5 DICOM Data Model Utility Reference

• 5.1 Directory Definition and Setup for ORD_DICOM Examples
• DICOM Data Model Utility Functions
  • getDictionaryTag( ) Function
  • getMappingXPath( ) Function
• DICOM Data Model Utility Procedures
  • setDataModel( ) Procedure
• DICOM Repository Public Views
  • orddcm_conformance_vld_msgs
  • orddcm_constraint_names
  • orddcm_documents
  • orddcm_document_types

Part II DICOM Development Usage and Reference

6 DICOM Application Development

• 6.1 Setting Up Your Environment
• 6.2 Creating a Table with an ORDDicom Column
• 6.3 Loading DICOM Content Using the SQL*Loader Utility
• 6.4 Developing DICOM Applications Using the PL/SQL API
  • 6.4.1 Selecting DICOM Attributes
  • 6.4.2 Creating Thumbnail Images and Changing Image Formats
  • 6.4.3 Making Anonymous Copies of ORDDicom Objects
  • 6.4.4 Checking the Conformance of ORDDicom Objects
  • 6.4.5 Handling Oracle Multimedia DICOM Exceptions in PL/SQL
• 6.5 Developing DICOM Applications Using the DICOM Java API
  • 6.5.1 Setting Up Your Environment Variables
  • 6.5.2 Importing Oracle Java Classes into Your Application
  • 6.5.3 Handling Oracle Multimedia DICOM Exceptions in Java

7 DICOM Sample Application

• 7.1 Overview of the DICOM Sample Application
• 7.2 Description of the DICOM Sample Application
  • 7.2.1 Logging In to the DICOM Image Archive Interface
  • 7.2.2 Searching for Specific DICOM Images
    • 7.2.2.1 Attribute Searches
    • 7.2.2.2 Keyword Searches
    • 7.2.2.3 Semantic Searches
  • 7.2.3 Importing DICOM Images as a Clinician
  • 7.2.4 Processing DICOM Images as a Researcher
  • 7.2.5 Logging In to the DICOM Image Archive Administration Interface
  • 7.2.6 Inserting Configuration Documents

8 ORDDicom Object Type Reference

• 8.1 ORDDicom Object Examples
  • 8.1.1 Directory Definition and Setup for ORDDicom Object Examples
  • 8.1.2 MEDICAL_IMAGE_OBJ Table Definition
• ORDDicom Object Type
• ORDDicom Constructors
  • ORDDicom( ) for BLOBs
  • ORDDicom( ) for ORDImage
  • ORDDicom( ) for Other Sources
• ORDDicom Methods
  • export( )
  • extractMetadata( )
  • getAttributeByName( )
  • getAttributeByTag( )
  • getContent( )
  • getContentLength( )
  • getSeriesInstanceUID( )
  • getSOPClassUID( )
  • getSOPInstanceUID( )
  • getSourceInformation( )
  • getSourceLocation( )
  • getSourceName( )
  • getSourceType( )
  • getStudyInstanceUID( )
  • import( )
  • isAnonymous( )
  • isConformanceValid( )
  • isLocal( )
  • makeAnonymous( )
  • processCopy( ) to BLOBs
  • processCopy( ) to ORDDicom
  • processCopy( ) to ORDImage
  • setProperties( )
  • writeMetadata( )

9 DICOM Relational Interface Reference

• 9.1 Examples for DICOM Relational Functions and Procedures
  • 9.1.1 Directory Definition and Setup for DICOM Relational Examples
  • 9.1.2 MEDICAL_IMAGE_REL Table Definition
• DICOM Relational Functions
  • extractMetadata( ) for BFILEs
  • extractMetadata( ) for BLOBs
  • extractMetadata( ) for ORDImage
  • isAnonymous( ) for BFILEs
  • isAnonymous( ) for BLOBs
  • isAnonymous( ) for ORDImage
  • isConformanceValid( ) for BFILEs
  • isConformanceValid( ) for BLOBs
  • isConformanceValid( ) for ORDImage
• DICOM Relational Procedures
  • createDicomImage( ) for BFILEs
  • createDicomImage( ) for BLOBs
  • createDicomImage( ) for ORDImage
  • export( )
  • importFrom( )
  • makeAnonymous( ) for BFILEs
  • makeAnonymous( ) for BLOBs
  • makeAnonymous( ) for ORDImage
  • processCopy( ) for BFILEs
  • processCopy( ) for BFILEs with SOP Instance UID
  • processCopy( ) for BLOBs
  • processCopy( ) for BLOBs with SOP Instance UID
  • processCopy( ) for ORDImage
  • processCopy( ) for ORDImage with SOP Instance UID
  • writeMetadata( ) for BFILEs
  • writeMetadata( ) for BLOBs
  • writeMetadata( ) for ORDImage

Part III DICOM Administration Usage and Reference

10 Overview of DICOM Administration

• 10.1 Assigning Administrator Roles and Privileges
• 10.2 Managing XML Schemas
  • 10.2.1 Registering XML Schemas
  • 10.2.2 Finding User-Defined XML Schemas
• 10.3 Loading the Data Model Repository
• 10.4 Managing the Impact of Oracle Data Guard Rolling Upgrades
• 10.5 Browsing the Repository with Views
• 10.6 Exporting Documents from the Repository
• 10.7 Inserting Documents into the Repository
  • 10.7.1 Inserting Anonymity, Mapping, and Constraint Documents
  • 10.7.2 Inserting Dictionary Documents
  • 10.7.3 Inserting Preference and UID Definition Documents
  • 10.7.4 Inserting Stored Tag List Documents
  • 10.7.5 Inserting DICOM Protocol Documents
• 10.8 Updating Documents in the Repository
  • 10.8.1 Updating Anonymity, Mapping, and Constraint Documents
  • 10.8.2 Updating Dictionary Documents
  • 10.8.3 Updating Preference and UID Definition Documents
• 10.9 Deleting Documents from the Repository
  • 10.9.1 Deleting Anonymity, Mapping, and Constraint Documents
  • 10.9.2 Deleting Dictionary Documents
  • 10.9.3 Deleting Preference and UID Definition Documents
• 10.10 Oracle Data Pump Utilities Support for Oracle Multimedia DICOM
  • 10.10.1 Roles for Export and Import Operations
  • 10.10.2 Mode for Export and Import Operations
    • 10.10.2.1 Exporting in Full Mode
    • 10.10.2.2 Importing in Full Mode

11 Creating DICOM Configuration Documents

• 11.1 Characteristics of Configuration Documents
  • 11.1.1 Characteristics of Anonymity Documents
  • 11.1.2 Characteristics of Constraint Documents
  • 11.1.3 Characteristics of DICOM Protocol Documents
  • 11.1.4 Characteristics of Mapping Documents
  • 11.1.5 Characteristics of Preference Documents
  • 11.1.6 Characteristics of Private Dictionary Documents
  • 11.1.7 Characteristics of Standard Dictionary Documents
  • 11.1.8 Characteristics of Stored Tag List Documents
  • 11.1.9 Characteristics of UID Definition Documents
• 11.2 Writing Configuration Documents
  • 11.2.1 Creating Anonymity Documents
    • 11.2.1.1 Making Standard Attributes Anonymous
    • 11.2.1.2 Making Undefined Standard Attributes Anonymous
    • 11.2.1.3 Making Selected Private Attributes Anonymous
    • 11.2.1.4 Making All Private Attributes Anonymous
    • 11.2.1.5 Using DICOM Value Locators in Anonymity Documents
  • 11.2.2 Creating Constraint Documents
    • 11.2.2.1 Defining a Simple Constraint Rule
    • 11.2.2.2 Defining Constraint Rules by Importing Other Constraint Rules
    • 11.2.2.3 Defining and Referencing Constraint Macros
    • 11.2.2.4 Defining Recursive Constraint Macros
    • 11.2.2.5 Using DICOM Value Locators in Constraint Documents
  • 11.2.3 Creating DICOM Protocol Documents
  • 11.2.4 Creating Mapping Documents and Metadata XML Schemas
    • 11.2.4.1 Structure of a Mapping Document
    • 11.2.4.2 Structure of a Metadata XML Schema
    • 11.2.4.3 Creating a Mapping Document for Metadata with No Schema Constraints
    • 11.2.4.4 Creating a Mapping Document for Metadata with Schema Constraints and a Mapped Section Only
    • 11.2.4.5 Creating a Mapping Document for Metadata with Schema Constraints
    • 11.2.4.6 Using DICOM Value Locators in Mapping Documents
  • 11.2.5 Creating Preference Documents
    • 11.2.5.1 Defining the BINARY_SKIP_INVALID_ATTR Preference Parameter
    • 11.2.5.2 Defining the CONFORMANCE_LEVEL Preference Parameter
    • 11.2.5.3 Defining the EXP_IF_NULL_ATTR_IN_CONSTRAINT Preference Parameter
    • 11.2.5.4 Defining the IGNORED_EXP_LIST Preference Parameter
    • 11.2.5.5 Defining the MANDATE_ATTR_TAGS_IN_STL Preference Parameter
    • 11.2.5.6 Defining the MAX_RECURSION_DEPTH Preference Parameter
    • 11.2.5.7 Defining the SPECIFIC_CHARACTER_SET Preference Parameter
    • 11.2.5.8 Defining the SQ_WRITE_LEN Preference Parameter
    • 11.2.5.9 Defining the VALIDATE_METADATA Preference Parameter
    • 11.2.5.10 Defining the XML_SKIP_ATTR Preference Parameter
  • 11.2.6 Creating Private Dictionary Documents
    • 11.2.6.1 Defining Private Attributes
    • 11.2.6.2 Defining Attribute Definers
    • 11.2.6.3 Retiring Private Attributes
  • 11.2.7 Creating Standard Dictionary Documents
    • 11.2.7.1 Defining Standard Attributes
    • 11.2.7.2 Retiring Standard Attributes
  • 11.2.8 Creating Stored Tag List Documents
  • 11.2.9 Creating UID Definition Documents
    • 11.2.9.1 Defining UID Definitions
    • 11.2.9.2 Retiring UID Definitions

12 Administering the DICOM Repository

• 12.1 Sample Session 1: Inserting Two Documents
• 12.2 Sample Session 2: Updating a Mapping Document
• 12.3 Sample Session 3: Deleting a Constraint Document
• 12.4 Sample Session 4: Inserting a Stored Tag List Document
  • 12.4.1 Inserting a Stored Tag List Document with a Known Set of Tags
  • 12.4.2 Generating and Inserting a Stored Tag List Document
• 12.5 Sample Session 5: Inserting a DICOM Protocol Document

13 ORD_DICOM_ADMIN Package Reference

• 13.1 Directory Definition and Setup for ORD_DICOM_ADMIN Examples
• 13.2 Important Notes for DICOM Repository Administrators
• DICOM Data Model Repository Administrator Functions
  • generateTagListDocument( ) Function
  • getDocumentContent( ) Function
• DICOM Data Model Repository Administrator Procedures
  • deleteDocument( ) Procedure
  • editDataModel( ) Procedure
  • exportDocument( ) Procedure
  • insertDocument( ) Procedure
  • publishDataModel( ) Procedure
  • rollbackDataModel( ) Procedure
• DICOM Repository Administrator Views
  • orddcm_document_refs
• General Format for DICOM Value Locators

Part IV DICOM Supplementary Information

A DICOM Configuration Documents

B DICOM XML Schemas

C DICOM Encoding Rules

• C.1 Transfer Syntax for Medical Imaging
• C.2 Definitions for Transfer Syntax Abbreviations

D DICOM Processing and Supported Formats

• D.1 DICOM Image Content and Compression Formats
  • D.1.1 DEFLATE Compression Format
  • D.1.2 JPEG-LOSSLESS Compression Format
  • D.1.3 JPEG-LS Compression Format
  • D.1.4 MPEG Compression Format
  • D.1.5 RLE Compression Format
• D.2 The frame Image Processing Operator
• D.3 Other Image Processing Operators
• D.4 Multiframe Image Processing and Creation
• D.5 Multiframe DICOM Content Processing to AVI Format
• D.6 Order of Precedence with processCopy( ) Method Arguments

E DICOM Sample Applications

• E.1 Oracle Multimedia DICOM Tutorial
• E.2 Oracle Multimedia DICOM Image Archive Demonstration

F Migrating from Oracle Database 10g Release 2 (10.2) DICOM Support

• F.1 Table Definition for Migration Examples
• F.2 Option 1: Using the DICOM Relational Interface to Migrate Applications
• F.3 Option 2: Copying Data and Rewriting Applications for DICOM
• F.4 Choosing a Migration Option

Glossary

Index