Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


FIPS_DOCUMENTATION


The table below summarizes the system views that are part of the schema FIPS_DOCUMENTATION (view names appear in their unqualified form):

View name
Description
SQL_FEATURES
Lists each FIPS feature with details about Mimer SQL compliance.
SQL_SIZING
For each FIPS database construct, lists the minimum limits requirements for Entry level and Intermediate level compliance and the Mimer SQL limit.

FIPS_DOCUMENTATION.SQL_FEATURES

The SQL_FEATURES system view describes Mimer SQL compliance with each FIPS feature.

Column name
Data type
Description
FEATURE_ID
SMALLINT
The FIPS identifier for the feature.
FEATURE_NAME
CHAR(50)
The name of the FIPS feature.
CLASSIFICATION
CHAR(12)
Shows the FIPS conformance level at which the feature first becomes required.
One of:
TRANSITIONAL
INTERMEDIATE
FULL
RDA.
IS_SUPPORTED
CHAR(3)
Shows whether the FIPS feature is supported in Mimer SQL or not. One of:
YES
NO.
IS_VERIFIED
CHAR(3)
Shows whether Mimer SQL compliance has been externally verified or not. One of:
YES
NO.
FEATURE_COMMENTS
VARCHAR(500)
May contain descriptive information about Mimer SQL support for the FIPS feature.

FIPS_DOCUMENTATION.SQL_SIZING

The SQL_SIZING system view describes the minimum limits requirements for FIPS Entry and Intermediate level support and shows the Mimer SQL limits.

Column name
Data type
Description
SIZING_ID
SMALLINT
The FIPS identifier for the sizing limit.
DESCRIPTION
CHAR(50)
The description of the database construct sizing limit.
ENTRY_VALUE
INTEGER
The default Entry level sizing limit.
INTERMEDIATE_VALUE
INTEGER
The default Intermediate level sizing limit.
VALUE_SUPPORTED
INTEGER
The sizing limit supported by Mimer SQL.
SIZING_COMMENT
VARCHAR(500)
May contain comments on the sizing limit.

Standard Compliance

The table below summarizes standards compliance concerning the views in FIPS_DOCUMENTATION.

Standard
Compliance
Comments

Mimer SQL extension
These views are based on the FIPS PUB 127-2 standard.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX