3.1.4.2.2.1.3.27.1 Columns

  • Artículo

The DMSCHEMA_MINING_STRUCTURES rowset contains the following columns.

Name

Type

Restriction

Description

STRUCTURE_CATALOG

xsd:string

Yes

The catalog name.

STRUCTURE_SCHEMA

xsd:string

Yes

The unqualified schema name.<293>

STRUCTURE_NAME

xsd:string

Yes

The structure name.

STRUCTURE_GUID

uuid

A GUID that uniquely identifies the structure.

DESCRIPTION

xsd:string

The human-readable description of the structure.

STRUCTURE_PROPID

xsd:unsignedInt

The property ID of the structure. NULL if not supported by the server.

DATE_CREATED

xsd:dateTime

The date when the structure was created. NULL if not available from the server.

DATE_MODIFIED

xsd:dateTime

The date when the structure was last modified. NULL if not available from the server.

CREATION_STATEMENT

xsd:string

This column is optional.

The statement that was used to create the original data mining model.

IS_POPULATED

xsd:boolean

A Boolean that indicates whether the structure is populated.

True if the structure is populated; false otherwise.

LAST_PROCESSED

xsd:dateTime

The date when the structure was last processed. NULL if not available from the server.

HOLDOUT_MAXPERCENT

xsd:unsignedByte

A user-specified value that indicates the maximum percentage of the input cases that are held out as the test set.

Zero or NULL indicates no limit.

HOLDOUT_MAXCASES

xsd:unsignedLong

A user-specified value that indicates the maximum number of the input cases that are held out as the test set.

Zero or NULL indicates no limit.

HOLDOUT_SEED

xsd:unsignedLong

A user-specified value that is used as the seed for repeatable partitioning.

Zero indicates that a hash of the mining structure ID is used as the seed.

HOLDOUT_ACTUAL_SIZE

xsd:unsignedLong

If the mining structure is processed, this column indicates the actual size of the test data set, expressed in number of cases.

NULL indicates that the mining structure is not processed.

The rowset is sorted on STRUCTURE_CATALOG, STRUCTURE_SCHEMA, and STRUCTURE_NAME.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:simpleType name="uuid">
         <xsd:restriction base="xsd:string">
           <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-
                              [0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
         </xsd:restriction>
       </xsd:simpleType>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="STRUCTURE_CATALOG" name="STRUCTURE_CATALOG" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="STRUCTURE_SCHEMA" name="STRUCTURE_SCHEMA" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="STRUCTURE_NAME" name="STRUCTURE_NAME" type="xsd:string" />
           <xsd:element sql:field="STRUCTURE_GUID" name="STRUCTURE_GUID" 
                            type="uuid" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION"
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="STRUCTURE_PROPID" name="STRUCTURE_PROPID" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="DATE_CREATED" name="DATE_CREATED" 
                            type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="DATE_MODIFIED" name="DATE_MODIFIED" 
                            type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="CREATION_STATEMENT" name="CREATION_STATEMENT" 
                             type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="IS_POPULATED" name="IS_POPULATED" type="xsd:boolean" />
           <xsd:element sql:field="LAST_PROCESSED" name="LAST_PROCESSED" 
                            type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="HOLDOUT_MAXPERCENT" name="HOLDOUT_MAXPERCENT" 
                            type="xsd:unsignedByte" minOccurs="0" />
           <xsd:element sql:field="HOLDOUT_MAXCASES" name="HOLDOUT_MAXCASES" 
                            type="xsd:unsignedLong" minOccurs="0" />
           <xsd:element sql:field="HOLDOUT_SEED" name="HOLDOUT_SEED" 
                            type="xsd:unsignedLong" minOccurs="0" />
           <xsd:element sql:field="HOLDOUT_ACTUAL_SIZE" name="HOLDOUT_ACTUAL_SIZE" 
                             type="xsd:unsignedLong" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>