IBM Books

Image, Audio, and Video Extenders Administration and Programming


Table of Contents

  • Figures

  • Tables

  • About this book
  • Who should use this book
  • How to use this book
  • Platform-specific information
  • Highlighting conventions
  • How to read the syntax diagrams
  • Related information
  • How to send your comments

  • 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 ]