zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

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

Oracle官方 使用 如何 详细 作用 说明 解释
2023-06-13 09:11:15 时间
本站中文解释

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.


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.


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.


我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 DM_USER_MODELS 官方解释,作用,如何使用详细说明