Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Documentation Accessibility

Related Documents

Changes to This Guide

1 Introduction to Oracle interMedia

1.1 Object Relational Technology

1.2 interMedia Capabilities

1.3 Audio Concepts

1.3.1 Digitized Audio

1.3.2 Audio Components

1.4 ORDDoc or Heterogeneous Media Data Concepts

1.4.1 Digitized Heterogeneous Media Data

1.4.2 Heterogeneous Media Data Components

1.5 Image Concepts

1.5.1 Digitized Images

1.5.2 Image Components

1.5.3 Metadata in Images

1.5.4 Metadata Extraction

1.5.5 Image Processing

1.5.6 Content-Based Retrieval of Images

1.5.7 SQL/MM Still Image Standard Support

1.6 Video Concepts

1.6.1 Digitized Video

1.6.2 Video Components

1.7 Multimedia Storage and Querying

1.7.1 Storing Multimedia Data

1.7.2 Querying Multimedia Data

1.8 Loading Multimedia Data

1.9 Accessing Multimedia Data

1.9.1 Oracle interMedia Java Classes

1.9.2 Streaming Content from Oracle Database

1.9.3 Support for Web Technologies

1.9.4 interMedia Custom DataSource and DataSink Classes for JMF 2.0/2.1

1.9.5 interMedia Support for Java Advanced Imaging (JAI)

1.10 interMedia Architecture

1.11 Extending Oracle interMedia

2 Application Development

2.1 Developing PL/SQL Client Applications Using the PL/SQL API

2.1.1 Setting Up Your Environment for PL/SQL

2.1.2 Media Query in PL/SQL

2.1.3 Media Download in PL/SQL

2.1.4 Media Upload in PL/SQL

2.1.5 Handling interMedia Exceptions in PL/SQL

2.1.5.1 Handling the Setting of Properties for Unknown Image Formats

2.1.5.2 Handling Image Processing for Unknown Image Formats

2.2 Developing PL/SQL Web Applications

2.2.1 Using the PL/SQL Gateway and PL/SQL Web Toolkit

2.3 Developing Java Client Applications Using JDBC

2.3.1 Setting Up Your Environment for Java

2.3.2 Media Retrieval in Java

2.3.3 Media Upload in Java

2.3.4 Handling interMedia Exceptions in Java

2.3.4.1 Handling the Setting of Properties for Unknown Image Formats

2.3.4.2 Handling Image Processing for Unknown Image Formats

2.4 Developing Java-Based Web Applications

2.4.1 Media Retrieval in Java-Based Web Applications

2.4.1.1 Media URL

2.4.1.2 Media Delivery Component

2.4.2 Media Upload in Java-Based Web Applications

3 Media Upload and Retrieval Web Sample Applications

3.1 Oracle interMedia PL/SQL Photo Album Sample Application

3.1.1 Running the PL/SQL Photo Album Application

3.1.2 Description of the PL/SQL Photo Album Application

3.1.2.1 Browsing the Photo Album

3.1.2.2 Adding Images to the Photo Album

3.1.2.3 Searching for Images by Keyword or Phrase

3.1.2.4 Viewing Full-Size Images

3.1.2.5 Examining Image Metadata

3.1.2.6 Writing New XMP Metadata to Images

3.1.2.7 Searching for Images That Contain Specific Metadata Attributes

3.2 Other Photo Album Sample Applications

3.2.1 Oracle interMedia Java Servlet Photo Album Sample Application

3.2.1.1 Running the Java Servlet Photo Album Application

3.2.1.2 Description of the interMedia Java Servlet Photo Album Application

3.2.2 Oracle interMedia JavaServer Pages (JSP) Photo Album Sample Application

3.2.2.1 Running the JSP Photo Album Application

3.2.2.2 Description of the interMedia JSP Photo Album Application

3.2.3 Oracle interMedia ASP/VBScript Photo Album Sample Application

3.2.3.1 Running the ASP/VBScript Photo Album Application

3.2.3.2 Description of the ASP/VBScript Photo Album Application

3.3 Oracle interMedia Code Wizard Sample Application

3.3.1 Using the Code Wizard

3.3.1.1 Creating a New DAD or Choosing an Existing DAD

3.3.1.2 Authorizing a DAD

3.3.1.3 Creating and Testing Media Upload and Retrieval Procedures

3.3.1.4 Creating a Media Upload Procedure

3.3.1.5 Creating a Media Retrieval Procedure

3.3.1.6 Using the PL/SQL Gateway Document Table

3.3.1.7 How Time Zone Information Is Used to Support Browser Caching

3.3.2 Sample Session Using Images

3.3.3 Sample Session Using Multiple Object Columns

3.3.4 Known Restrictions of the Oracle interMedia Code Wizard

4 IMExample Java Sample Application

4.1 Overview of the IMExample Application

4.2 Description of the IMExample Application

4.2.1 IMProductDialog Class

4.2.2 IMImagePanel Class

4.2.3 IMGetMetadataDialog Class

4.2.4 IMPutMetadataDialog Class

4.2.5 IMVideoPanel Class

4.2.6 IMAudioPanel Class

4.2.7 IMDocPanel Class

4.2.8 IMLoadFile Class

4.2.9 IMUtil Class

5 Working with Metadata in Images

5.1 Metadata Concepts

5.2 Oracle interMedia Image Metadata Concepts

5.3 Image File Formats

5.4 Image Metadata Formats

5.4.2 IPTC–IIM

5.5 Representing Metadata Outside Images

5.6 Oracle interMedia Image Metadata Examples

