Oracle interMedia User's Guide and Reference -- Contents

Changes to This Guide

Documentation Accessibility

1.1 Object Relational Technology

1.2 Multimedia Content Management

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.6 Video Concepts

1.6.1 Digitized Video

1.6.2 Video Components

1.7 Multimedia Object Types and Methods

1.8 Multimedia Storage

1.8.1 Storing Multimedia Data

1.8.2 Querying Multimedia Data

1.8.3 Accessing Multimedia Data

1.9 Extending Oracle interMedia

1.9.1 Supporting Other External Sources and Other Media Data Formats

1.9.2 Supporting Audio Data Processing

1.9.3 Supporting Video Data Processing

1.10 Relational Interface

1.11 Loading Multimedia Data into Oracle9i Using interMedia

1.12 Reading Data from a LOB

1.13 interMedia Architecture

1.13.1 Oracle interMedia Java Classes

1.13.2 Oracle interMedia Java Classes for Servlets and JSPs

1.13.3 Annotation Services for Multimedia Data

1.13.4 Streaming Content from an Oracle Database

1.13.5 Support for Web Technologies

1.13.6 Geocoding Services

2.1 Overview and Benefits

2.2 How Content-Based Retrieval Works

2.2.1 Color

2.2.2 Texture

2.2.3 Shape

2.3 How Matching Works

2.3.1 Weight

2.3.2 Score

2.3.3 Similarity Calculation

2.3.4 Threshold Value

2.4 Using an Index to Compare Signatures

2.5 Preparing or Selecting Images for Useful Matching

3.1 Audio Data Examples

3.1.1 Defining a Song Object

3.1.2 Creating an Object Table SongsTable

3.1.3 Creating a List Object Containing a List of References to Songs

3.1.4 Defining the Implementation of the songList Object

3.1.5 Creating a CD Object and a CD Table

3.1.6 Inserting a Song into the SongsTable Table

3.1.7 Inserting a CD into the CdTable Table

3.1.8 Loading a Song into the SongsTable Table

3.1.9 Inserting a Reference to a Song Object into the Songs List in the CdTable Table

3.1.10 Adding a CD Reference to a Song

3.1.11 Retrieving Audio Data from a Song in a CD

3.1.12 Extending interMedia to Support a New Audio Data Format

3.1.13 Extending interMedia with a New Type

3.1.14 Using Audio Types with Object Views

3.1.15 Scripts for Creating and Populating an Audio Table from a BFILE Data Source

3.2 Media Data Examples

3.2.1 Defining a Media Object

3.2.2 Creating an Object Table DocumentsTable

3.2.3 Creating a List Object Containing a List of References to Media

3.2.4 Defining the Implementation of the documentList Object

3.2.5 Creating a Library Object and a Library Table

3.2.6 Inserting Media into the DocumentsTable Table

3.2.7 Inserting a Library into the LibraryTable Table

3.2.8 Loading Media into the DocumentsTable Table

3.2.9 Inserting a Reference to a Document Object into the Documents List in the LibraryTable Table

3.2.10 Adding a Library Reference to a Document

3.2.11 Extending interMedia to Support a New Media Data Format

3.2.12 Extending interMedia with a New Type

3.2.13 Using Document Types with Object Views

3.2.14 Using the ORDDoc Object Type as a Repository

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

3.3 Image Data Examples

3.3.1 Adding Image Types to an Existing Table

3.3.2 Adding Image Types to a New Table

3.3.3 Inserting a Row Using BLOB Images

3.3.4 Populating a Row Using BLOB Images

3.3.5 Inserting a Row Using BFILE Images

3.3.6 Populating a Row Using BFILE Images

3.3.7 Querying a Row

3.3.8 Importing an Image from an External File into the Database

3.3.9 Retrieving an Image

3.3.10 Retrieving Images Similar to a Comparison Image (Content-Based Retrieval)

3.3.11 Creating a Domain Index

3.3.12 Retrieving Images Similar to a Comparison Image Using Index Operations (Indexed Content-Based Retrieval)

3.3.13 Copying an Image

3.3.14 Converting an Image Format

3.3.15 Copying and Converting in One Step

3.3.16 Extending interMedia with a New Type

3.3.17 Using Image Types with Object Views

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

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

3.3.20 Addressing Globalization Support Issues

3.4 Video Data Examples

3.4.1 Defining a Clip Object

3.4.2 Creating an Object Table ClipsTable

