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

adding images, 2-20

advantages of using

LOB buffering, 8-16

AIFF data format, A-1, C-2

AIFF-C data format, A-2, C-3

appendToComments( ) method, 4-68, 6-70

AU data format, A-3, C-3

BFILE, 2-22, 2-23, I-6

BLOB, I-4

BLOBs in table partitions

using interMedia column objects, 8-15

BMP data format, B-1

BUFFER_POOL_KEEP parameter, 8-4

BUFFER_POOL_RECYCLE parameter, 8-4

bulk data loading methods, 8-16

CACHE option, 8-9

CALS Raster Data Format, B-2

checkProperties( ) method, 4-107, 5-30, 6-116

CHUNK option, 8-10

clearLocal method, 4-34, 5-16, 5-40, 6-35, 7-11

close( ) method, 7-54

closeSource( ) method, 4-59, 6-61

codecs, 1-4

compareComments( ) method, 4-82, 6-84

compatibility, 3-1

compatibilityInit( ) method, 3-3

compressing images, I-19

compression

formats, A-1, B-1, C-1

converting an image, 2-26

copy( ) method, 5-15

copyCommentsOut( ) method, 4-80, 6-82

copyContent( ) method, I-9

copying images, 2-25

cropping images, I-19

cutting images, I-19

data

loading multimedia, 1-13

data format, 1-6

database initialization parameter

BUFFER_POOL_KEEP, 8-4

BUFFER_POOL_RECYCLE, 8-4

DB_BLOCK_BUFFERS, 8-2, 8-4, 8-29

DB_BLOCK_SIZE, 8-2, 8-3, 8-29

LOG_BUFFER, 8-6

setting, 8-2

SHARED_POOL_RESERVED_SIZE, 8-6

SHARED_POOL_SIZE, 8-2, 8-5

DB_BLOCK_BUFFERS parameter, 8-2, 8-4, 8-29

DB_BLOCK_SIZE parameter, 8-2, 8-3, 8-29

DBA tuning tips, 8-1

DBMS_LOB package

loading data, 8-23

deleteComments method, 4-77, 6-79

deleteContent method, 4-54, 5-54, 6-56

deleteLocalContent method, 7-50

empty BLOB, I-2

Ensuring, 3-1

ensuring future compatibility

with evolving interMedia object types, 3-1

eraseFromComments( ) method, 4-76, 6-78

evolving interMedia object types

ensuring future compatibility, 3-1

examples

retrieving video data (simple read), 2-47

exceptions and error messages, H-1

export( ) method, 4-47, 5-65, 6-48, 7-37

extending interMedia

audio default format, 4-117

new audio format, 2-9, 4-120

new audio object type, 2-9

new data source, 2-58, 7-70

new image object type, 2-27

new video format, 2-48, 6-129

new video object type, 2-48

video default format, 6-126

file format, A-1, B-1, C-1

formats

compression, A-1, B-1, C-1

file, A-1, B-1, C-1

frequently asked questions (FAQ), G-1

getAllAttributes( ) method, 4-111, 6-120

getAttribute( ) method, 4-109, 6-118

getAudioDuration method, 4-100

getAudioDuration( ) method, J-15

getBFILE method, 4-55, 5-52, 6-57

getBFile method, 7-23

getBitRate method, 6-108

getCommentLength( ) method, 4-84, 6-86

getCompressionFormat( ) method, 5-37

getCompressionType method, 4-98, 6-104

getCompressionType( ) method, J-29

getContent method, 4-53, 5-51, 6-54

getContentFormat( ) method, 5-36

getContentInLob( ) method, 4-51, 6-52

getContentInTempLob( ) method, 7-47

getContentLength method, 5-34

getContentLength( ) method, 4-50, 6-51, 7-41

getDescription method, 4-23, 6-24

getEncoding method, 4-90

getEncoding( ) method, J-5

getFileFormat( ) method, 5-35

