Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Organization

Related Documentation

Conventions

Changes to This Guide

1 Introduction to Oracle interMedia

1.1 Object Relational Technology

1.2 SQL/MM Still Image Standard Support

1.3 Multimedia Content Management

1.4 Audio Concepts

1.4.1 Digitized Audio

1.4.2 Audio Components

1.5 ORDDoc or Heterogeneous Media Data Concepts

1.5.1 Digitized Heterogeneous Media Data

1.5.2 Heterogeneous Media Data Components

1.6 Image Concepts

1.6.1 Digitized Images

1.6.2 Image Components

1.7 Video Concepts

1.7.1 Digitized Video

1.7.2 Video Components

1.8 Multimedia Storage

1.8.1 Storing Multimedia Data

1.8.2 Querying Multimedia Data

1.8.3 Accessing and Manipulating Multimedia Data

1.8.4 Metadata Extraction

1.8.5 Image Processing

1.8.6 Content-Based Retrieval of Images

1.8.7 interMedia Speech Mining and Speech Indexing

1.9 Loading Multimedia Data

1.10 Accessing Multimedia Data

1.10.1 Oracle interMedia Java Classes

1.10.2 Streaming Content from Oracle Database

1.10.3 Support for Web Technologies

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

1.10.5 interMedia Support for Java Advanced Imaging (JAI)

1.11 interMedia Architecture

1.12 Extending Oracle interMedia

2 Application Development

2.1 Developing PL/SQL Web Applications

2.2 Developing Java-Based Web Applications Using JDBC

3 Developing Media Upload and Retrieval Applications

3.1 interMedia Photo Album Sample Applications

3.1.1 Oracle interMedia PL/SQL Web Toolkit Photo Album Sample Application

3.1.1.1 Running the Photo Album Application

3.1.1.2 Description of the Photo Album Application

3.1.2 Oracle interMedia Java Servlet Photo Album Sample Application

3.1.2.1 Running the Java Servlet Photo Album Application

3.1.2.2 Description of the interMedia Java Servlet Photo Album Application

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

3.1.3.1 Running the JSP Photo Album Application

3.1.3.2 Description of the interMedia JSP Photo Album Application

3.1.4 Oracle interMedia ASP/VBScript Photo Album Sample Application

3.1.4.1 Running the ASP/VBScript Photo Album Application

3.1.4.2 Description of the ASP/VBScript Photo Album Application

3.2 interMedia Code Wizard Sample Application

3.2.1 Using the Code Wizard

3.2.1.1 Creating a New DAD or Choosing an Existing DAD

3.2.1.2 Authorizing a DAD

3.2.1.3 Creating and Testing Media Upload and Retrieval Procedures

3.2.1.4 Creating a Media Upload Procedure

3.2.1.5 Creating a Media Retrieval Procedure

3.2.1.6 Using the PL/SQL Gateway Document Table

3.2.1.7 How Time Zone Information Is Used to Support Browser Caching

3.2.2 Sample Session Using Images

3.2.3 Sample Session Using Multiple Object Columns

3.2.4 Known Restrictions of the Oracle interMedia Code Wizard

4 IMExample Java Sample Application

4.1 Overview

4.2 Compiling and Running the IMExample Application

4.3 Description of the IMExample Application

5 Content-Based Retrieval Concepts

5.1 Overview and Benefits

5.2 How Content-Based Retrieval Works

5.2.1 Color

5.2.2 Texture

5.2.3 Shape

5.3 How Matching Works

5.3.1 Weight

5.3.2 Score

5.3.3 Similarity Calculation

5.3.4 Threshold Value

5.4 Using an Index to Compare Signatures

5.5 Preparing or Selecting Images for Useful Matching

6 Custom DataSource and DataSink for JMF Versions 2.0 and 2.1

6.1 Installing and Registering Custom DataSource and DataSink

6.1.1 Registration Method 1

6.1.2 Registration Method 2

6.2 Using Custom DataSource and DataSink

6.2.1 Defining the Property File

6.2.2 Uploading Media Data

6.2.3 Retrieving Media Data

6.2.4 Accessing Media Data Through JMStudio

6.2.5 Accessing Media Data Through a JMF Application

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 Packages or PL/SQL Plug-ins

7.2.1.2 ORDPLUGINS.ORDX_DEFAULT_AUDIO Package

7.2.1.3 Extending interMedia to Support a New Audio Data Format

7.2.2 Supporting Other ORDDoc Data Formats

7.2.2.1 Packages or PL/SQL Plug-ins

7.2.2.2 ORDPLUGINS.ORDX_DEFAULT_DOC Package

7.2.2.3 Extending interMedia to Support a New Media Data Format

7.2.3 Supporting Other Video Data Formats

7.2.3.1 Packages or PL/SQL Plug-ins

7.2.3.2 ORDPLUGINS.ORDX_DEFAULT_VIDEO Package

7.2.3.3 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 Loading Multimedia Data Using a WebDAV-Compliant Client Application

8.5 Transferring Multimedia Data Using Oracle Data Pump

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

8.7 Getting the Best Performance Results

8.8 Improving Multimedia LOB Data Retrieval and Update Performance

9 interMedia Examples

9.1 Audio Data Examples

9.1.1 Using Audio Types with Object Views

9.1.2 Scripts for Populating ORDAudio Objects with BLOB Data

9.2 Media Data Examples

9.2.1 Using the ORDDoc Object Type as a Repository

9.2.2 Scripts for Creating and Populating a Media Table from a BFILE Data Source

9.3 Image Data Examples

9.3.1 Scripts for Creating and Populating an Image Table from a BFILE Data Source

9.3.2 Scripts for Populating an Image Table from an HTTP Data Source

9.3.3 Addressing Globalization Support Issues

9.4 Video Data Examples

9.5 Handling Exceptions

9.5.1 Handling interMedia Exceptions in PL/SQL

9.5.2 Handling interMedia Exceptions in Java

A Sample Programs

A.1 Sample Audio SQL Scripts

A.2 Sample ORDDoc SQL Scripts

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

A.3.1 Sample Program Installation Steps

A.3.2 Running the Program

A.4 Sample Video SQL Scripts

A.5 Java Sample Applications

A.6 Additional PL/SQL Sample Packages

A.7 Additional ASP/VBScript Sample Application

A.8 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