Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Syntax Descriptions

What's New in Oracle Multimedia?

• New Features for Release 11.2
• Status of ORDImage Support for DICOM in Release 11.2

1 Introduction to Oracle Multimedia

• 1.1 Multimedia Object Types and Methods
• 1.2 Multimedia Storage

2 Common Methods and Notes for Oracle Multimedia Object Types

• 2.1 Examples for Common Methods
• 2.2 Embedded ORDSource Object
  • 2.2.1 Definition of the srcType Attribute
  • 2.2.2 Definition of the srcLocation Attribute
  • 2.2.3 Definition of the srcName Attribute
• 2.3 Important Notes for Common Methods
• 2.4 Important Installation and Upgrade Considerations
• Common Methods
  • clearLocal( )
  • closeSource( )
  • deleteContent( )
  • export( )
  • getBFile( )
  • getContent( )
  • getMimeType( )
  • getSource( )
  • getSourceLocation( )
  • getSourceName( )
  • getSourceType( )
  • getUpdateTime( )
  • isLocal( )
  • openSource( )
  • processSourceCommand( )
  • readFromSource( )
  • setLocal( )
  • setMimeType( )
  • setSource( )
  • setUpdateTime( )
  • trimSource( )
  • writeToSource( )

3 Oracle Multimedia ORDAudio Object Type

• 3.1 ORDAudio Object Examples
  • 3.1.1 Directory Definition for ORDAudio Object Examples
• 3.2 Important Notes for ORDAudio Methods
• ORDAudio Object Type
• ORDAudio Constructors
  • ORDAudio for BLOBs
  • ORDAudio for Other Sources
• ORDAudio Methods
  • checkProperties( )
  • getAllAttributes( )
  • getAttribute( )
  • getAudioDuration( )
  • getCompressionType( )
  • getContentLength( )
  • getContentInLob( )
  • getDescription( )
  • getEncoding( )
  • getFormat( )
  • getNumberOfChannels( )
  • getSampleSize( )
  • getSamplingRate( )
  • import( )
  • importFrom( )
  • processAudioCommand( )
  • setAudioDuration( )
  • setCompressionType( )
  • setDescription( )
  • setEncoding( )
  • setFormat( )
  • setKnownAttributes( )
  • setNumberOfChannels( )
  • setProperties( )
  • setSamplingRate( )
  • setSampleSize( )

4 Oracle Multimedia ORDDoc Object Type

• 4.1 ORDDoc Object Examples
  • 4.1.1 Directory Definition for ORDDoc Object Examples
• 4.2 Important Notes for ORDDoc Methods
• ORDDoc Object Type
• ORDDoc Constructors
  • ORDDoc for BLOBs
  • ORDDoc for Other Sources
• ORDDoc Methods
  • getContentInLob( )
  • getContentLength( )
  • getFormat( )
  • import( )
  • importFrom( )
  • setFormat( )
  • setProperties( )

5 Oracle Multimedia ORDImage Object Type

• 5.1 ORDImage Object Examples
  • 5.1.1 Directory Definition for ORDImage Object Examples
• 5.2 Important Notes for ORDImage Methods
• ORDImage Object Type
• ORDImage Constructors
  • ORDImage for BLOBs
  • ORDImage for Other Sources
• ORDImage Methods
  • applyWatermark( ) image
  • applyWatermark( ) text
  • checkProperties( )
  • copy( )
  • getCompressionFormat( )
  • getContentFormat( )
  • getContentLength( )
  • getFileFormat( )
  • getHeight( )
  • getMetadata( )
  • getWidth( )
  • import( )
  • importFrom( )
  • process( )
  • processCopy( )
  • putMetadata( )
  • setProperties( )
  • setProperties( ) for foreign images

6 Oracle Multimedia ORDVideo Object Type

• 6.1 ORDVideo Object Examples
  • 6.1.1 Directory Definition for ORDVideo Object Examples
• 6.2 Important Notes for ORDVideo Methods
• ORDVideo Object Type
• ORDVideo Constructors
  • ORDVideo for BLOBs
  • ORDVideo for Other Sources
• ORDVideo Methods
  • checkProperties( )
  • getAllAttributes( )
  • getAttribute( )
  • getBitRate( )
  • getCompressionType( )
  • getContentInLob( )
  • getContentLength( )
  • getDescription( )
  • getFormat( )
  • getFrameRate( )
  • getFrameResolution( )
  • getFrameSize( )
  • getNumberOfColors( )
  • getNumberOfFrames( )
  • getVideoDuration( )
  • import( )
  • importFrom( )
  • processVideoCommand( )
  • setBitRate( )
  • setCompressionType( )
  • setDescription( )
  • setFormat( )
  • setFrameRate( )
  • setFrameResolution( )
  • setFrameSize( )
  • setKnownAttributes( )
  • setNumberOfColors( )
  • setNumberOfFrames( )
  • setProperties( )
  • setVideoDuration( )

