Index

A B C D E F G I L M O P Q R S T V W

A

adding images, 3-42

advantages of using

LOB buffering, 11-17

AIFF data format, A-1

AIFF-C data format, A-2

Apple QuickTime data format, C-2

AU data format, A-2

AVI data format, C-3

B

BFILE, 3-45, 3-46

BLOBs in table partitions

using interMedia column objects, 11-17

BUFFER_POOL_KEEP parameter, 11-5

BUFFER_POOL_RECYCLE parameter, 11-5

bulk data loading methods, 11-18

C

CACHE option, 11-11

checkProperties( ) method, 6-17, 8-15, 9-18

CHUNK option, 11-11

clearLocal( ) method, 5-5, I-9

close( ) method, I-10

closeSource( ) method, 5-6

codecs (compression and decompression schemes), 1-4

color visual attribute, 2-4

location visual attribute, 2-5

specified with location, 2-5

compatibility, 4-1

compatibilityInit( ) method, 4-3

compression

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

content-based retrieval

benefits, 2-1

example, 3-50

overview, 2-1

converting

images, 3-54

copy( ) method, 8-16

copying

images, 3-53

D

data

loading multimedia, 1-15

data format, 1-8

database initialization parameter

BUFFER_POOL_KEEP, 11-5

BUFFER_POOL_RECYCLE, 11-5

DB_BLOCK_SIZE, 11-2, 11-4, 11-29

DB_CACHE_SIZE, 11-3, 11-5, 11-29

LARGE_POOL_SIZE, 11-3

LOG_BUFFER, 11-7

setting, 11-2

SHARED_POOL_RESERVED_SIZE, 11-7

SHARED_POOL_SIZE, 11-3, 11-7

DB_BLOCK_SIZE parameter, 11-2, 11-4, 11-29

DB_CACHE_SIZE parameter, 11-3, 11-5, 11-29

DBA tuning tips, 11-1

DBMS_LOB package

loading data, 11-24

deleteContent( ) method, 5-8

deleteLocalContent method, I-12

distance, 2-8

domain index, 2-12

E

ensuring future compatibility

with evolving interMedia object types, 4-1

evaluateScore( ) method, 8-46

evolving interMedia object types

ensuring future compatibility, 4-1

examples

retrieving an image (simple read), 3-48

retrieving images similar to an image (content-based), 3-50

retrieving video data (simple read), 3-76

exceptions and error messages, H-1

export( ) method, 5-9, 10-5, I-13

extending interMedia

audio default format, 6-56

document default format, 7-29

new audio format, 3-9, 3-27, 6-59

new audio object type, 3-9, 3-28

new data source, 3-86, I-52

new document format, 7-30

new image object type, 3-55

new video format, 3-76, 9-68

new video object type, 3-77

video default format, 9-65

extensible index, 2-12

F

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

G

generateSignature( ) method, 8-48

getAllAttributes( ) method, 6-19, 9-20

getAttribute( ) method, 6-21, 9-22

getAudioDuration( ) method, 6-23

getBFILE( ) method, 5-13

getBFile( ) method, I-16

getBitRate method, 9-24

getCompressionFormat( ) method, 8-18

getCompressionType( ) method, 6-25, 9-25

getContent( ) method, 5-15

getContentFormat( ) method, 8-19

getContentInLob( ) method, 6-26, 7-14, 9-26

getContentInTempLob( ) method, I-17

getContentLength( ) method, 6-24, 7-16, 8-20, 9-28, I-19

getDescription( ) method, 6-28, 9-29

getEncoding( ) method, 6-29

getFileFormat( ) method, 8-21

getFormat( ) method, 6-30, 7-17, 9-30

getFrameRate method, 9-32

getFrameResolution method, 9-33

getFrameSize( ) method, 9-34

getHeight( ) method, 8-22

getLocalContent method, I-21

getMimeType( ) method, 5-17

getNumberOfChannels( ) method, 6-31

getNumberOfColors method, 9-36

getNumberOfFrames method, 9-37

getProperties( ) method (all attributes) for BFILEs, 10-24, 10-36, 10-48, 10-68

getProperties( ) method (all attributes) for BLOBs, 10-18, 10-31, 10-43, 10-62

getProperties( ) method for BFILEs, 10-22, 10-34, 10-46, 10-66

getProperties( ) method for BLOBs, 10-16, 10-29, 10-41, 10-60

