Oracle interMedia Audio, Image, and Video User's Guide and Reference
Release 8.1.7
Part Number A85336-01

Library
Product
Index

Go to next page

Contents

Title and Copyright Information

List of Examples

List of Figures

List of Tables

Send Us Your Comments

Preface

Audience
Organization
Related Documents
Conventions
Changes to This Guide

1 Introduction

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 interMedia Examples

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 Table
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 Ensuring Future Compatibility with Evolving interMedia Object Types

3.1 When and How to Call the Compatibility Initialization Function
compatibilityInit( ) Method

4 ORDAudio Reference Information

4.1 Object Types
ORDAudio Object Type
4.2 Constructors
init( ) Method
init(srcType,srcLocation,srcName) Method
4.3 Methods
4.3.1 Example Table Definitions
4.3.2 ORDAudio Methods Associated with the updateTime Attribute
getUpdateTime Method
setUpdateTime( ) Method
4.3.3 ORDAudio Methods Associated with the description Attribute
setDescription( ) Method
getDescription Method
4.3.4 ORDAudio Methods Associated with the mimeType Attribute
setMimeType( ) Method
getMimeType Method
4.3.5 ORDAudio Methods Associated with the source Attribute
processSourceCommand( ) Method
isLocal Method
setLocal Method
clearLocal Method
setSource( ) Method
getSource Method
getSourceType Method
getSourceLocation Method
getSourceName Method
import( ) Method
importFrom( ) Method
export( ) Method
getContentLength( ) Method
getContentInLob( ) Method
getContent Method
deleteContent Method
getBFILE Method
4.3.6 ORDAudio Methods Associated with File-Like Operations
openSource( ) Method
closeSource( ) Method
trimSource( ) Method
readFromSource( ) Method
writeToSource( ) Method
4.3.7 ORDAudio Methods Associated with the comments Attribute
appendToComments( ) Method
writeToComments( ) Method
readFromComments( ) Method
locateInComments( ) Method
trimComments( ) Method
eraseFromComments( ) Method
deleteComments Method
loadCommentsFromFile( ) Method
copyCommentsOut( ) Method
compareComments( ) Method
getCommentLength( ) Method
4.3.8 ORDAudio Methods Associated with Audio Attributes Accessors
setFormat( ) Method
getFormat Method
setEncoding( ) Method
getEncoding Method
setNumberOfChannels( ) Method
getNumberOfChannels Method
setSamplingRate( ) Method
getSamplingRate Method
setSampleSize( ) Method
getSampleSize Method
setCompressionType( ) Method
getCompressionType Method
setAudioDuration( ) Method
getAudioDuration Method
setKnownAttributes( ) Method
setProperties( ) Method
setProperties( ) Method (XML)
checkProperties( ) Method
getAttribute( ) Method
getAllAttributes( ) Method
4.3.9 ORDAudio Methods Associated with Processing Audio Data
processAudioCommand( ) Method
4.4 Packages or PL/SQL Plug-ins
4.4.1 ORDPLUGINS.ORDX_DEFAULT_AUDIO Package
4.4.2 Extending interMedia to Support a New Audio Data Format

5 ORDImage Reference Information

5.1 Object Types
ORDImage Object Type
5.2 Constructors
init( ) Method
init(srcType,srcLocation,srcName) Method
5.3 Methods
5.3.1 Example Table Definitions
5.3.2 ORDImage Methods Associated with Copy Operations
copy( ) Method
5.3.3 ORDImage Methods Associated with Process Operations
process( ) Method
processCopy( ) Method
5.3.4 ORDImage Methods Associated with Properties Set and Check Operations
setProperties Method
setProperties( ) Method for Foreign Images
checkProperties Method
5.3.5 ORDImage Methods Associated with Image Attributes
getHeight Method
getWidth Method
getContentLength Method
getFileFormat Method
getContentFormat Method
getCompressionFormat Method
5.3.6 ORDImage Methods Associated with the local Attribute
setLocal Method
clearLocal Method
isLocal Method
5.3.7 ORDImage Methods Associated with the date Attribute
getUpdateTime Method
setUpdateTime( ) Method
5.3.8 ORDImage Methods Associated with the mimeType Attribute
getMimeType Method
setMimeType( ) Method
5.3.9 ORDImage Methods Associated with the source Attribute
getContent Method
getBFILE Method
deleteContent Method
setSource( ) Method
getSource Method
getSourceType Method
getSourceLocation Method
getSourceName Method
import( ) Method
importFrom( ) Method
export( ) Method
5.3.10 ORDImage Methods Associated with Image Migration
migrateFromORDImgB( ) Method
migrateFromORDImgF( ) Method