7 Oracle Multimedia Relational Interface

• 7.1 Purpose of the Oracle Multimedia Relational Interface
• 7.2 Examples for Relational Methods
  • 7.2.1 Directory Definitions for Relational Examples
  • 7.2.2 TAUD Table Definition
  • 7.2.3 TDOC Table Definition
  • 7.2.4 TIMG Table Definition
  • 7.2.5 TVID Table Definition
• 7.3 Important Notes for Relational Methods
• Static Methods Common to All Object Types
  • export( )
  • importFrom( )
  • importFrom( ) (all attributes)
• Static Methods Unique to the ORDAudio Object Type Relational Interface
  • getProperties( ) for BFILEs
  • getProperties( ) (all attributes) for BFILEs
  • getProperties( ) for BLOBs
  • getProperties( ) (all attributes) for BLOBs
• Static Methods Unique to the ORDDoc Object Type Relational Interface
  • getProperties( ) for BFILEs
  • getProperties( ) (all attributes) for BFILEs
  • getProperties( ) for BLOBs
  • getProperties( ) (all attributes) for BLOBs
• Static Methods Unique to the ORDImage Object Type Relational Interface
  • applyWatermark( ) image for BFILEs
  • applyWatermark( ) image for BLOBs
  • applyWatermark( ) text for BFILEs
  • applyWatermark( ) text for BLOBs
  • getMetadata( ) for BFILEs
  • getMetadata( ) for BLOBs
  • getProperties( ) for BFILEs
  • getProperties( ) (all attributes) for BFILEs
  • getProperties( ) for BLOBs
  • getProperties( ) (all attributes) for BLOBs
  • process( )
  • processCopy( ) for BFILEs
  • processCopy( ) for BLOBs
  • putMetadata( ) for BFILEs
  • putMetadata( ) for BLOBs
• Static Methods Unique to the ORDVideo Object Type Relational Interface
  • getProperties( ) for BFILEs
  • getProperties( ) (all attributes) for BFILEs
  • getProperties( ) for BLOBs
  • getProperties( ) (all attributes) for BLOBs

8 Oracle Multimedia ORDSource Object Type

• 8.1 Important Notes for ORDSource Methods
• ORDSource Object Type
• ORDSource Methods
  • clearLocal( )
  • close( )
  • deleteLocalContent( )
  • export( )
  • getBFile( )
  • getContentInTempLob( )
  • getContentLength( )
  • getLocalContent( )
  • getSourceAddress( )
  • getSourceInformation( )
  • getSourceLocation( )
  • getSourceName( )
  • getSourceType( )
  • getUpdateTime( )
  • import( )
  • importFrom( )
  • isLocal( )
  • open( )
  • processCommand( )
  • read( )
  • setLocal( )
  • setSourceInformation( )
  • setUpdateTime( )
  • trim( )
  • write( )

A Audio File and Compression Formats for Use With Oracle Multimedia

• A.1 Supported 3GP Data Format
• A.2 Supported AIFF Data Formats
• A.3 Supported AIFF-C Data Formats
• A.4 Supported AU Data Formats
• A.5 Supported Audio MPEG Data Formats
  • A.5.1 Supported MPEG1 and MPEG2 Data Formats
    • A.5.1.1 Supported ID3 Audio File Data Tagging Format
  • A.5.2 Supported MPEG4 Data Formats
• A.6 Supported RealNetworks Real Audio Data Format
• A.7 Supported WAV Data Formats
• A.8 Supported Windows Media File Format (ASF) for Audio Data

B Image File and Compression Formats for Use With Oracle Multimedia

• B.1 Image File Formats
• B.2 Image Compression Formats
• B.3 Summary of Image File Formats and Image Compression Formats
• B.4 Definitions for Abbreviations Used in the Image Format Tables

C Video File and Compression Formats for Use With Oracle Multimedia

• C.1 Apple QuickTime 3.0 Data Formats
• C.2 Microsoft Video for Windows (AVI) Data Formats
• C.3 RealNetworks Real Video Data Format
• C.4 Supported 3GP Data Format
• C.5 Supported Video MPEG Data Formats
  • C.5.1 Supported MPEG1 and MPEG2 Data Formats
  • C.5.2 Supported MPEG4 Data Formats
• C.6 Supported Windows Media File Format (ASF) for Video Data

D Oracle Multimedia Image Processing

