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

1.1 Oracle8i interMedia

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 Oracle8i 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

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 Adding Comments About a Song

2.1.12 Retrieving Audio Data from a Song in a CD

2.1.13 Displaying All Comments for a Song in a CD

2.1.14 Extending interMedia to Support a New Audio Data Format

2.1.15 Extending interMedia with a New Type

2.1.16 Using Audio Types with Object Views

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 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.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 ORDPLUGINS.ORDX_AUFF_AUDIO Package

3.3.3 ORDPLUGINS.ORDX_AIFF_AUDIO Package

3.3.4 ORDPLUGINS.ORDX_AIFC_AUDIO Package

3.3.5 ORDPLUGINS.ORDX_WAVE_AUDIO Package

3.3.6 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 Video Format Packages

5.3.2 ORDPLUGINS.ORDX_DEFAULT_VIDEO Package

5.3.3 ORDPLUGINS.ORDX_AVI_VIDEO Package

5.3.4 ORDPLUGINS.ORDX_MOOV_VIDEO Package

5.3.5 ORDPLUGINS.ORDX_MPEG_VIDEO Package

5.3.6 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 Improving Multimedia LOB Data INSERT Performance

7.2 Other Bulk Loading Methods

7.3 User Guidelines for Best Performance Practices

7.4 Improving Multimedia LOB Data Retrieval and Update Performance

7.5 Setting the Maximum Number of Open BFILEs

7.6 Using LOBs in Table Partitions

A.1 Supported Audio File and Compression Formats

B.1 Supported Image File and Compression Formats

C.1 Common Concepts

C.1.1 Source and Destination Images

C.1.2 process( ) and processCopy( )

C.1.3 Operator and Value

C.1.4 Combining Operators

C.2 Image Formatting Operators

C.2.1 FileFormat

C.2.2 ContentFormat

C.2.3 CompressionFormat

C.2.4 CompressionQuality

C.3 Image Processing Operators

C.3.1 Cut

C.3.2 Scale

C.4 Format-Specific Operators

D.1 Raw Pixel Introduction

D.2 Raw Pixel Image Structure

D.3 Raw Pixel Header Field Descriptions

D.4 Raw Pixel Post-Header Gap

D.5 Raw Pixel Data Section and Pixel Data Format

D.5.1 Scanline Ordering

D.5.2 Pixel Ordering

D.5.3 Band Interleaving

D.5.4 N-Band Data

D.6 Raw Pixel Header "C" Structure

D.7 Raw Pixel Header "C" Constants

D.8 Raw Pixel PL/SQL Constants

D.9 Raw Pixel Images Using CCITT Compression

D.10 Foreign Image Support and the Raw Pixel Format

E.1 Sample Audio Scripts

E.2 Sample Program for Modifying Images or Testing the Image Installation

E.2.1 Demonstration (Demo) Installation Steps

E.2.2 Running the Demo

E.3 Sample Video Scripts

E.4 Java Demo

F.1 Object Types

F.2 Methods

F.2.1 ORDAnnotations Methods Associated with the annotations Attribute

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

Contents

Title and Copyright Information

List of Examples

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 Image Process( ) and ProcessCopy( ) Operators

D Image Raw Pixel Format

E Sample Programs

F Reference Information

G Frequently Asked Questions

H Exceptions and Error Messages

I Deprecated Image Object Types and Methods

Glossary

Index