getFormat method, 4-88, 6-90

getFormat( ) method, J-3, J-17

getFrameRate method, 6-98

getFrameResolution method, 6-96

getFrameResolution( ) method, J-21

getFrameSize( ) method, 6-93, J-19

getHeight( ) method, 5-32

getLocalContent method, 7-45

getMimeType method, 4-27, 5-46, 6-28

getNumberOfChannels method, 4-91, 4-92

getNumberOfChannels( ) method, J-7

getNumberOfColors method, 6-106

getNumberOfColors( ) method, J-31

getNumberOfFrames method, 6-102

getNumberOfFrames( ) method, J-27

getSampleSize( ) method, 4-96, J-11

getSamplingRate( ) method, 4-94, J-9

getSource method, 4-37, 5-57, 6-38

getSourceAddress( ) method, 7-43

getSourceInformation method, 7-19

getSourceLocation method, 4-40, 5-59, 6-41, 7-21

getSourceName method, 4-41, 5-60, 6-42, 7-22

getSourceType method, 4-38, 5-58, 6-39, 7-20

getUpdateTime method, 4-18, 5-43, 6-19, 7-14

getVideoDuration method, 6-100

getVideoDuration( ) method, J-25

getwidth( ) method, 5-33

GIF Data Format, B-3

import( ) method, 4-42, 5-61, 6-43, 7-26, 7-28

importFrom( ) method, 4-44, 5-63, 6-45, 7-31, 7-34

init( ) method, 4-9, 5-7, 6-9

init(srcType,srcLocation,srcName) method, 4-11, 5-9, 6-11

INITIAL and NEXT parameters, 8-10

initializing interMedia column objects, 8-7

inserting images, 2-21

interchange format, 1-7

interMedia

guidelines for best performance results, 8-28

improving multimedia LOB data retrieval and update performance, 8-29

initializing column objects, 8-7

media data storage model, 1-2

objects types, 1-2

reading data from an object, 8-26

setting column object to empty, 8-7

setting column objects to NULL, 8-7

strategies with column objects, 8-6

interMedia benchmark

loading data, 8-24

reading data, 8-27

interMedia Clipboard

loading data, 8-23

interMedia column objects

tablespace, 8-8

interMedia object types evolution

ensuring future compatibility, 3-1

inverted index, 1-19

isLocal method, 4-32, 5-41, 6-33, 7-12

JFIF Data Format, B-2, B-3

loadCommentsFromFile( ) method, 4-78, 6-80

loading data

bulk methods, 8-16

interMedia benchmark, 8-24

multimedia, 1-13

using DBMS_LOB package, 8-23

using interMedia Clipboard, 1-13, 8-23

using OCI, 8-22

using PL/SQL, 1-13, 8-17

using SQL*Loader, 1-13, 8-21

loading FILE data into interMedia objects, 8-16

LOB buffering

advantages of using, 8-16

LOB index

using with interMedia column objects, 8-8

locateInComments( ) method, 4-73, 6-75

LOG_BUFFER parameter, 8-6

LOGGING option, 8-10

lossless compression, 1-7

lossy compression, 1-7

MAXEXTENTS parameter, 8-13

memory allocation

tuning, 8-4

messages, error, exceptions, H-1

methods, 4-13, 5-11, 6-13, 7-7

appendToComments( ), 4-68, 6-70

checkProperties( ), 4-107, 5-30, 6-116

clearLocal, 4-34, 5-16, 5-40, 6-35, 7-11

close( ), 7-54

closeSource( ), 4-59, 6-61

compareComments( ), 4-82, 6-84

compatibilityInit( ), 3-3

copy( ), 5-15

copyCommentsOut( ), 4-80, 6-82

deleteComments, 4-77, 6-79

deleteContent, 4-54, 5-54, 6-56

deleteLocalContent, 7-50

eraseFromComments( ), 4-76, 6-78

