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

adding images, 2-20

advantages of using

LOB buffering, 7-16

AIFF data format, A-1, C-2

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

appendToComments( ) method, 3-64, 5-66

AU data format, A-3, C-3

BFILE, 2-23, 2-24, I-6

BLOB, I-4

BLOBs in table partitions

using interMedia column objects, 7-15

BMP data format, B-1

BUFFER_POOL_KEEP parameter, 7-4

BUFFER_POOL_RECYCLE parameter, 7-4

bulk data loading methods, 7-16

CACHE option, 7-9

CALS Raster Data Format, B-2

checkProperties( ) method, 3-103, 4-25, 5-112

CHUNK option, 7-10

clearLocal method, 3-30, 4-11, 4-35, 5-31, 6-11

close( ) method, 6-48

closeSource( ) method, 3-55, 5-57

codecs, 1-4

compareComments( ) method, 3-78, 5-80

compressing images, I-19

compression

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

converting an image, 2-26

copy( ) method, 4-10

copyCommentsOut( ) method, 3-76, 5-78

copyContent( ) method, I-9

copying images, 2-26

cropping images, I-19

cutting images, I-19

data

loading multimedia, 1-14

data format, 1-7

database initialization parameter

BUFFER_POOL_KEEP, 7-4

BUFFER_POOL_RECYCLE, 7-4

DB_BLOCK_BUFFERS, 7-2, 7-4, 7-29

DB_BLOCK_SIZE, 7-2, 7-3, 7-29

LOG_BUFFER, 7-6

setting, 7-2

SHARED_POOL_RESERVED_SIZE, 7-6

SHARED_POOL_SIZE, 7-2, 7-5

DB_BLOCK_BUFFERS parameter, 7-2, 7-4, 7-29

DB_BLOCK_SIZE parameter, 7-2, 7-3, 7-29

DBA tuning tips, 7-1

DBMS_LOB package

loading data, 7-23

deleteComments method, 3-73, 5-75

deleteContent method, 3-49, 4-49, 5-51

deleteLocalContent method, 6-44

empty BLOB, I-2

eraseFromComments( ) method, 3-72, 5-74

examples

retrieving video data (simple read), 2-48

exceptions and error messages, H-1

export( ) method, 3-43, 4-60, 5-44, 6-32

extending interMedia

audio default format, 3-113

new audio format, 2-9, 3-116

new audio object type, 2-9

new data source, 2-59, 6-64

new image object type, 2-27

new video format, 2-49, 5-125

new video object type, 2-49

video default format, 5-122

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, 3-107, 5-116

getAttribute( ) method, 3-105, 5-114

getAudioDuration method, 3-96

getAudioDuration( ) method, J-15

getBFILE method, 3-50, 4-47, 5-52

getBFile method, 6-23

getBitRate method, 5-104

getCommentLength( ) method, 3-80, 5-82

getCompressionFormat( ) method, 4-32

getCompressionType method, 3-94, 5-100

getCompressionType( ) method, J-29

getContent method, 3-48, 4-46, 5-49

getContentFormat( ) method, 4-31

getContentInLob( ) method, 3-46, 5-47

getContentInTempLob( ) method, 6-41

getContentLength method, 4-29

getContentLength( ) method, 3-45, 5-46, 6-35

getDescription method, 3-19, 5-20

getEncoding method, 3-86

getEncoding( ) method, J-5

getFileFormat( ) method, 4-30

getFormat method, 3-84, 5-86

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

getFrameRate method, 5-94

getFrameResolution method, 5-92

getFrameResolution( ) method, J-21

getFrameSize( ) method, 5-89, J-19

getHeight( ) method, 4-27

getLocalContent method, 6-39

getMimeType method, 3-23, 4-41, 5-24

getNumberOfChannels method, 3-87, 3-88

getNumberOfChannels( ) method, J-7

getNumberOfColors method, 5-102

getNumberOfColors( ) method, J-31

getNumberOfFrames method, 5-98

getNumberOfFrames( ) method, J-27

getSampleSize( ) method, 3-92, J-11

getSamplingRate( ) method, 3-90, J-9

getSource method, 3-33, 4-52, 5-34

getSourceAddress( ) method, 6-37

getSourceInformation method, 6-19

getSourceLocation method, 3-36, 4-54, 5-37, 6-21

getSourceName method, 3-37, 4-55, 5-38, 6-22

getSourceType method, 3-34, 4-53, 5-35, 6-20

getUpdateTime method, 3-14, 4-38, 5-15, 6-14

getVideoDuration method, 5-96

getVideoDuration( ) method, J-25

getwidth( ) method, 4-28

GIF Data Format, B-2

import( ) method, 3-38, 4-56, 5-39, 6-26

importFrom( ) method, 3-40, 4-58, 5-41, 6-29

