Oracle教程 2023-04-08

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

本站中文解释

Oracle视图ALL_MINING_MODELS用来查询拥有者(Owner)所拥有的所有数据挖掘模型的信息。ALL_MINING_MODELS视图中的所有列的信息如下：

OWNER：当前模型的拥有者
MODEL_NAME：模型的名称
ALGORITHM：模型使用的算法
PRE_PROCESSING：预处理算法
TRAINING_DATA_SOURCES：用于训练模型的数据源
TRAINING_DATA_PERCENT：用于训练模型的数据量占比
CREATION_TIME：模型创建的时间
LAST_SUCCESSFUL_REBUILD_TIME：最后一次重建模型的成功时间
SCORE_DATA_PERCENT：用于计算模型分数的数据量占比

使用方法：

可以使用SELECT语句从ALL_MINING_MODELS视图中提取指定模型的信息。例如：

SELECT * FROM all_mining_models
WHERE owner = ‘TEST_USER’
AND model_name = ‘SALES_MODEL’;

官方英文解释

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

本站中文解释

官方英文解释

相关推荐