7 SQL/MM Still Image

Oracle interMedia ("interMedia") contains the following information about object types that comply with the first edition of the ISO/IEC 13249-5:2001 SQL MM Part5:StillImage standard (commonly referred to as the SQL/MM Still Image standard):

• SI_AverageColor Object Type

  Describes the average color feature of an image.

• SI_Color Object Type

  Encapsulates color values of a digitized image.

• SI_ColorHistogram Object Type

  Describes the relative frequencies of the colors exhibited by samples of an image.

• SI_FeatureList Object Type

  Describes an image that is represented by a composite feature. The composite feature is based on up to four basic image features (SI_AverageColor, SI_ColorHistogram, SI_PositionalColor, and SI_Texture) and their associated feature weights.

• SI_PositionalColor Object Type

  Describes the positional color feature of an image. Assuming that an image is divided into n by m rectangles, the positional color feature characterizes an image by the n by m most significant colors of the rectangles.

• SI_StillImage Object Type

  Represents digital images with inherent image characteristics such as height, width, format, and so on.

• SI_Texture Object Type

  Describes the texture feature of the image characterized by the size of repeating items (coarseness), brightness variations (contrast), and predominant direction (directionality).

A public synonym with the corresponding object type name is created for each of these StillImage object types. Therefore, you do not need to specify the ORDSYS schema name when specifying a StillImage object type.

This chapter also includes the following topics:

• SQL Functions and Procedures

  Provides an overview of how the SQL functions and procedures are presented in this guide, as well as how they are created.

• Example Media Table and User Definition

  Presents the media table definition upon which the examples in this chapter are based. The examples in this chapter assume that the test media table SI_MEDIA has been created and filled with data.

• Views

  Describes the views in the SI_INFORMTN_SCHEMA that you can query for information about the supported image formats and implementation-defined values.

• Internal Helper Types

  Provides syntax for attributes that are VARRAY types.

See Oracle interMedia User's Guide for a list of ORDImage features that are not available for StillImage objects because the SQL/MM Still Image standard does not specify them.