INITIAL and NEXT parameters, 7-10

initializing interMedia column objects, 7-7

inserting images, 2-21

interchange format, 1-7

interMedia

guidelines for best performance results, 7-28

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

initializing column objects, 7-7

media data storage model, 1-2

objects types, 1-2

reading data from an object, 7-26

setting column object to empty, 7-7

setting column objects to NULL, 7-7

strategies with column objects, 7-6

interMedia benchmark

loading data, 7-24

reading data, 7-27

interMedia Clipboard

loading data, 7-23

interMedia column objects

tablespace, 7-8

inverted index, 1-19

isLocal method, 3-28, 4-36, 5-29, 6-12

JFIF Data Format, B-3

loadCommentsFromFile( ) method, 3-74, 5-76

loading data

bulk methods, 7-16

interMedia benchmark, 7-24

multimedia, 1-14

using DBMS_LOB package, 7-23

using interMedia Clipboard, 1-14, 7-23

using OCI, 7-22

using PL/SQL, 1-14, 7-17

using SQL*Loader, 1-14, 7-21

loading FILE data into interMedia objects, 7-16

LOB buffering

advantages of using, 7-16

LOB index

using with interMedia column objects, 7-8

locateInComments( ) method, 3-69, 5-71

LOG_BUFFER parameter, 7-6

LOGGING option, 7-10

lossless compression, 1-7

lossy compression, 1-7

MAXEXTENTS parameter, 7-13

memory allocation

tuning, 7-4

messages, error, exceptions, H-1

methods, 3-8, 4-6, 5-9, 6-7

appendToComments( ), 3-64, 5-66

checkProperties( ), 3-103, 4-25, 5-112

clearLocal, 3-30, 4-11, 4-35, 5-31, 6-11

close( ), 6-48

closeSource( ), 3-55, 5-57

compareComments( ), 3-78, 5-80

copy( ), 4-10

copyCommentsOut( ), 3-76, 5-78

deleteComments, 3-73, 5-75

deleteContent, 3-49, 4-49, 5-51

deleteLocalContent, 6-44

eraseFromComments( ), 3-72, 5-74

export( ), 3-43, 4-60, 5-44, 6-32

getAllAttributes( ), 3-107, 5-116

getAttribute( ), 3-105, 5-114

getAudioDuration, 3-96

getAudioDuration( ), J-15

getBFILE, 3-50, 4-47, 5-52

getBFile, 6-23

getBitRate, 5-104

getCommentLength( ), 3-80, 5-82

getCompressionFormat( ), 4-32

getCompressionType, 3-94, 5-100

getCompressionType( ), J-29

getContent, 3-48, 4-46, 5-49

getContentFormat( ), 4-31

getContentInLob( ), 3-46, 5-47

getContentInTempLob( ), 6-41

getContentLength, 4-29

getContentLength( ), 3-45, 5-46, 6-35

getDescription, 3-19, 5-20

getEncoding, 3-86

getEncoding( ), J-5

getFileFormat( ), 4-30

getFormat, 3-84, 5-86

getFormat( ), J-3, J-17

getFrameRate, 5-94

getFrameResolution, 5-92

getFrameResolution( ), J-21

getFrameSize( ), 5-89, J-19

getHeight( ), 4-27

getLocalContent, 6-39

getMimeType, 3-23, 4-41, 5-24

getNumberOfChannels, 3-87, 3-88

getNumberOfChannels( ), J-7

getNumberOfColors, 5-102

getNumberOfColors( ), J-31

getNumberOfFrames, 5-98

getNumberOfFrames( ), J-27

getSampleSize( ), 3-92, J-11

getSamplingRate( ), 3-90, J-9

getSource, 3-33, 4-52, 5-34

getSourceAddress( ), 6-37

getSourceInformation, 6-19

getSourceLocation, 3-36, 4-54, 5-37, 6-21

getSourceName, 3-37, 4-55, 5-38, 6-22

getSourceType, 3-34, 4-53, 5-35, 6-20

getUpdateTime, 3-14, 4-38, 5-15, 6-14

getVideoDuration, 5-96

getVideoDuration( ), J-25

getWidth( ), 4-28

import( ), 3-38, 4-56, 5-39, 6-26

importFrom( ), 3-40, 4-58, 5-41, 6-29

isLocal, 3-28, 4-36, 5-29, 6-12

loadCommentsFromFile( ), 3-74, 5-76

locateInComments( ), 3-69, 5-71

migrateFromORDImgB( ), 4-63

migrateFromORDImgF( ), 4-65

open( ), 6-46

openSource( ), 3-53, 5-55

process( ), 4-13

processAudioCommand( ), 3-110

processCommand( ), 6-58

processCopy( ), 4-17

processSourceCommand( ), 3-25, 5-26