3.4.3 Creating a List Object Containing a List of Clips

3.4.4 Defining the Implementation of the clipList Object

3.4.5 Creating a Video Object and a Video Table

3.4.6 Inserting a Video Clip into the ClipsTable Table

3.4.7 Inserting a Row into the VideoTable Table

3.4.8 Loading a Video into the ClipsTable Table

3.4.9 Inserting a Reference to a Clip Object into the Clips List in the VideoTable Table

3.4.10 Inserting a Reference to a Video Object into the Clip

3.4.11 Retrieving a Video Clip from the VideoTable Table

3.4.12 Extending interMedia to Support a New Video Data Format

3.4.13 Extending interMedia with a New Object Type

3.4.14 Using Video Types with Object Views

3.4.15 Scripts for Creating and Populating a Video Table from a BFILE Data Source

3.5 Extending interMedia to Support a New Data Source

4.1 When and How to Call the Compatibility Initialization Function

processSourceCommand( )

init(srcType,srcLocation,srcName)

6.3 Methods

6.3.1 Example Table Definitions

getCompressionType( )

getNumberOfChannels( )

processAudioCommand( )

setAudioDuration( )

setCompressionType( )

setDescription( )

setEncoding( )

setFormat( )

setKnownAttributes( )

setNumberOfChannels( )

setProperties( )

setSamplingRate( )

setSampleSize( )

6.4 Packages or PL/SQL Plug-ins

6.4.1 ORDPLUGINS.ORDX_DEFAULT_AUDIO Package

6.4.2 Extending interMedia to Support a New Audio Data Format

init(srcType,srcLocation,srcName)

7.3 Methods

7.3.1 Example Table Definitions

7.4 Packages or PL/SQL Plug-ins

7.4.1 ORDPLUGINS.ORDX_DEFAULT_DOC Package

7.4.2 Extending interMedia to Support a New Media Data Format

8.1 ORDImage Object Types

ORDImage Object Type

8.1.1 Constructors

init( ) for ORDImage

init(srcType,srcLocation,srcName) for ORDImage

8.1.2 Methods

8.1.3 Example Table Definitions

setProperties( ) for Foreign Images

8.2 ORDImageSignature Object Type

ORDImageSignature Object Type

8.2.1 Constructors

init( ) for ORDImageSignature

8.2.3 ORDImageSignature Operators

init(srcType,srcLocation,srcName)

9.3 Methods

9.3.1 Example Table Definitions

processVideoCommand( )

setBitRate( )

setCompressionType( )

setDescription( )

setFormat( )

setFrameRate( )

setFrameResolution( )

setFrameSize( )

setKnownAttributes( )

9.4 Packages or PL/SQL Plug-ins

9.4.1 ORDPLUGINS.ORDX_DEFAULT_VIDEO Package

9.4.2 Extending interMedia to Support a New Video Data Format

10.1 Static Methods for the Relational Interface

10.1.1 Static Methods Common to All Object Types

10.1.2 Static Methods Uniquely Associated with Each Object Type

10.2 Static Methods Common to All Object Types

export( )

importFrom( )

importFrom( ) (all attributes)

10.3 Static Methods Unique to the ORDAudio Object Type Relational Interface

10.3.1 Example Table Definitions

getProperties( ) for BLOBs

getProperties( ) (all attributes) for BLOBs

getProperties( ) for BFILEs

getProperties( ) (all attributes) for BFILEs

10.4 Static Methods Unique to the ORDDoc Object Type Relational Interface

10.4.1 Example Table Definitions

getProperties( ) for BLOBs

getProperties( ) (all attributes) for BLOBs

getProperties( ) for BFILEs

getProperties( ) (all attributes) for BFILEs

10.5 Static Methods Unique to the ORDImage Object Type Relational Interface

10.5.1 Example Table Definitions

getProperties( ) for BLOBs

getProperties( ) (all attributes) for BLOBs

getProperties( ) for BFILEs

getProperties( ) (all attributes) for BFILEs

process( )

processCopy( ) for BLOBs

processCopy( ) for BFILEs

10.6 Static Methods Unique to the ORDVideo Object Type Relational Interface

10.6.1 Example Table Definitions

getProperties( ) for BLOBs

getProperties( ) (all attributes) for BLOBs

getProperties( ) for BFILEs

getProperties( ) (all attributes) for BFILEs

11.1 Setting Database Initialization Parameters

