1. API Guide
  2. Oracle Machine Learning for SQL API Reference
  3. Data Dictionary Views
  4. ALL_MINING_MODELS

41.1 ALL_MINING_MODELS

ALL_MINING_MODELS describes the machine learning models accessible to the current user.

Mining models are schema objects created by Oracle Machine Learning for SQL.

Related Views

  • DBA_MINING_MODELS describes all machine learning models in the database.

  • USER_MINING_MODELS describes the machine learning models owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the machine learning model

MODEL_NAME

VARCHAR2(128)

NOT NULL

Name of the machine learning model

MINING_FUNCTION

VARCHAR2(30)

NOT NULL

Function of the mining model. The function identifies the class of problems that can be solved by this model. The machine learning function is specified when the model is built:

  • CLASSIFICATION

  • REGRESSION

  • CLUSTERING

  • FEATURE_EXTRACTION

  • ASSOCIATION_RULES

  • ATTRIBUTE_IMPORTANCE

  • TIME_SERIES

ALGORITHM

VARCHAR2(30)

NOT NULL

Algorithm used by the model. Each machine learning function has a default algorithm. The default can be overridden with a model setting (see *_MINING_MODEL_SETTINGS):

  • APRIORI_ASSOCIATION_RULES

  • CUR_DECOMPOSITION

  • DECISION_TREE

  • EXPECTATION_MAXIMIZATION

  • EXPLICIT_SEMANTIC_ANALYS

  • EXPONENTIAL_SMOOTHING

  • EXTENSIBLE_LANG

  • GENERALIZED_LINEAR_MODEL

  • KMEANS

  • MINIMUM_DESCRIPTION_LENGTH

  • MSET_SPRT

  • NAIVE_BAYES

  • NEURAL_NETWORK

  • NONNEGATIVE_MATRIX_FACTOR

  • O_CLUSTER

  • RANDOM_FOREST

  • SUPPORT_VECTOR_MACHINE

  • SINGULAR_VALUE_DECOMP

  • XGBOOST

ALGORITHM_TYPE

VARCHAR2(10)

NOT NULL

Algorithm type of the model

CREATION_DATE

DATE

NOT NULL

Date that the model was created

BUILD_DURATION

NUMBER

NOT NULL

Time (in seconds) of the model build process

MODEL_SIZE

NUMBER

NOT NULL

Size of the model (in megabytes)

PARTITIONED

VARCHAR2(3)

NOT NULL

Indicates whether the model is partitioned or not. Possible values:

  • YES: The model is partitioned.

  • NO: The model is not partitioned

COMMENTS

VARCHAR2(4000)

NOT NULL

Comment applied to the model with a SQL COMMENT statement

See Also:

Related Topics