Oracle教程

Oracle 视图 DM_USER_MODELS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图（DM_USER_MODELS）提供完整信息，有助于查看用户模型（在Oracle中为虚拟存储，又称为视图）完整信息。

DM_USER_MODELS视图提供关于每个用户模型中表、字段和函数的详细信息，以及创建该模型的相关信息，如模型的归属用户以及修改时间等。它显示保存在数据字典中的模型表元数据，该元数据是支持模型的关键，它还定义的允许与模型进行交互的规则。

DM_USER_MODELS视图可用于溯源或审计，可查看用户模型相关属性，以及查看谁创建了特定模型和什么时候更改了它。

它可以作为数据库开发人员和数据库管理员来分析和维护Oracle数据库中的用户模型，以及监控及管理用户在数据库中进行何种操作。

使用DM_USER_MODELS视图可查看特定类型的信息，如模型名称、模型类型、模型的拥有者、表名、字段名、函数名等，只需执行相关的SELECT语句即可：

SELECT
FROM DM_USER_MODELS
WHERE ;

官方英文解释

DM_USER_MODELS displays information about the models in the user’s schema.

Column Datatype NULL Description

NAME

VARCHAR2(128)

NOT NULL

Name of the model

FUNCTION_NAME

VARCHAR2(30)

Model function:

  • association – Association is a descriptive mining function. An association model identifies relationships and the probability of their occurrence within a data set.

  • attribute_importance – Attribute Importance is a predictive mining function. An attribute importance model identifies the relative importance of an attribute in predicting a given outcome.

  • classification – Classification is a predictive mining function. A classification model uses historical data to predict new discrete or categorical data.

    The classification function can also be used for anomaly detection. In this case, the SVM algorithm with a null target is used (One-Class SVM).

  • clustering – Clustering is a descriptive mining function. A clustering model identifies natural groupings within a data set.

  • feature_extraction – Feature Extraction is a descriptive mining function. A feature extraction model creates an optimized data set on which to base a model.

  • regression – Regression is a predictive mining function. A regression model uses historical data to predict new continuous, numeric data.

ALGORITHM_NAME

VARCHAR2(30)

Algorithm used by the model:

  • algo_name – Setting that specifies the algorithm used by the model.

  • asso_max_rule_length – Setting that specifies the maximum length of a rule used by an association model.

  • asso_min_confidence – Setting that specifies the minimum confidence for an association model.

  • asso_min_support – Setting that specifies the minimum support for an association model.

  • clas_cost_table_name – Setting that specifies the name of the cost matrix table for a classification model.

  • clas_priors_table_name – Setting that specifies the name of the prior probability table for NB and ABN models. Decision Tree is the only classification algorithm that does not use priors.

    For SVM classification models, this setting specifies the name of a table of weights.

  • clus_num_clusters – Setting that specifies the number of clusters for a clustering model.

  • feat_num_features – Setting that specifies the number of features for a feature selection model.

CREATION_DATE

DATE

NOT NULL

Date on which the model was created

BUILD_DURATION

NUMBER

Duration of the model build process

TARGET_ATTRIBUTE

VARCHAR2(128)

Attribute designated as the target of a classification model

MODEL_SIZE

NUMBER

Size of the model (in megabytes)


数据运维技术 » Oracle 视图 DM_USER_MODELS 官方解释，作用，如何使用详细说明
分享到：

相关推荐