Oracle interMedia Audio, Image, and Video User's Guide and Reference

1.1 Oracle interMedia Audio, Image, and Video

1.2 Audio Concepts

1.2.1 Digitized Audio

1.2.2 Audio Components

1.3 Image Concepts

1.3.1 Digitized Images

1.3.2 Image Components

1.4 Video Concepts

1.4.1 Digitized Video

1.4.2 Video Components

1.5 Object Relational Technology

1.5.1 Multimedia Object Types and Methods

1.5.2 ORDSource Object Type and Methods

1.5.2.1 Storing Multimedia Data

1.5.2.2 Querying Multimedia Data

1.5.2.3 Accessing Multimedia Data

1.6 Extending Oracle interMedia

1.6.1 Supporting Other External Sources and Other Audio, Image, and Video Data Formats

1.6.2 Supporting Audio Data Processing

1.6.3 Supporting Video Data Processing

1.7 Loading Multimedia Data into Oracle8i Using interMedia

1.8 Reading Data from a LOB

1.9 interMedia Architecture

1.9.1 interMedia Text Services

1.9.2 Annotation Services for Multimedia Data

1.9.3 Streaming Content from an Oracle Database

1.9.4 Support for Web Technologies

1.9.5 Geocoding Services

2.1 Audio Data Examples

2.1.1 Defining a Song Object

2.1.2 Creating an Object Table SongsTable

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

2.1.4 Defining the Implementation of the songList Object

2.1.5 Creating a CD Object and a CD Table

2.1.6 Inserting a Song into the SongsTable Table

2.1.7 Inserting a CD into the CdTable Table

2.1.8 Loading a Song into the SongsTable Table

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

2.1.10 Adding a CD Reference to a Song

2.1.11 Retrieving Audio Data from a Song in a CD

2.1.12 Extending interMedia to Support a New Audio Data Format

2.1.13 Extending interMedia with a New Type

2.1.14 Using Audio Types with Object Views

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

2.2 Image Data Examples

2.2.1 Adding Image Types to an Existing Table

2.2.2 Adding Image Types to a New Table

2.2.3 Inserting a Row Using BLOB Images

2.2.4 Populating a Row Using BLOB Images

2.2.5 Inserting a Row Using BFILE Images

2.2.6 Populating a Row Using BFILE Images

2.2.7 Querying a Row

2.2.8 Importing an Image from an External File into the Database

2.2.9 Copying an Image

2.2.10 Converting an Image Format

2.2.11 Copying and Converting in One Step

2.2.12 Extending interMedia with a New Type

2.2.13 Using Image Types with Object Views

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

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

2.2.16 Addressing National Language Support (NLS) Issues

2.3 Video Data Examples

2.3.1 Defining a Clip Object

2.3.2 Creating an Object Table clipsTable

2.3.3 Creating a List Object Containing a List of Clips

2.3.4 Defining the Implementation of the clipList Object

2.3.5 Creating a Video Object and a Video Table

2.3.6 Inserting a Video Clip into the clipsTable Table

2.3.7 Inserting a Row into the videoTable Table

2.3.8 Loading a Video into the clipsTable Table

2.3.9 Inserting a Reference to a Clip Object into the Clips List in the videoTable
Table

2.3.10 Inserting a Reference to a Video Object into the Clip

2.3.11 Retrieving a Video Clip from the videoTable

2.3.12 Extending interMedia to Support a New Video Data Format

2.3.13 Extending interMedia with a New Object Type

2.3.14 Using Video Types with Object Views

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

2.4 Extending interMedia to Support a New Data Source

3.1 Object Types

3.2 Methods

3.2.1 Example Table Definitions

3.2.2 ORDAudio Methods Associated with the updateTime Attribute

3.2.3 ORDAudio Methods Associated with the description Attribute

3.2.4 ORDAudio Methods Associated with the mimeType Attribute

3.2.5 ORDAudio Methods Associated with the source Attribute

3.2.6 ORDAudio Methods Associated with File-Like Operations

3.2.7 ORDAudio Methods Associated with the comments Attribute

3.2.8 ORDAudio Methods Associated with Audio Attributes Accessors

3.2.9 ORDAudio Methods Associated with Processing Audio Data

3.3 Packages or PL/SQL Plug-ins

3.3.1 ORDPLUGINS.ORDX_DEFAULT_AUDIO Package

3.3.2 Extending interMedia to Support a New Audio Data Format

4.1 Object Types