6 ORDVideo Reference Information

6.1 Object Types
ORDVideo Object Type
6.2 Constructors
init( ) Method
init(srcType,srcLocation,srcName) Method
6.3 Methods
6.3.1 Example Table Definitions
6.3.2 ORDVideo Methods Associated with the updateTime Attribute
getUpdateTime Method
setUpdateTime( ) Method
6.3.3 ORDVideo Methods Associated with the description Attribute
setDescription( ) Method
getDescription Method
6.3.4 ORDVideo Methods Associated with the mimeType Attribute
setMimeType( ) Method
getMimeType Method
6.3.5 ORDVideo Methods Associated with the source Attribute
processSourceCommand( ) Method
isLocal Method
setLocal Method
clearLocal Method
setSource( ) Method
getSource Method
getSourceType Method
getSourceLocation Method
getSourceName Method
import( ) Method
importFrom( ) Method
export( ) Method
getContentLength( ) Method
getContentInLob( ) Method
getContent Method
deleteContent Method
getBFILE Method
6.3.6 ORDVideo Methods Associated with File-Like Operations
openSource( ) Method
closeSource( ) Method
trimSource( ) Method
readFromSource( ) Method
writeToSource( ) Method
6.3.7 ORDVideo Methods Associated with the comments Attribute
appendToComments( ) Method
writeToComments( ) Method
readFromComments( ) Method
locateInComments( ) Method
trimComments( ) Method
eraseFromComments( ) Method
deleteComments Method
loadCommentsFromFile( ) Method
copyCommentsOut( ) Method
compareComments( ) Method
getCommentLength( ) Method
6.3.8 ORDVideo Methods Associated with Video Attributes Accessors
setFormat( ) Method
getFormat Method
setFrameSize( ) Method
getFrameSize( ) Method
setFrameResolution( ) Method
getFrameResolution Method
setFrameRate( ) Method
getFrameRate Method
setVideoDuration( ) Method
getVideoDuration Method
setNumberOfFrames( ) Method
getNumberOfFrames Method
setCompressionType( ) Method
getCompressionType Method
setNumberOfColors( ) Method
getNumberOfColors Method
setBitRate( ) Method
getBitRate Method
setKnownAttributes( ) Method
setProperties( ) Method
setProperties( ) Method (XML)
checkProperties( ) Method
getAttribute( ) Method
getAllAttributes( ) Method
6.3.9 ORDVideo Methods Associated with Processing Video Data
processVideoCommand( ) Method
6.4 Packages or PL/SQL Plug-ins
6.4.1 ORDPLUGINS.ORDX_DEFAULT_VIDEO Package
6.4.2 Extending interMedia to Support a New Video Data Format

7 ORDSource Reference Information