getSampleSize( ) method, 6-32

getSamplingRate( ) method, 6-33

getSource( ) method, 5-19

getSourceAddress( ) method, I-22

getSourceInformation method, I-24

getSourceLocation( ) method, 5-21, I-25

getSourceName( ) method, 5-22, I-26

getSourceType( ) method, 5-23, I-27

getUpdateTime( ) method, 5-25, I-28

getVideoDuration method, 9-38

getWidth( ) method, 8-23

I

image

attributes, 2-2

import( ) method, 6-34, 7-18, 8-24, 9-39, I-29

importFrom( ) method, 6-36, 7-21, 8-26, 9-41, 10-8, I-31

importFrom( ) method (all attributes), 10-11

indexing signatures, 2-12

init( ) for ORDImage method, 8-7

init( ) for ORDImageSignature method, 8-44

init( ) method, 6-8, 7-6, 9-9

init(srcType,srcLocation,srcName) for ORDImage method, 8-9

init(srcType,srcLocation,srcName) method, 6-10, 7-8, 9-11

INITIAL and NEXT parameters, 11-12

initializing interMedia column objects, 11-8

inserting images, 3-43

interchange format, 1-8

interMedia

guidelines for best performance results, 11-28

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

initializing column objects, 11-8

media data storage model, 1-3

objects types, 1-3

reading data from an object, 11-25

relational functional interface, 10-1

setting column object to empty, 11-8

setting column objects to NULL, 11-8

strategies with column objects, 11-8

interMedia Clipboard

loading data, 11-25

interMedia column objects

tablespace, 11-9

interMedia object types evolution

ensuring future compatibility, 4-1

isLocal method, I-33

isLocal( ) method, 5-26

isSimilar( ) method, 8-49

L

LARGE_POOL_SIZE parameter, 11-3

loading data

bulk methods, 11-18

multimedia, 1-15

using DBMS_LOB package, 11-24

using interMedia Clipboard, 1-15, 11-25

using OCI, 11-24

using PL/SQL, 1-15, 11-18

using SQL*Loader, 1-15

loading FILE data into interMedia objects, 11-18

LOB buffering

advantages of using, 11-17

LOB index

using with interMedia column objects, 11-10

location visual attribute, 2-5

specified with color, 2-5

LOG_BUFFER parameter, 11-7

LOGGING option, 11-11

lossless compression, 1-8

lossy compression, 1-8

M

matching

preparing or selecting images for, 2-13

MAXEXTENTS parameter, 11-14

memory allocation

tuning, 11-5

messages, error, exceptions, H-1

methods, 8-45, I-6

checkProperties( ), 6-17, 8-15, 9-18

clearLocal( ), 5-5, I-9

close( ), I-10

closeSource( ), 5-6

common, 5-1

compatibilityInit( ), 4-3

copy( ), 8-16

deleteContent( ), 5-8

deleteLocalContent, I-12

evaluateScore( ), 8-46

export( ), 5-9, 10-5, I-13

for ORDDoc, 7-10

generateSignature( ), 8-48

getAllAttributes( ), 6-19, 9-20

getAttribute( ), 6-21, 9-22

getAudioDuration( ), 6-23

getBFILE( ), 5-13

getBFile( ), I-16

getBitRate, 9-24

getCompressionFormat( ), 8-18

getCompressionType( ), 6-25, 9-25

getContent( ), 5-15

getContentFormat( ), 8-19

getContentInLob( ), 6-26, 7-14, 9-26

getContentInTempLob( ), I-17

getContentLength( ), 6-24, 7-16, 8-20, 9-28, I-19

getDescription( ), 6-28, 9-29

getEncoding( ), 6-29

getFileFormat( ), 8-21

getFormat( ), 6-30, 7-17, 9-30

getFrameRate, 9-32

getFrameResolution, 9-33

getFrameSize( ), 9-34

getHeight( ), 8-22

getLocalContent, I-21

getMimeType( ), 5-17

getNumberOfChannels( ), 6-31

getNumberOfColors, 9-36

getNumberOfFrames, 9-37

getProperties( ) (all attributes) for BFILEs, 10-24, 10-36, 10-48, 10-68

getProperties( ) (all attributes) for BLOBs, 10-18, 10-31, 10-43, 10-62

getProperties( ) for BFILEs, 10-22, 10-34, 10-46, 10-66