4.2 Methods

4.2.1 Example Table Definitions

4.2.2 ORDImage Methods Associated with Copy Operations

4.2.3 ORDImage Methods Associated with Process Operations

4.2.4 ORDImage Methods Associated with Properties Set and Check Operations

4.2.5 ORDImage Methods Associated with Image Attributes

4.2.6 ORDImage Methods Associated with the local Attribute

4.2.7 ORDImage Methods Associated with the date Attribute

4.2.8 ORDImage Methods Associated with the mimeType Attribute

4.2.9 ORDImage Methods Associated with the source Attribute

4.2.10 ORDImage Methods Associated with Image Migration

5.1 Object Types

5.2 Methods

5.2.1 Example Table Definitions

5.2.2 ORDVideo Methods Associated with the updateTime Attribute

5.2.3 ORDVideo Methods Associated with the description Attribute

5.2.4 ORDVideo Methods Associated with the mimeType Attribute

5.2.5 ORDVideo Methods Associated with the source Attribute

5.2.6 ORDVideo Methods Associated with File-Like Operations

5.2.7 ORDVideo Methods Associated with the comments Attribute

5.2.8 ORDVideo Methods Associated with Video Attributes Accessors

5.2.9 ORDVideo Methods Associated with Processing Video Data

5.3 Packages or PL/SQL Plug-ins

5.3.1 ORDPLUGINS.ORDX_DEFAULT_VIDEO Package

5.3.2 Extending interMedia to Support a New Video Data Format

6.1 Object Types

6.2 Methods

6.2.1 Example Table Definitions

6.2.2 ORDSource Methods Associated with the local Attribute

6.2.3 ORDSource Methods Associated with the updateTime Attribute

6.2.4 ORDSource Methods Associated with the srcType, srcLocation, and srcName Attributes

6.2.5 ORDSource Methods Associated with Import and Export Operations

6.2.6 ORDSource Methods Associated with the localData Attribute

6.2.7 ORDSource Methods Associated with File Operations

6.2.8 ORDSource Methods Associated with Read/Write Operations

6.2.9 ORDSource Methods Associated with Processing Commands to the
External Source

6.3 Packages or PL/SQL Plug-ins

6.3.1 ORDPLUGINS.ORDX_FILE_SOURCE Package

6.3.2 ORDPLUGINS.ORDX_HTTP_SOURCE Package

6.3.3 ORDPLUGINS.ORDX_<srcType>_SOURCE Package

6.3.4 Extending interMedia to Support a New Data Source

7.1 Setting Database Initialization Parameters

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

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

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

7.2.3 Segment Attributes and Physical Attributes

7.2.4 Accommodating Temporary LOBs in the Buffer Cache

7.2.5 Using interMedia Column Objects Containing BLOBs in Table Partitions

7.2.6 LOB Buffering for Client Applications

7.3 Improving Multimedia Data INSERT Performance in interMedia Objects Containing LOBs

7.4 Loading Multimedia Data Using the interMedia Clipboard

7.5 Loading Multimedia Data Using interMedia Annotator Utility

7.6 Load Results of an interMedia Benchmark

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

7.8 Read Results of an interMedia Benchmark

7.9 User Guidelines for Best Performance Results

7.10 Improving Multimedia LOB Data Retrieval and Update Performance

A.1 Supported Audio File and Compression Formats

B.1 Supported Image File and Compression Formats

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 Program for Modifying Images or Testing the Image Installation

F.2.1 Demonstration (Demo) Installation Steps

F.2.2 Running the Demo

F.3 Sample Video Scripts

F.4 Java Demo

H.1 Exceptions

H.1.1 ORDAudioExceptions Exceptions

H.1.2 ORDImageExceptions Exceptions

H.1.3 ORDVideoExceptions Exceptions

H.1.4 ORDSourceExceptions Exceptions

H.2 ORDAudio Error Messages

H.3 ORDImage Error Messages

H.4 ORDVideo Error Messages

J.1 Deprecated ORDAudio Methods

J.2 Deprecated ORDVideo Methods

Contents

Title and Copyright Information

List of Examples

List of Figures

List of Tables

Send Us Your Comments

Preface

1 Introduction

2 interMedia Examples

3 ORDAudio Reference Information

4 ORDImage Reference Information

5 ORDVideo Reference Information

6 ORDSource Reference Information

7 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 Deprecated Image Object Types and Methods

J Deprecated Audio and Video Methods

Index