5.6.1 Creating a Table for Metadata Storage

5.6.2 Extracting Image Metadata

5.6.3 Embedding Image Metadata

5.7 Metadata References

5.8 Extracting and Mapping DICOM Metadata Attributes in Images

5.9 DICOM Image File Format

5.10 Oracle interMedia DICOM Image Metadata Example

5.10.1 Creating a Table for DICOM Metadata Storage

5.10.2 Extracting DICOM Image Metadata

5.11 DICOM References

6 Content-Based Retrieval Concepts

6.1 Overview and Benefits of Content-Based Retrieval

6.2 How Content-Based Retrieval Works

6.3 How Matching Works

6.3.3 Similarity Calculation

6.3.4 Threshold Value

6.4 Using an Index to Compare Signatures

6.5 Preparing or Selecting Images for Useful Matching

6.5.1 Image Matching Example 1

6.5.2 Image Matching Example 2

6.5.3 Image Matching Example 3

7 Extending Oracle interMedia

7.1 Supporting Other External Sources

7.1.1 Packages or PL/SQL Plug-ins

7.1.1.1 ORDPLUGINS.ORDX_FILE_SOURCE Package

7.1.1.2 ORDPLUGINS.ORDX_HTTP_SOURCE Package

7.1.1.3 Extending interMedia to Support a New Data Source

7.2 Supporting Other Media Data Formats

7.2.1 Supporting Other ORDAudio Data Formats

7.2.1.1 ORDPLUGINS.ORDX_DEFAULT_AUDIO Package

7.2.1.2 Extending interMedia to Support a New Audio Data Format

7.2.2 Supporting Other ORDDoc Data Formats

7.2.2.1 ORDPLUGINS.ORDX_DEFAULT_DOC Package

7.2.2.2 Extending interMedia to Support a New ORDDoc Data Format

7.2.3 Supporting Other Video Data Formats

7.2.3.1 ORDPLUGINS.ORDX_DEFAULT_VIDEO Package

7.2.3.2 Extending interMedia to Support a New Video Data Format

7.2.4 Supporting Other Image Data Formats

7.3 Extending interMedia with a New Type

7.4 Supporting Media Data Processing

7.4.1 Supporting Audio Data Processing

7.4.2 Supporting Video Data Processing

8 Tuning Tips for the DBA

8.1 Setting Database Initialization Parameters

8.2 Issues to Consider in Creating Tables with Column Objects Containing BLOBs

8.2.1 Initializing Internal Column Objects Containing BLOBs to NULL or EMPTY

8.2.2 Specifying Tablespace and Storage Characteristics for Column Objects Containing BLOBs

8.2.3 Segment Attributes and Physical Attributes

8.3 Improving Multimedia Data INSERT Performance in Objects Containing LOBs

8.4 Transferring Multimedia Data Using Oracle Data Pump

8.5 Reading Data from an ORDVideo Object Using the readFromSource( ) Method in a PL/SQL Script

8.6 Getting the Best Performance Results

8.7 Improving Multimedia LOB Data Retrieval and Update Performance

9 Oracle interMedia Examples

9.1 Audio Data Examples

9.1.1 Using Audio Types with Object Views

9.1.2 Scripts for Populating an ORDAudio Object with BLOB Data

9.1.2.1 Create an Audio Data Load Directory

9.1.2.2 Create and Populate the soundtable Table

9.1.2.3 Create and Populate the audio_table Table

9.1.2.4 Load the Audio Data

9.1.2.5 Copy the BLOB Data to the ORDAudio Object

9.1.2.6 Show the Properties of the Loaded Audio Data

9.1.2.7 Automate the ORDAudio Examples

9.1.2.8 Clean Up the ORDAudio Examples

9.2 Media Data Examples

9.2.1 Scripts for Populating an ORDDoc Object from a File Data Source

9.2.1.1 Create a Media Data Load Directory

9.2.1.2 Create and Populate the doc_table Table

9.2.1.3 Load the Media Data

9.2.1.4 Read the Media Data from the BLOB

9.2.1.5 Show the Properties of the Loaded Media Data

9.2.1.6 Automate the ORDDoc Examples

9.2.1.7 Clean Up the ORDDoc Examples

9.3 Image Data Examples

9.3.1 Scripts for Populating an ORDImage Object from a File Data Source

9.3.1.1 Create an Image Data Load Directory

9.3.1.2 Create and Populate the image_table Table

9.3.1.3 Load the Image Data

9.3.1.4 Read the Image Data from the BLOB

9.3.1.5 Show the Properties of the Loaded Image Data

9.3.1.6 Automate the ORDImage Examples

9.3.1.7 Clean Up the ORDImage Examples

9.3.2 Script for Loading an Image Table from an HTTP Data Source

9.3.3 Addressing Globalization Support Issues

9.4 Video Data Examples

A Sample Programs

A.1 Sample OCI C Program for Modifying Images or Testing Image Installation

A.1.1 Sample Program Installation Steps

A.1.2 Running the Program

A.2 Java Sample Applications

A.3 Additional PL/SQL Sample Packages

A.4 Additional ASP/VBScript Sample Application

A.5 Other Sample Programs

B Installing and Upgrading Oracle interMedia

B.1 Installing Oracle interMedia

B.1.1 Installation Decisions

B.1.2 Preinstallation Steps

B.1.3 Installation Steps

B.2 Upgrading an Installed Version of Oracle interMedia

B.3 Verifying an Installed Version of Oracle interMedia

B.4 Downgrading an Installed Version of Oracle interMedia

Index