11.2 Issues to Consider in Creating Tables with interMedia Column Objects Containing BLOBs

11.2.1 Initializing Internal interMedia Column Objects Containing BLOBs to NULL or EMPTY

11.2.2 Specifying Tablespace and Storage Characteristics for interMedia Column Objects Containing BLOBs

11.2.3 Segment Attributes and Physical Attributes

11.2.4 Accommodating Temporary LOBs in the Buffer Cache

11.2.5 Using interMedia Column Objects Containing BLOBs in Table Partitions

11.2.6 LOB Buffering for Client Applications

11.3 Improving Multimedia Data INSERT Performance in interMedia Objects Containing LOBs

11.4 Loading Multimedia Data Using the interMedia Clipboard

11.5 Loading Multimedia Data Using interMedia Annotator Utility

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

11.7 Reading Results of an interMedia Benchmark

11.8 Getting the Best Performance Results

11.9 Improving Multimedia LOB Data Retrieval and Update Performance

A.1 Supported Audio File and Compression Formats

B.1 Supported Image File and Compression Formats

B.1.1 Image File Formats

B.1.2 Image Compression Formats

B.1.3 Summary of Image File Format and Image Compression Format

C.1 Supported Video File and Compression Formats

D.1 Common Concepts

D.1.1 Source and Destination Images

D.1.2 process( ) and processCopy( )

D.1.3 Operator and Value

D.1.4 Combining Operators

D.2 Image Formatting Operators

D.2.1 FileFormat

D.2.2 ContentFormat

D.2.3 CompressionFormat

D.2.4 CompressionQuality

D.3 Image Processing Operators

D.4 Format-Specific Operators

E.1 Raw Pixel Introduction

E.2 Raw Pixel Image Structure

E.3 Raw Pixel Header Field Descriptions

E.4 Raw Pixel Post-Header Gap

E.5 Raw Pixel Data Section and Pixel Data Format

E.5.1 Scanline Ordering

E.5.2 Pixel Ordering

E.5.3 Band Interleaving

E.5.4 N-Band Data

E.6 Raw Pixel Header "C" Structure

E.7 Raw Pixel Header "C" Constants

E.8 Raw Pixel PL/SQL Constants

E.9 Raw Pixel Images Using CCITT Compression

E.10 Foreign Image Support and the Raw Pixel Format

F.1 Sample Audio Scripts

F.2 Sample Document Scripts

F.3 Sample Program for Modifying Images or Testing the Image Installation

F.3.1 Demonstration (Demo) Installation Steps

F.3.2 Running the Demo

F.4 Sample Video Scripts

F.5 Java Demo

H.1 Exceptions

H.1.1 ORDAudioExceptions Exceptions

H.1.2 ORDDocExceptions Exceptions

H.1.3 ORDImageExceptions Exceptions

H.1.4 ORDVideoExceptions Exceptions

H.1.5 ORDSourceExceptions Exceptions

H.2 ORDAudio Error Messages

H.3 ORDImage Error Messages

H.4 ORDVideo Error Messages

I.1 Object Types

ORDSource Object Type

getContentInTempLob( )

setSourceInformation( )

setUpdateTime( )

trim( )

write( )

I.3 Packages or PL/SQL Plug-ins

I.3.1 ORDPLUGINS.ORDX_FILE_SOURCE Package

I.3.2 ORDPLUGINS.ORDX_HTTP_SOURCE Package

I.3.3 ORDPLUGINS.ORDX_<srcType>_SOURCE Package

I.3.4 Extending interMedia to Support a New Data Source

J.1 Deprecated Audio and Video Methods

Contents

Title and Copyright Information

List of Examples

List of Figures

List of Tables

Send Us Your Comments

Preface

1 Introduction

2 Content-Based Retrieval Concepts

3 interMedia Examples

4 Ensuring Future Compatibility with Evolving interMedia Object Types

5 Common Methods for interMedia Object Types Reference Information

6 ORDAudio Reference Information

7 ORDDoc Reference Information

8 Image Object Types Reference Information

9 ORDVideo Reference Information

10 interMedia Relational Interface Reference

11 Tuning Tips for the DBA

A Audio File and Compression Formats

B Image File and Compression Formats

C Video File and Compression Formats

D Image process( ) and processCopy( ) Operators

E Image Raw Pixel Format

F Sample Programs

G Frequently Asked Questions

H Exceptions and Error Messages

I ORDSource Reference Information

J Deprecated Methods

Index