export( ), 4-47, 5-65, 6-48, 7-37

getAllAttributes( ), 4-111, 6-120

getAttribute( ), 4-109, 6-118

getAudioDuration, 4-100

getAudioDuration( ), J-15

getBFILE, 4-55, 5-52, 6-57

getBFile, 7-23

getBitRate, 6-108

getCommentLength( ), 4-84, 6-86

getCompressionFormat( ), 5-37

getCompressionType, 4-98, 6-104

getCompressionType( ), J-29

getContent, 4-53, 5-51, 6-54

getContentFormat( ), 5-36

getContentInLob( ), 4-51, 6-52

getContentInTempLob( ), 7-47

getContentLength, 5-34

getContentLength( ), 4-50, 6-51, 7-41

getDescription, 4-23, 6-24

getEncoding, 4-90

getEncoding( ), J-5

getFileFormat( ), 5-35

getFormat, 4-88, 6-90

getFormat( ), J-3, J-17

getFrameRate, 6-98

getFrameResolution, 6-96

getFrameResolution( ), J-21

getFrameSize( ), 6-93, J-19

getHeight( ), 5-32

getLocalContent, 7-45

getMimeType, 4-27, 5-46, 6-28

getNumberOfChannels, 4-91, 4-92

getNumberOfChannels( ), J-7

getNumberOfColors, 6-106

getNumberOfColors( ), J-31

getNumberOfFrames, 6-102

getNumberOfFrames( ), J-27

getSampleSize( ), 4-96, J-11

getSamplingRate( ), 4-94, J-9

getSource, 4-37, 5-57, 6-38

getSourceAddress( ), 7-43

getSourceInformation, 7-19

getSourceLocation, 4-40, 5-59, 6-41, 7-21

getSourceName, 4-41, 5-60, 6-42, 7-22

getSourceType, 4-38, 5-58, 6-39, 7-20

getUpdateTime, 4-18, 5-43, 6-19, 7-14

getVideoDuration, 6-100

getVideoDuration( ), J-25

getWidth( ), 5-33

import( ), 4-42, 5-61, 6-43, 7-26, 7-28

importFrom( ), 4-44, 5-63, 6-45, 7-31, 7-34

init( ), 4-9, 5-7, 6-9

init(srcType,srcLocation,srcName), 4-11, 5-9, 6-11

isLocal, 4-32, 5-41, 6-33, 7-12

loadCommentsFromFile( ), 4-78, 6-80

locateInComments( ), 4-73, 6-75

migrateFromORDImgB( ), 5-68

migrateFromORDImgF( ), 5-70

open( ), 7-52

openSource( ), 4-57, 6-59

process( ), 5-18

processAudioCommand( ), 4-114

processCommand( ), 7-64

processCopy( ), 5-22

processSourceCommand( ), 4-29, 6-30

processVideoCommand( ), 6-123

read( ), 7-59

readFromComments( ), 4-72, 6-74

readFromSource( ), 4-63, 6-65

setAudioDuration( ), 4-99

setBitRate( ), 6-107

setCompressionType( ), 4-97, 6-103

setDescription( ), 4-21, 6-22

setEncoding( ), 4-89

setFormat( ), 4-86, 6-88

setFrameRate( ), 6-97

setFrameResolution( ), 6-95

setFrameSize( ), 6-91

setKnownAttributes( ), 4-101, 6-109

setLocal, 4-33, 5-39, 6-34, 7-10

setMimeType( ), 4-25, 5-48, 6-26

setNumberOfColors( ), 6-105

setNumberOfFrames( ), 6-101

setProperties, 5-25

setProperties( ), 4-103, 6-112

setProperties( ) (XML), 4-105, 6-114

setProperties( ) for foreign images, 5-27

setSampleSize( ), 4-95

setSamplingRate( ), 4-93

setSource( ), 4-35, 5-55, 6-36

setSourceInformation( ), 7-17