getProperties( ) for BLOBs, 10-16, 10-29, 10-41, 10-60

getSampleSize( ), 6-32

getSamplingRate( ), 6-33

getSource( ), 5-19

getSourceAddress( ), I-22

getSourceInformation, I-24

getSourceLocation( ), 5-21, I-25

getSourceName( ), 5-22, I-26

getSourceType( ), 5-23, I-27

getUpdateTime( ), 5-25, I-28

getVideoDuration, 9-38

getWidth( ), 8-23

import( ), 6-34, 7-18, 8-24, 9-39, I-29

importFrom( ), 6-36, 7-21, 8-26, 9-41, 10-8, I-31

importFrom( ) (all attributes), 10-11

init( ), 6-8, 7-6, 9-9

init( ) for ORDImage, 8-7

init( ) for ORDImageSignature, 8-44

init(srcType,srcLocation,srcName), 6-10, 7-8, 9-11

init(srcType,srcLocation,srcName) for ORDImage, 8-9

isLocal, I-33

isLocal( ), 5-26

isSimilar( ), 8-49

open( ), I-34

openSource( ), 5-27

ORDAudio, 6-12

ORDDoc, 7-10

ORDimage, 8-10

ORDImageSignature, 8-45

ORDSource, I-6

ORDVideo, 9-13

process( ), 8-29, 10-51

processAudioCommand( ), 6-39

processCommand( ), I-36

processCopy( ), 8-34

processCopy( ) for BFILEs, 10-55

processCopy( ) for BLOBs, 10-53

processSourceCommand( ), 5-29

processVideoCommand( ), 9-44

read( ), I-38

readFromSource( ), 5-32

relational interface, 10-2

setAudioDuration( ), 6-42

setBitRate( ), 9-47

setCompressionType( ), 6-43, 9-48

setDescription( ), 6-44, 9-49

setEncoding( ), 6-46

setFormat( ), 6-47, 7-24, 9-51

setFrameRate( ), 9-53

setFrameResolution( ), 9-54

setFrameSize( ), 9-55

setKnownAttributes( ), 6-49, 9-57

setLocal, I-40

setLocal( ), 5-34

setMimeType( ), 5-35

setNumberOfChannels, 6-51

setNumberOfColors( ), 9-60

setNumberOfFrames( ), 9-61

setProperties, 8-36

setProperties( ), 6-52, 9-62

setProperties( ) (XML), 6-52, 7-26

setProperties( ) for foreign images, 8-38

setSampleSize( ), 6-55

setSamplingRate( ), 6-54

setSource( ), 5-37

setSourceInformation( ), I-41

setUpdateTime( ), 5-39, I-43

setVideoDuration( ), 9-64

trim( ), I-44

trimSource( ), 5-40

write( ), I-46

writeToSource( ), 5-42

multimedia LOB data retrieval and update performance

improving, 11-29

O

object relational technology, 1-1

object types

ORDAudio, 6-3

ORDDoc, 7-3

ORDImage, 8-3

ORDImageSignature, 8-42

ORDSource, I-3

ORDVideo, 9-3

object views, 3-10, 3-28, 3-57, 3-77

OCI

loading data, 11-24

open( ) method, I-34

openSource( ) method, 5-27

ORDAudio object type

reference information, 6-3

ORDDoc object type

reference information, 7-3

ORDImage object type

reference information, 8-3

ORDImageSignature object type

reference information, 8-42

ORDPLUGINS.ORDX_<srcType>_SOURCE package, I-52

ORDPLUGINS.ORDX_DEFAULT_VIDEO package, 9-65

ORDPLUGINS.ORDX_FILE_SOURCE package, I-48

ORDPLUGINS.ORDX_HTTP_SOURCE package, I-50

ORDSource object type

reference information, I-3

ORDVideo object type

reference information, 9-3

ORDX_DEFAULT_AUDIO package, 6-56

ORDX_DEFAULT_DOC package, 7-29

P

packages

ORDPLUGINS.ORDX_<srcType>_SOURCE, I-52

ORDPLUGINS.ORDX_DEFAULT_VIDEO, 9-65

ORDPLUGINS.ORDX_FILE_SOURCE, I-48

ORDPLUGINS.ORDX_HTTP_SOURCE, I-50

ORDX_DEFAULT_AUDIO, 6-56

