eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ODM.ODM_MINING_MODEL

Object Details

Object Name:	ODM_MINING_MODEL
Object Type:	TABLE
Owner:	ODM
Subobject Name:
Status:	VALID

Populated as a result of invoking build(). Occurs at the server. Accessed by the client to retrieve the model metadata for viewing at the client, and to score and test with appropriate data.

Storage Details

Tablespace:	ODM
PCT Free:	10
PCT Used:	40

Primary Key: MINING_MODEL_PK

NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
MINING_MODEL_PK	NORMAL	UNIQUE	ODM	NAME
SYS_IL0000318088C00008$$	LOB	UNIQUE	ODM

Columns

Name	Datatype	Length	Mandatory	Comments
NAME	VARCHAR2	(64)	Yes	User provided name of the model
USER_NAME	VARCHAR2	(30)
START_TIMESTAMP	TIMESTAMP(6)	(11)
END_TIMESTAMP	TIMESTAMP(6)	(11)
FUNCTION_NAME	VARCHAR2	(64)
ALGORITHM_NAME	VARCHAR2	(64)
DATA_LOCATION	VARCHAR2	(61)
SERIALIZED_OBJECT	BLOB	(4000)		Serialized Java object for the entire model.
BIN_NUMERICAL_TABLE	VARCHAR2	(30)
BIN_CATEGORICAL_TABLE	VARCHAR2	(30)
TABLE_1	VARCHAR2	(30)		Table related to this model
TABLE_2	VARCHAR2	(30)		Table related to this model
TABLE_3	VARCHAR2	(30)		Table related to this model
TABLE_4	VARCHAR2	(30)		Table related to this model
TABLE_5	VARCHAR2	(30)
TABLE_6	VARCHAR2	(30)
TABLE_7	VARCHAR2	(30)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      USER_NAME
,      START_TIMESTAMP
,      END_TIMESTAMP
,      FUNCTION_NAME
,      ALGORITHM_NAME
,      DATA_LOCATION
,      SERIALIZED_OBJECT
,      BIN_NUMERICAL_TABLE
,      BIN_CATEGORICAL_TABLE
,      TABLE_1
,      TABLE_2
,      TABLE_3
,      TABLE_4
,      TABLE_5
,      TABLE_6
,      TABLE_7
FROM ODM.ODM_MINING_MODEL;

Dependencies

[top of page]

ODM.ODM_MINING_MODEL does not reference any database object

ODM.ODM_MINING_MODEL is referenced by following:

ODM: ODM_ABN_MODEL - show dependent code; ODM_MINING_MODEL_TRIGGER; ODM_NAIVE_BAYES_APPLY - show dependent code; ODM_NAIVE_BAYES_MODEL - show dependent code