Image, Audio, and Video Extenders Administration and Programming
Part 1. Introduction
Chapter 1. Overview
Exploiting DB2
Powerful new ways to search for information
The DB2 extenders
The SDK and run-time environments
Using the extenders
Examples
Example 1: Retrieving a video by its characteristics
Example 2: Searching for images by content
Operating environments
Chapter 2. DB2 extender concepts
Object-oriented concepts
Large objects
User-defined types
User-defined functions
UDF and UDT names
Triggers
Extender data structures
Administrative support tables
Handles
QBIC catalogs
Video indexes
Shot catalogs
Partitioned database concepts (EEE only)
Parallel processing
Scalability
Using DB2 extenders in a partitioned database environment
Security and recovery
Chapter 3. How the extenders work
An extender scenario
Starting extender services
Preparing a database
Preparing a table
Altering a table
Inserting data into a table
Selecting data from a table
Displaying and playing objects
Updating data in a table
Deleting data from a table
Part 2. Administering image, audio, and video data
Chapter 4. Administration overview
Administration tasks you can perform with the DB2 extenders
Chapter 5. Managing extender servers
Establishing the extender environments
Adding and dropping database partitions (EEE only)
Stopping and starting extender servers
Displaying server status
Creating and managing multiple server instances
Creating multiple DB2 extenders server instances
Listing instances
Running multiple instances concurrently
Setting the current instance
Removing instances
Migrating instances
Chapter 6. Preparing data objects for extender data
Enabling databases
Examples
Enabling tables
Enabling columns
Disabling data objects
Chapter 7. Redistributing extender data in a partitioned database system (EEE only)
Redistributing DB2 data
Redistributing extender data
Chapter 8. Tracking data objects and media files
Checking the status of data objects
Finding table entries that reference files
Finding files referenced by table entries
Checking if media files exist
Chapter 9. Cleaning up administrative support tables
Part 3. Programming for image, audio, and video data
Chapter 10. Programming overview
Using extender UDFs and APIs
Tasks you can perform with extender UDFs and APIs
Sample table for extender examples
Before you begin programming for DB2 extenders
Including extender definitions
Specifying UDF and UDT names
Transmitting large objects
Handling return codes
Unicode support
Chapter 11. Storing, retrieving, and updating objects
Image, audio, and video formats
Image conversion options
Storing an image, audio, or video object
DB2Image, DB2Audio, and DB2Video UDF formats
Storing an object that resides on the client
Storing an object that resides on the server
Specifying database or file storage
Identifying the format for storage
Storing an object with user-supplied attributes
Storing a thumbnail (image and video only)
Storing a comment
Retrieving an image, audio, or video object
Content UDF formats for retrieval
Retrieving an object to the client
Retrieving an object to a server file
Retrieving and using attributes
Retrieving comments
Updating an image, audio, or video object
Content UDF formats for updating
Replace UDF formats for updating
Updating an object from the client
Updating an object from the server
Specifying database or file storage for updates
Identifying the format for update
Updating an object with user-supplied attributes
Updating a thumbnail (image and video only)
Updating a comment
Chapter 12. Displaying or playing an image, audio, or video object
Using the display or play APIs
Identifying a display or play program
Specifying BLOB or file content
Specifying a wait indicator
Displaying a thumbnail-size image or video frame
Displaying a full-size image or video frame
Playing an audio or video
Chapter 13. Querying images by content
How to query by image content
Managing QBIC catalogs
Creating a QBIC catalog
Opening a QBIC catalog
Changing the auto catalog setting
Adding a feature to a QBIC catalog
Removing a feature from a QBIC catalog
Retrieving information about a QBIC catalog
Manually cataloging an image
Uncataloging an image
Recataloging images
Redistributing a QBIC catalog (EEE Only)
Closing a QBIC catalog
Deleting a QBIC catalog
QBIC catalog sample program
Building queries
Specifying a query string
Using a query object
Issuing queries by image content
Querying images
Retrieving an image score
QBIC query sample program
Chapter 14. Detecting video scene changes
What is a video scene change?
Finding and using scene changes
Shot detection data structures
Getting a shot or frame
Cataloging shots
Part 4. Reference
Chapter 15. User-defined types and user-defined functions
Schema
User-defined types
User-defined functions
AlignValue
AspectRatio
BitsPerSample
BytesPerSec
Comment
CompressType
Content
DB2Audio
DB2Image
DB2Video
Duration
Filename
FindInstrument
FindTrackName
Format
FrameRate
GetInstruments
GetTrackNames
Height
Importer
ImportTime
MaxBytesPerSec
NumAudioTracks
NumChannels
NumColors
NumFrames
NumVideoTracks
QbScoreFromName
QbScoreFromStr
QbScoreTBFromName
QbScoreTBFromStr
Replace
SamplingRate
Size
Thumbnail
TicksPerQNote
TicksPerSec
Updater
UpdateTime
Width
Chapter 16. Application programming interfaces
DBaAdminGetInaccessibleFiles
DBaAdminGetReferencedFiles
DBaAdminIsFileReferenced
DBaAdminReorgMetadata
DBaDisableColumn
DBaDisableDatabase
DBaDisableTable
DBaEnableColumn
DBaEnableDatabase
DBaEnableTable
DBaGetError
DBaGetInaccessibleFiles
DBaGetReferencedFiles
DBaIsColumnEnabled
DBaIsDatabaseEnabled
DBaIsFileReferenced
DBaIsTableEnabled
DBaPlay
DBaPrepareAttrs
DBaReorgMetadata
DBiAdminGetInaccessibleFiles
DBiAdminGetReferencedFiles
DBiAdminIsFileReferenced
DBiAdminReorgMetadata
DBiBrowse
DBiDisableColumn
DBiDisableDatabase
DBiDisableTable
DBiEnableColumn
DBiEnableDatabase
DBiEnableTable
DBiGetError
DBiGetInaccessibleFiles
DBiGetReferencedFiles
DBiIsColumnEnabled
DBiIsDatabaseEnabled
DBiIsFileReferenced
DBiIsTableEnabled
DBiPrepareAttrs
DBiReorgMetadata
DBvAdminGetInaccessibleFiles
DBvAdminGetReferencedFiles
DBvAdminIsFileReferenced
DBvAdminReorgMetadata
DBvBuildStoryboardFile
DBvBuildStoryboardTable
DBvClose
DBvCreateIndex
DBvCreateIndexFromVideo
DBvCreateShotCatalog
DBvDeleteShot
DBvDeleteShotCatalog
DBvDetectShot
DBvDisableColumn
DBvDisableDatabase
DBvDisableTable
DBvEnableColumn
DBvEnableDatabase
DBvEnableTable
DBvFrameDataTo24BitRGB
DBvGetError
DBvGetFrame
DBvGetInaccessibleFiles
DBvGetReferencedFiles
DBvInitShotControl
DBvInitStoryboardCtrl
DBvInsertShot
DBvIsColumnEnabled
DBvIsDatabaseEnabled
DBvIsFileReferenced
DBvIsIndex
DBvIsTableEnabled
DBvMergeShots
DBvOpenFile
DBvOpenHandle
DBvPlay
DBvPrepareAttrs
DBvReorgMetadata
DBvSetFrameNumber
DBvSetShotComment
DBvUpdateShot
DMBRedistribute (EEE Only)
QbAddFeature
QbCatalogColumn
QbCatalogImage
QbCloseCatalog
QbCreateCatalog
QbDeleteCatalog
QbGetCatalogInfo
QbListFeatures
QbOpenCatalog
QbQueryAddFeature
QbQueryCreate
QbQueryDelete
QbQueryGetFeatureCount
QbQueryGetString
QbQueryListFeatures
QbQueryNameCreate
QbQueryNameDelete
QbQueryNameSearch
QbQueryRemoveFeature
QbQuerySearch
QbQuerySetFeatureData
QbQuerySetFeatureWeight
QbQueryStringSearch
QbReCatalogColumn
QbRemoveFeature
QbSetAutoCatalog
QbUncatalogImage
Chapter 17. Administration commands for the client
Entering DB2 extender administration commands
Getting online help for DB2 extender commands
ADD QBIC FEATURE
CATALOG QBIC COLUMN
CLOSE QBIC CATALOG
CONNECT
CREATE QBIC CATALOG
DELETE QBIC CATALOG
DISABLE COLUMN
DISABLE DATABASE
DISABLE TABLE
DISCONNECT SERVER AT NODENUM (EEE Only)
DISCONNECT SERVER FOR DATABASE (EEE Only)
DISCONNECT SERVER FOR DATABASE AT NODENUM (EEE Only)
ENABLE COLUMN
ENABLE DATABASE
ENABLE TABLE
GET EXTENDER STATUS
GET INACCESSIBLE FILES
GET QBIC CATALOG INFO
GET REFERENCED FILES
GET SERVER STATUS
OPEN QBIC CATALOG
QUIT
RECONNECT SERVER AT NODENUM (EEE Only)
RECONNECT SERVER FOR DATABASE (EEE Only)
RECONNECT SERVER FOR DATABASE AT NODENUM (EEE Only)
REDISTRIBUTE NODEGROUP (EEE Only)
REMOVE QBIC FEATURE
REORG
SET QBIC AUTOCATALOG
START SERVER (Non-EEE Only)
STOP SERVER (Non-EEE Only)
TERMINATE
Chapter 18. Administration commands for the server
DMBICRT
DMBIDROP
DMBILIST
DMBIMIGR
DMBSTART
DMBSTAT
DMBSTOP
Chapter 19. Diagnostic information
Handling UDF return codes
Handling API return codes
SQLSTATE codes
Messages
Diagnostic tracing
Start tracing
Stop tracing
Reformat trace information
Show trace status
Part 5. Appendixes
Appendix A. Setting environment variables for DB2 extenders
How environment variables are used to resolve file names
How environment variables are used to identify display or play programs
How the DB2MMDATAPATH environment variable is used (EEE only)
Setting environment variables
Setting environment variables in AIX, HP-UX, Solaris servers and clients
Setting environment variables in OS/2 servers and clients
Setting environment variables in Windows servers and clients
Appendix B. Sample programs and media files
Sample programs
Sample image, audio, and video files
Sample Net.Data macro file
Appendix C. Notices
Trademarks
Glossary
Index
Contacting IBM
Product Information
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]