ORDX_DEFAULT_DOC, 7-29

packages or PL/SQL plug-ins, 6-56, 7-29, 9-65, I-47

PCTFREE parameter, 11-15

PCTINCREASE parameter, 11-14

PCTVERSION option, 11-10

performance results

guidelines for using interMedia objects, 11-28

PL/SQL

loading data, 1-15

example, 11-18

populating rows, 3-44

preparing

images for matching, 2-13

process( ) method, 8-29, 10-51

processAudioCommand( ) method, 6-39

processCommand( ) method, I-36

processCopy( ) method, 8-34

processCopy( ) method for BFILEs, 10-55

processCopy( ) method for BLOBs, 10-53

processSourceCommand( ) method, 5-29

processVideoCommand( ) method, 9-44

protocol, 1-9

Q

querying rows, 3-46

R

read( ) method, I-38

readFromSource( ) method, 5-32

reading data from an interMedia object, 11-25

reading interMedia data

example, 11-26

reference information

ORDAudio, 6-1

ORDDoc, 7-1

ORDImage, 8-1

ORDImageSignature, 8-40

ORDSource, I-1

ORDVideo, 9-1

S

sample program, F-1, J-1

segment and physical attributes

PCTFREE parameter, 11-15

selecting

images for matching, 2-13

setAudioDuration( ) method, 6-42

setBitRate( ) method, 9-47

setCompressionType( ) method, 6-43, 9-48

setDescription( ) method, 6-44, 9-49

setEncoding( ) method, 6-46

setFormat( ) method, 6-47, 7-24, 9-51

setFrameRate( ) method, 9-53

setFrameResolution( ) method, 9-54

setFrameSize( ) method, 9-55

setKnownAttributes( ) method, 6-49, 9-57

setLocal method, I-40

setLocal( ) method, 5-34

setMimeType( ) method, 5-35

setNumberOfChannels method, 6-51

setNumberOfColors( ) method, 9-60

setNumberOfFrames( ) method, 9-61

setProperties method, 8-36

setProperties( ) method, 6-52, 9-62

setProperties( ) method (XML), 6-52, 7-26

setProperties( ) method for foreign images, 8-38

setSampleSize( ) method, 6-55

setSamplingRate( ) method, 6-54

setSource( ) method, 5-37

setSourceInformation( ) method, I-41

setting

column object to empty, 11-8

column objects to NULL, 11-8

setting database initialization parameters, 11-2

setUpdateTime( ) method, 5-39, I-43

setVideoDuration( ) method, 9-64

SGA, 11-2

database initialization parameters, 11-2

sizing, 11-2

sizing using DB_BLOCK_SIZE parameter, 11-2

sizing using DB_CACHE_SIZE parameter, 11-3

sizing using LARGE_POOL_SIZE parameter, 11-3

sizing using SHARED_POOL_SIZE parameter, 11-3

shape (visual attribute), 2-4

SHARED_POOL_RESERVED_SIZE parameter, 11-7

SHARED_POOL_SIZE parameter, 11-3, 11-7

signature, 2-2

indexing, 2-12

similarity calculation, 2-9

SQL*Loader

example loading multimedia data, 11-23

loading data, 1-15

static methods

ORDAudio relational functional interface, 10-4, 10-13

ORDDoc relational functional interface, 10-26

ORDImage relational functional interface, 10-38

ORDVideo relational functional interface, 10-56

storage characteristics

CACHE option, 11-11

CHUNK option, 11-11

DB_BLOCK_SIZE parameter, 11-4

INITIAL and NEXT parameters, 11-12

LOGGING option, 11-11

MAXEXTENTS parameter, 11-14

PCTINCREASE parameter, 11-14

PCTVERSION option, 11-10

STORAGE IN ROW clause, 11-14

strategies for column objects, 11-8

system global area

See SGA

T

table partitions

using interMedia column objects containing BLOBs, 11-17

tablespace characteristics

LOB index, 11-10

tablespace, 11-9

temporary conversions, 3-55

texture (visual attribute), 2-4

threshold, 2-11

thumbnail images, 8-33, 10-52

trim( ) method, I-44

trimSource( ) method, 5-40

tuning

memory allocation, 11-5

V

visual attributes, 2-2

W

WAV data format, A-3, A-5

weight, 2-8

write methods

write( ), I-46

writeToSource( ) method, 5-42