setUpdateTime( ), 4-19, 5-44, 6-20, 7-15

setVideoDuration( ), 6-99

trim, 7-56

trimComments( ), 4-75, 6-77

trimSource( ), 4-61, 6-63

write( ), 7-61

writeToComments( ), 4-70, 6-72

writeToSource( ), 4-65, 6-67

migrateFromORDImgB( ) method, 5-68

migrateFromORDImgF( ) method, 5-70

multimedia LOB data retrieval and update performance

improving, 8-29

object relational technology, 1-8

object types, I-4, I-6

ORDAudio, 4-3

ORDImage, 5-3

ORDSource, 7-3

ORDVideo, 6-3

object views, 2-10, 2-29, 2-49

OCI

loading data, 8-22

open( ) method, 7-52

openSource( ) method, 4-57, 6-59

ORDAudio, 4-1

ORDAudio methods

audio attributes, 4-67, 4-85

description attribute, 4-20

mimeType attribute, 4-24

processing audio data, 4-113

source attribute, 4-28

source file operation methods, 4-56

updateTime attribute, 4-17

ORDAudio object type

reference information, 4-3

ORDImage, 5-1

ORDImage methods

updateTime attribute, 5-14

ORDImage object type

reference information, 5-3

ORDImgB object type, I-4

ORDImgF object type, I-6

ORDPLUGINS.ORDX_<srcType>_SOURCE package, 7-70

ORDPLUGINS.ORDX_DEFAULT_VIDEO package, 6-126

ORDPLUGINS.ORDX_FILE_SOURCE package, 7-66

ORDPLUGINS.ORDX_HTTP_SOURCE package, 7-68

ORDSource, 7-1

ORDSource methods

import and export operations, 7-25

local attribute, 7-9

localData, srcType, srcLocation, srcName attributes, 7-16

processing commands, 7-63

read/write operations, 7-58

source content operations, 7-40

source file operation methods, 7-51

updateTime attribute, 7-13

ORDSource object type

reference information, 7-3

ORDVideo, 6-1, 6-69

ORDVideo methods

comments attribute, 6-69

description attribute, 6-21

mimeType attribute, 6-25

processing video data, 6-122

source attribute, 6-29

source file operation methods, 6-58

updateTime attribute, 6-18

video attributes, 6-87

ORDVideo object type

reference information, 6-3

ORDX_DEFAULT_AUDIO package, 4-117

packages

ORDPLUGINS.ORDX_<srcType>_SOURCE, 7-70

ORDPLUGINS.ORDX_DEFAULT_VIDEO, 6-126

ORDPLUGINS.ORDX_FILE_SOURCE, 7-66

ORDPLUGINS.ORDX_HTTP_SOURCE, 7-68

ORDX_DEFAULT_AUDIO, 4-117

packages or PL/SQL plug-ins, 4-117, 6-126, 7-66

PCTFREE parameter, 8-14

PCTINCREASE parameter, 8-13

PCTVERSION option, 8-9

PCX Data Format, B-4

performance results

guidelines for using interMedia objects, 8-28

PICT Data Format, B-4

PL/SQL

loading data, 1-13

example, 8-17

populating rows, 2-21

process( ) method, 5-18, I-19

processAudioCommand( ) method, 4-114

processCommand( ) method, 7-64

processCopy( ) method, 5-22, I-22

processSourceCommand( ) method, 4-29, 6-30

processVideoCommand( ) method, 6-123

properties

setting, I-26

protocol, 1-7

querying rows, 2-24

Raw Pixel Data Format, B-5

read( ) method, 7-59

readFromComments( ) method, 4-72, 6-74

readFromSource( ) method, 4-63, 6-65

reading data

interMedia benchmark, 8-27

reading data from an interMedia object, 8-26

reading interMedia data

example, 8-26

reference information, 3-1, 4-1, 5-1, 6-1, 7-1