Views

The schema, SI_INFORMTN_SCHEMA, contains several views that identify the supported image formats and implementation-defined values. The privilege set on these views is PUBLIC WITH GRANT OPTION. The views are:

SI_IMAGE_FORMATS
SI_IMAGE_FORMAT_CONVERSIONS
SI_IMAGE_FORMAT_FEATURES
SI_THUMBNAIL_FORMATS
SI_VALUES

The column names, data types, and a description is provided for each of these views in the tables that follow.

Table 7-1 describes the SI _IMAGE_FORMATS view. This view identifies the supported image formats.

Table 7-1 SI_IMAGE_FORMATS View

Column Name	Data Type	Description
SI_FORMAT	VARCHAR2(SI_MaxFormatLength)	A list of the supported image formats.

Table 7-2 describes the S I_IMAGE_FORMAT_CONVERSIONS view. This view identifies the source and target image formats for which an image format conversion is supported. The short name for this view is S I_IMAGE_FORMAT_CONVRSNS.

Table 7-2 SI_IMAGE_FORMAT_CONVERSIONS View

Column Name	Data Type	Description
SI_SOURCE_FORMAT	VARCHAR2(SI_MaxFormatLength)	The format of the source image.
SI_TARGET_FORMAT	VARCHAR2(SI_MaxFormatLength)	The format of the target image.

Table 7-3 describes the SI_I MAGE_FORMAT_FEATURES view. This view identifies the image formats for which a basic feature is supported. The short name for this view is S I_IMAGE_FRMT_FTRS.

Table 7-3 SI_IMAGE_FORMAT_FEATURES View

Column Name	Data Type	Description
SI_FORMAT	VARCHAR2(SI_MaxFormatLength)	The format name.
SI_FEATURE_NAME	VARCHAR2(100)	The basic feature name that is supported by the named format. Value can be any of the following: SI_AverageColor SI_Texture SI_PositionalColor SI_ColorHistogram

Table 7-4 describes the S I_THUMBNAIL_FORMATS view. This view identifies the image formats from which thumbnail images can be derived. The short name for this view is SI _THUMBNAIL_FRMTS.

Table 7-4 SI_THUMBNAIL_FORMATS View

Column Name	Data Type	Description
SI_FORMAT	VARCHAR2(SI_MaxFormatLength)	The formats from which a thumbnail image can be derived.

Table 7-5 describes the SI_VALUES view. This view identifies the implementation-defined values.

Table 7-5 SI_VALUES View

Column Name	Data Type	Description
SI_VALUE	VARCHAR2( SI_MaxFormatLength)	The implementation-defined meta-variables. The SI_VALUES view has 8 rows where each row has one of the following SI_VALUE column values: SI_MaxContentLength is the maximum length for the binary representation of the SI_StillImage attribute. SI_MaxFeatureNameLength is the maximum length for the character representation of a basic image feature name. SI_MaxFormatLength is the maximum length for the character representation of an image format indication. SI_MaxHistogramLength is the maximum number of color/frequency pairs that are admissible in an SI_ColorHistogram feature value. SI_MaxRGBColor is the maximum value for each component of a color value that is represented by the RGB color space. SI_MaxTextureLength is the number of bytes needed for the encoded representation of an SI_Texture object. SI_MaxValueLength is the maximum length for the character representation (name) of the meta-variables in the SI_VALUES view. SI_NumberSections is the number of most significant color values that are represented by the SI_PositionalColor value.
SI_SUPPORTED_VALUE	NUMBER(38)	A column with the following values: 0 If the implementation places no limit on the meta-variable defined by SI_VALUE column or cannot determine the limit. NULL If the implementation does not support any features for which the meta-variable is applicable. Any non-NULL, nonzero value The maximum size supported by the implementation for this meta-variable.