7.1 Object Types
ORDSource Object Type
7.2 Methods
7.2.1 Example Table Definitions
7.2.2 ORDSource Methods Associated with the local Attribute
setLocal Method
clearLocal Method
isLocal Method
7.2.3 ORDSource Methods Associated with the updateTime Attribute
getUpdateTime Method
setUpdateTime( ) Method
7.2.4 ORDSource Methods Associated with the srcType, srcLocation, and srcName Attributes
setSourceInformation( ) Method
getSourceInformation Method
getSourceType Method
getSourceLocation Method
getSourceName Method
getBFile Method
7.2.5 ORDSource Methods Associated with Import and Export Operations
import( ) Method
import( ) Method (Deprecated)
importFrom( ) Method
importFrom( ) Method (Deprecated)
export( ) Method
7.2.6 ORDSource Methods Associated with the localData Attribute
getContentLength( ) Method
getSourceAddress( ) Method
getLocalContent Method
getContentInTempLob( ) Method
deleteLocalContent Method
7.2.7 ORDSource Methods Associated with File Operations
open( ) Method
close( ) Method
trim( ) Method
7.2.8 ORDSource Methods Associated with Read/Write Operations
read( ) Method
write( ) Method
7.2.9 ORDSource Methods Associated with Processing Commands to the External Source
processCommand( ) Method
7.3 Packages or PL/SQL Plug-ins
7.3.1 ORDPLUGINS.ORDX_FILE_SOURCE Package
7.3.2 ORDPLUGINS.ORDX_HTTP_SOURCE Package
7.3.3 ORDPLUGINS.ORDX_<srcType>_SOURCE Package
7.3.4 Extending interMedia to Support a New Data Source

8 Tuning Tips for the DBA

8.1 Setting Database Initialization Parameters
8.2 Issues to Consider in Creating Tables with interMedia Column Objects Containing BLOBs
8.2.1 Initializing Internal interMedia Column Objects Containing BLOBs to NULL or EMPTY
8.2.2 Specifying Tablespace and Storage Characteristics for interMedia Column Objects Containing BLOBs
8.2.3 Segment Attributes and Physical Attributes
8.2.4 Accommodating Temporary LOBs in the Buffer Cache
8.2.5 Using interMedia Column Objects Containing BLOBs in Table Partitions
8.2.6 LOB Buffering for Client Applications
8.3 Improving Multimedia Data INSERT Performance in interMedia Objects Containing LOBs
8.4 Loading Multimedia Data Using the interMedia Clipboard
8.5 Loading Multimedia Data Using interMedia Annotator Utility
8.6 Loading Results of an interMedia Benchmark
8.7 Reading Data from an ORDVideo Object Using the interMedia readFromSource( ) Method in a PL/SQL Script
8.8 Reading Results of an interMedia Benchmark
8.9 Getting the Best Performance Results
8.10 Improving Multimedia LOB Data Retrieval and Update Performance

A Audio File and Compression Formats

A.1 Supported Audio File and Compression Formats

B Image File and Compression Formats

B.1 Supported Image File and Compression Formats

C Video File and Compression Formats

C.1 Supported Video File and Compression Formats

D Image process( ) and processCopy( ) Operators

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.3.1 Cut
D.3.2 Scale
D.3.3 XScale
D.3.4 YScale
D.3.5 FixedScale
D.3.6 MaxScale
D.4 Format-Specific Operators
D.4.1 ChannelOrder
D.4.2 Interleaving
D.4.3 PixelOrder
D.4.4 ScanlineOrder
D.4.5 InputChannels

E Image Raw Pixel Format

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 Sample Programs

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

G Frequently Asked Questions

H Exceptions and Error Messages

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

I Deprecated Image Object Types and Methods

ORDImgB Object Type
ORDImgF Object Type
checkProperties Method
copyContent Method
deleteContent Method
getCompressionFormat Method
getContent Method
getContentFormat Method
getContentLength Method
getFileFormat Method
getHeight Method
getMimeType Method
getWidth Method
process Method
processCopy Method
setProperties Method
setProperties( ) Method for Foreign Images

J Deprecated Audio and Video Methods

J.1 Deprecated ORDAudio Methods
getFormat( ) Method
getEncoding( ) Method
getNumberOfChannels( ) Method
getSamplingRate( ) Method
getSampleSize( ) Method
getCompressionType( ) Method
getAudioDuration( ) Method
J.2 Deprecated ORDVideo Methods
getFormat( ) Method
getFrameSize( ) Method
getFrameResolution( ) Method
getFrameRate( ) Method
getVideoDuration( ) Method
getNumberOfFrames( ) Method
getCompressionType( ) Method
getNumberOfColors( ) Method
getBitRate( ) Method

Index

Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.

Library
Product
Index