• D.1 Common Concepts for Image Processing
  • 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.1.5 Types of Image 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 contrast
  • D.3.2 cut
  • D.3.3 flip
  • D.3.4 gamma
  • D.3.5 mirror
  • D.3.6 nometadata
  • D.3.7 page
  • D.3.8 quantize
  • D.3.9 rotate
  • D.3.10 Scaling Operators
    • D.3.10.1 fixedScale
    • D.3.10.2 maxScale
    • D.3.10.3 scale
    • D.3.10.4 xScale
    • D.3.10.5 yScale
  • D.3.11 sharpen
  • D.3.12 tiled
  • D.3.13 transparencyFillColor
• D.4 Format-Specific Operators
  • D.4.1 channelOrder
  • D.4.2 pixelOrder
  • D.4.3 scanlineOrder
  • D.4.4 inputChannels
• D.5 CMYK Image Processing
• D.6 Watermarking Operations
  • D.6.1 Adding Image Watermarks
  • D.6.2 Adding Text Watermarks
  • D.6.3 Watermark Properties

E Image Raw Pixel Format for Use With Oracle Multimedia

• 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 Language Structure
• E.7 Raw Pixel Header - C Language 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 Oracle Multimedia Metadata XML Schemas

• F.1 XML Schema for EXIF Metadata
• F.2 XML Schema for IPTC-IIM Metadata
• F.3 XML Schema for ORDImage Attributes
• F.4 XML Schema for XMP Metadata

G Exceptions for Oracle Multimedia Objects

• G.1 ORDAudioExceptions Exceptions
• G.2 ORDDocExceptions Exceptions
• G.3 ORDImageExceptions Exceptions
• G.4 ORDImageSIExceptions Exceptions
• G.5 ORDSourceExceptions Exceptions
• G.6 ORDVideoExceptions Exceptions

H init( ) Methods for Oracle Multimedia Object Types

• init( ) for ORDAudio
• init( ) for ORDDoc
• init( ) for ORDImage
• init( ) for ORDVideo
• init(srcType,srcLocation,srcName) for ORDAudio
• init(srcType,srcLocation,srcName) for ORDDoc
• init(srcType,srcLocation,srcName) for ORDImage
• init(srcType,srcLocation,srcName) for ORDVideo

I Oracle Multimedia SQL/MM Still Image Object Types

• SQL Functions and Procedures
• Internal Helper Types
• SI_AverageColor Object Type
• SI_AverageColor Constructors
  • SI_AverageColor(averageColorSpec)
  • SI_AverageColor(sourceImage)
• SI_AverageColor Method
  • SI_Score( ) for SI_AverageColor
• SI_Color Object Type
• SI_Color Constructor
• SI_Color Method
  • SI_RGBColor( )
• SI_ColorHistogram Object Type
• SI_ColorHistogram Constructors
  • SI_ColorHistogram(colors, frequencies)
  • SI_ColorHistogram(firstColor, frequency)
  • SI_ColorHistogram(sourceImage)
• SI_ColorHistogram Methods
  • SI_Append( )
  • SI_Score( ) for SI_ColorHistogram
• SI_FeatureList Object Type
• SI_FeatureList Constructor
  • SI_FeatureList( )
• SI_FeatureList Methods
  • SI_AvgClrFtr( )
  • SI_AvgClrFtrWght( )
  • SI_ClrHstgrFtr( )
  • SI_ClrHstgrFtrWght( )
  • SI_PstnlClrFtr( )
  • SI_PstnlClrFtrWght( )
  • SI_Score( ) for SI_FeatureList
  • SI_SetFeature(averageColorFeature, averageColorFeatureWeight)
  • SI_SetFeature(colorHistogramFeature, colorHistogramFeatureWeight)
  • SI_SetFeature(positionalColorFeature, positionalColorFeatureWeight)
  • SI_SetFeature(textureFeature, textureFeatureWeight)
  • SI_TextureFtr( )
  • SI_TextureFtrWght( )
• SI_PositionalColor Object Type
• SI_PositionalColor Constructor
  • SI_PositionalColor( )
• SI_PositionalColor Method
  • SI_Score( ) for SI_PositionalColor
• SI_StillImage Object Type
• SI_StillImage Constructors
  • SI_StillImage(content)
  • SI_StillImage(content, explicitFormat)
  • SI_StillImage(content, explicitFormat, height, width)
• SI_StillImage Methods
  • SI_ClearFeatures( )
  • SI_InitFeatures( )
  • SI_ChangeFormat( )
  • SI_Content( )
  • SI_ContentLength( )
  • SI_Format( )
  • SI_Height( )
  • SI_RetainFeatures( )
  • SI_SetContent( )
  • SI_Thumbnail( )
  • SI_Thumbnail(height,width)
  • SI_Width( )
• SI_Texture Object Type
• SI_Texture Constructor
  • SI_Texture( )
• SI_Texture Method
  • SI_Score( ) for SI_Texture
• Views

J Oracle Multimedia Deprecated API Components

• J.1 Image Processing Operators
• J.2 ORDImageSignature Methods
• J.3 ORDImage Support for DICOM

Index