processVideoCommand( ), 5-119

read( ), 6-53

readFromComments( ), 3-68, 5-70

readFromSource( ), 3-59, 5-61

setAudioDuration( ), 3-95

setBitRate( ), 5-103

setCompressionType( ), 3-93, 5-99

setDescription( ), 3-17, 5-18

setEncoding( ), 3-85

setFormat( ), 3-82, 5-84

setFrameRate( ), 5-93

setFrameResolution( ), 5-91

setFrameSize( ), 5-87

setKnownAttributes( ), 3-97, 5-105

setLocal, 3-29, 4-34, 5-30, 6-10

setMimeType( ), 3-21, 4-43, 5-22

setNumberOfColors( ), 5-101

setNumberOfFrames( ), 5-97

setProperties, 4-20

setProperties( ), 3-99, 3-101, 5-108, 5-110

setProperties( ) for foreign images, 4-22

setSampleSize( ), 3-91

setSamplingRate( ), 3-89

setSource( ), 3-31, 4-50, 5-32

setSourceInformation( ), 6-17

setUpdateTime( ), 3-15, 4-39, 5-16, 6-15

setVideoDuration( ), 5-95

trim, 6-50

trimComments( ), 3-71, 5-73

trimSource( ), 3-57, 5-59

write( ), 6-55

writeToComments( ), 3-66, 5-68

writeToSource( ), 3-61, 5-63

migrateFromORDImgB( ) method, 4-63

migrateFromORDImgF( ) method, 4-65

multimedia LOB data retrieval and update performance

improving, 7-29

object relational technology, 1-9

object types, I-4, I-6

ORDAudio, 3-3

ORDImage, 4-3

object views, 2-10, 2-29, 2-50

OCI

loading data, 7-22

open( ) method, 6-46

openSource( ) method, 3-53, 5-55

ORDAudio, 3-1

reference information, 3-3

ORDAudio methods

audio attributes, 3-63, 3-81

description attribute, 3-16

mimeType attribute, 3-20

processing audio data, 3-109

source attribute, 3-24

source file operation methods, 3-52

updateTime attribute, 3-13

ORDAudio object type

reference information, 3-3

ORDImage, 4-1

reference information, 4-3, 4-6

ORDImage methods

updateTime attribute, 4-9

ORDImage object type

reference information, 4-3

ORDImgB object type, I-4

ORDImgF object type, I-6

ORDPLUGINS.ORDX_<srcType>_SOURCE package, 6-64

ORDPLUGINS.ORDX_DEFAULT_VIDEO package, 5-122

ORDPLUGINS.ORDX_FILE_SOURCE package, 6-60

ORDPLUGINS.ORDX_HTTP_SOURCE package, 6-62

ORDSource, 6-1

reference information, 6-3

ORDSource methods

import and export operations, 6-25

local attribute, 6-9

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

processing commands, 6-57

read/write operations, 6-52

source content operations, 6-34

source file operation methods, 6-45

updateTime attribute, 6-13

ORDVideo, 5-1, 5-65

reference information, 5-3

ORDVideo methods

comments attribute, 5-65

description attribute, 5-17

mimeType attribute, 5-21

processing video data, 5-118

source attribute, 5-25

source file operation methods, 5-54

updateTime attribute, 5-14

video attributes, 5-83

ORDX_DEFAULT_AUDIO package, 3-113

packages

ORDPLUGINS.ORDX_<srcType>_SOURCE, 6-64

ORDPLUGINS.ORDX_DEFAULT_VIDEO, 5-122

ORDPLUGINS.ORDX_FILE_SOURCE, 6-60

ORDPLUGINS.ORDX_HTTP_SOURCE, 6-62

ORDX_DEFAULT_AUDIO, 3-113

packages or PL/SQL plug-ins, 3-113, 5-122, 6-60

PCTFREE parameter, 7-14

PCTINCREASE parameter, 7-13

PCTVERSION option, 7-9

PCX Data Format, B-3

performance results

guidelines for using interMedia objects, 7-28

PICT Data Format, B-4

PL/SQL

loading data, 1-14

example, 7-17

populating rows, 2-22

process( ) method, 4-13, I-19

processAudioCommand( ) method, 3-110

processCommand( ) method, 6-58

processCopy( ) method, 4-17, I-22

processSourceCommand( ) method, 3-25, 5-26

processVideoCommand( ) method, 5-119

properties

setting, I-26

protocol, 1-7

querying rows, 2-24

Raw Pixel Data Format, B-4

read( ) method, 6-53

readFromComments( ) method, 3-68, 5-70

readFromSource( ) method, 3-59, 5-61

reading data

interMedia benchmark, 7-27

reading data from an interMedia object, 7-26

reading interMedia data

example, 7-26

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