3.1.4.2.2.1.3.27.1 Columns
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>