Oracle | DBMS_DATA_MINING

Oracle DBMS_DATA_MINING_TRANSFORM Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose The following is extracted from dbmsdmxf.sql.

The main principle behind the design of this package is a fact that SQL has enough power to efficiently perform most of the common mining xforms. For example, binning can be done using CASE expression or DECODE function, and linear normalization is just a simple algebraic expression of the form (x - shift)/scale. However, the queries that perform the xforms can be rather lengthy, thus it seems quite desirable to have some convenience routines that will help in query generation. Thus, the goal of this package is to provide query generation services for the most common mining xforms, as well as to provide a framework that can be easily extended for implementing other xforms.

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
Nested Column
nest_num_col_type	NUMBER;	100001
nest_cat_col_type	NUMBER;	100002
nest_bd_col_type	NUMBER;	100003
nest_bf_col_type	NUMBER;	100004
nest_nums_col_name	VARCHAR2(30);	'DM_NESTED_NUMERICALS'
nest_cats_col_name	VARCHAR2(30);	'DM_NESTED_CATEGORICALS'
nest_bds_col_name	VARCHAR2(30);	'DM_NESTED_BINARY_DOUBLES'
nest_bfs_col_name	VARCHAR2(30);	'DM_NESTED_BINARY_FLOATS'

Data Types TYPE column_list IS VARRAY(1000) OF dbms_quoted_id; TYPE expression_rec IS RECORD ( lstmt dbms_sql.VARCHAR2A, lb BINARY_INTEGER DEFAULT 1, ub BINARY_INTEGER DEFAULT 0); TYPE transform_list IS TABLE OF TRANSFORM_REC; TYPE transform_rec IS RECORD ( attribute_name dbms_quoted_id, attribute_subname VARCHAR2(4000), expression EXPRESSION_REC, reverse_expression EXPRESSION_REC, attribute_spec VARCHAR2(4000)); SUBTYPE DESCRIBE_LIST IS dbms_sql.desc_tab2; SUBTYPE DESCRIBE_LIST3 IS dbms_sql.desc_tab3;

Dependencies

DBMS_DATA_MINING	DMP_SEC	ODM_MODEL_UTIL
DBMS_DATA_MINING_INTERNAL	DMP_SYS

Documented Yes

First Available Not known

Pragmas SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsdmxf.sql
{ORACLE_HOME}/rdbms/admin/prvtdmxf.plb

Subprograms

CREATE_BIN_CAT	INSERT_CLIP_TRIM_TAIL	STACK_MISS_CAT
CREATE_BIN_NUM	INSERT_CLIP_WINSOR_TAIL	STACK_MISS_NUM
CREATE_CLIP	INSERT_MISS_CAT_MODE	STACK_NORM_LIN
CREATE_COL_REM	INSERT_MISS_NUM_MEAN	XFORM_BIN_CAT
CREATE_MISS_CAT	INSERT_NORM_LIN_MINMAX	XFORM_BIN_NUM
CREATE_MISS_NUM	INSERT_NORM_LIN_SCALE	XFORM_CLIP
CREATE_NORM_LIN	INSERT_NORM_LIN_ZSCORE	XFORM_COL_REM
DESCRIBE_STACK	SET_EXPRESSION	XFORM_EXPR_NUM
GET_EXPRESSION	SET_TRANSFORM	XFORM_EXPR_STR
INSERT_AUTOBIN_NUM_EQWIDTH	STACK_BIN_CAT	XFORM_MISS_CAT
INSERT_BIN_CAT_FREQ	STACK_BIN_NUM	XFORM_MISS_NUM
INSERT_BIN_NUM_EQWIDTH	STACK_CLIP	XFORM_NORM_LIN
INSERT_BIN_NUM_QTILE	STACK_COL_REM	XFORM_STACK
INSERT_BIN_SUPER

CREATE_BIN_CAT

Creates categorical binning definition table dbms_data_mining_transform.create_bin_cat( bin_table_name IN VARCHAR2, bin_schema_name IN VARCHAR2 DEFAULT NULL);

exec dbms_data_mining_transform.create_bin_cat('DMTXCBC', 'C##SAFEDBA');

      

      PL/SQL procedure successfully completed.

      

      SQL> desc c##safedba.dmtxcbc

      Name               Null?    Type

      ------------------ -------- --------------

      COL                         VARCHAR2(128)

      ATT                         VARCHAR2(4000)

      VAL                         VARCHAR2(4000)

      BIN                         VARCHAR2(4000)

CREATE_BIN_NUM

Creates numerical binning definition table dbms_data_mining_transform.create_bin_num( bin_table_name IN VARCHAR2, bin_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(create_bin_num, AUTO_WITH_COMMIT);

exec dbms_data_mining_transform.create_bin_num('DMTXCBN', 'C##SAFEDBA');

      

      PL/SQL procedure successfully completed.

      

      SQL> desc c##safedba.dmtxcbn

      Name               Null?    Type

      ------------------ -------- --------------

      COL                         VARCHAR2(128)

      ATT                         VARCHAR2(4000)

      VAL                         NUMBER

      BIN                         VARCHAR2(4000)

CREATE_CLIP

Creates clipping definition table dbms_data_mining_transform.create_clip( clip_table_name IN VARCHAR2, clip_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(create_clip, AUTO_WITH_COMMIT);

exec dbms_data_mining_transform.create_clip('DMTXCC', 'C##SAFEDBA');

      

      PL/SQL procedure successfully completed.

      

      SQL> desc c##safedba.dmtxcc

      Name               Null?    Type

      ------------------ -------- --------------

      COL                         VARCHAR2(128)

      ATT                         VARCHAR2(4000)

      LCUT                        NUMBER

      LVAL                        NUMBER

      RCUT                        NUMBER

      RVAL                        NUMBER

CREATE_COL_REM

Creates column removal definition table dbms_data_mining_transform.create_col_rem( rem_table_name IN VARCHAR2, rem_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(create_col_rem, AUTO_WITH_COMMIT);

exec dbms_data_mining_transform.create_col_rem('DMTXCCR', 'C##SAFEDBA');

      

      PL/SQL procedure successfully completed.

      

      SQL> desc c##safedba.dmtxccr

      Name               Null?    Type

      ------------------ -------- --------------

      COL                         VARCHAR2(128)

      ATT                         VARCHAR2(4000)

CREATE_MISS_CAT

Creates categorical missing value treatment definition table dbms_data_mining_transform.create_miss_cat( miss_table_name IN VARCHAR2, miss_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(create_miss_cat, AUTO_WITH_COMMIT);

exec dbms_data_mining_transform.create_miss_cat('DMTXCMC', 'C##SAFEDBA');

      

      PL/SQL procedure successfully completed.

      

      SQL> desc c##safedba.dmtxcmc

      Name               Null?    Type

      ------------------ -------- --------------

      COL                         VARCHAR2(128)

      ATT                         VARCHAR2(4000)

      VAL                         VARCHAR2(4000)

CREATE_MISS_NUM

Creates numerical missing value treatment definition table dbms_data_mining_transform.create_miss_num( miss_table_name IN VARCHAR2, miss_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(create_miss_num, AUTO_WITH_COMMIT);

exec dbms_data_mining_transform.create_miss_num('DMTXCMN', 'C##SAFEDBA');

      

      PL/SQL procedure successfully completed.

      

      SQL> desc c##safedba.dmtxcmn

      Name               Null?    Type

      ------------------ -------- --------------

      COL                         VARCHAR2(128)

      ATT                         VARCHAR2(4000)

      VAL                         NUMBER;

CREATE_NORM_LIN

Creates the linear normalization definition table dbms_data_mining_transform.create_norm_lin( norm_table_name IN VARCHAR2, norm_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(create_norm_lin, AUTO_WITH_COMMIT);

exec dbms_data_mining_transform.create_norm_lin('DMTXCNL', 'C##SAFEDBA');

      

      PL/SQL procedure successfully completed.

      

      SQL> desc c##safedba.dmtxcnl

      Name               Null?    Type

      ------------------ -------- --------------

      COL                         VARCHAR2(128)

      ATT                         VARCHAR2(4000)

      SHIFT                       NUMBER;

      SCALE                       NUMBER;

DESCRIBE_STACK

Describes transformation of the data table specified by the stack definition

Overload 1 dbms_data_mining_transform.describe_stack( xform_list IN sys.dbm_data_mining_transform.transform_list, data_table_name IN VARCHAR2, describe_list OUT sys.dbms_sql.desc_tab2, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

Overload 2 dbms_data_mining_transform.describe_stack( xform_list IN sys.dbm_data_mining_transform.transform_list, data_table_name IN VARCHAR2, describe_list OUT sys.dbms_sql.desc_tab3, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

GET_EXPRESSION

Gets a VARCHAR2 chunk from the expression. Chunks numbering starts from one dbms_data_mining_transform.get_expression( expression IN sys.dbms_data_mining_transform.expression_rec, chunk_num IN BINARY_INTEGER DEFAULT NULL) RETURN VARCHAR2;

TBD

INSERT_AUTOBIN_NUM_EQWIDTH

For every NUMBER column in the data table that is not in the exclusion list finds numerical binning definition and inserts it into the definition table dbms_data_mining_transform.insert_autobin_num_eqwidth( bin_table_name IN VARCHAR2, data_table_name IN VARCHAR2, bin_num IN BINARY_INTEGER DEFAULT 3, max_bin_num IN BINARY_INTEGER DEFAULT 100, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, round_num IN BINARY_INTEGER DEFAULT 6, sample_size IN BINARY_INTEGER DEFAULT 5000, bin_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, rem_table_name IN VARCHAR2 DEFAULT NULL, rem_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_BIN_CAT_FREQ

For every VARCHAR2, CHAR column in the data table that is not in the exclusion list finds categorical binning definition and inserts it into the definition table dbms_data_mining_transform.insert_bin_cat_freq( bin_table_name IN VARCHAR2, data_table_name IN VARCHAR2, bin_num IN BINARY_INTEGER DEFAULT 9, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, default_num IN BINARY_INTEGER DEFAULT 2, bin_support IN NUMBER DEFAULT NULL, bin_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_BIN_NUM_EQWIDTH

For every NUMBER column in the data table that is not in the exclusion list finds numerical binning definition and inserts it into the definition table dbms_data_mining_transform.insert_bin_num_eqwidth( bin_table_name IN VARCHAR2, data_table_name IN VARCHAR2, bin_num IN BINARY_INTEGER DEFAULT 10, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, round_num IN BINARY_INTEGER DEFAULT 6, bin_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_BIN_NUM_QTILE

TBD

INSERT_BIN_SUPER

For every NUMBER, VARCHAR2, or CHAR, as well as DM_NESTED_NUMERICAL, or DM_NESTED_CATEGORICAL column in the data table that is not in the exclusion list finds numerical and categorical binning definition and inserts them into the corresponding definition tables dbms_data_mining_transform.insert_bin_super( num_table_name IN VARCHAR2, cat_table_name IN VARCHAR2, data_table_name IN VARCHAR2, target_column_name IN VARCHAR2, max_bin_num IN BINARY_INTEGER DEFAULT 1000, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, num_schema_name IN VARCHAR2 DEFAULT NULL, cat_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, rem_table_name IN VARCHAR2 DEFAULT NULL, rem_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_CLIP_TRIM_TAIL

For every NUMBER column in the data table that is not in the exclusion list finds clipping definition and inserts it into the definition table dbms_data_mining_transform.insert_clip_trim_tail( clip_table_name IN VARCHAR2, data_table_name IN VARCHAR2, tail_frac IN NUMBER DEFAULT 0.025, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, clip_schema_name IN VARCHAR2 DEFAULT NULL,, data_schema_name IN VARCHAR2 DEFAULT NULL,);

TBD

INSERT_CLIP_WINSOR_TAIL

For every NUMBER column in the data table that is not in the exclusion list finds clipping definition and inserts it into the definition table dbms_data_mining_transform.insert_clip_winsor_tail( clip_table_name IN VARCHAR2, data_table_name IN VARCHAR2, tail_frac IN NUMBER DEFAULT 0.025, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, clip_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_MISS_CAT_MODE

For every VARCHAR2, CHAR column in the data table that is not in the exclusion list finds missing value treatment definition and inserts it into the definition table dbms_data_mining_transform.insert_miss_cat_mode( miss_table_name IN VARCHAR2, data_table_name IN VARCHAR2, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, miss_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_MISS_NUM_MEAN

For every NUMBER column in the data table that is not in the exclusion list finds missing value treatment definition and inserts it into the definition table dbms_data_mining_transform.insert_miss_num_mean( miss_table_name IN VARCHAR2, data_table_name IN VARCHAR2, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, round_num IN BINARY_INTEGER DEFAULT 6, miss_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_NORM_LIN_MINMAX

For every NUMBER column in the data table that is not in the exclusion list finds normalization definition and inserts it into the definition table dbms_data_mining_transform.insert_norm_lin_minmax( norm_table_name IN VARCHAR2, data_table_name IN VARCHAR2, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, round_num IN BINARY_INTEGER DEFAULT 6, norm_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_NORM_LIN_SCALE

For every NUMBER column in the data table that is not in the exclusion list finds normalization definition and inserts it into the definition table dbms_data_mining_transform.insert_norm_lin_scale( norm_table_name IN VARCHAR2, data_table_name IN VARCHAR2, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, round_num IN BINARY_INTEGER DEFAULT 6, norm_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

INSERT_NORM_LIN_ZSCORE

For every NUMBER column in the data table that is not in the exclusion list finds normalization definition and inserts it into the definition table dbms_data_mining_transform.insert_norm_lin_zscore( norm_table_name IN VARCHAR2, data_table_name IN VARCHAR2, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, round_num IN BINARY_INTEGER DEFAULT 6, norm_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

SET_EXPRESSION

Appends a VARCHAR2 chunk to the expression. Appending NULL clears the expression dbms_data_mining_transform.set_expression( expression IN OUT sys.dbms_data_mining_transform.expression_rec, chunk IN VARCHAR2 DEFAULT NULL);

TBD

SET_TRANSFORM

Appends an element to the transformation list dbms_data_mining_transform.set_transform( xform_list IN OUT NOCOPY sys.dbms_data_mining_transform.transform_list, attribute_name IN VARCHAR2, attribute_subname IN VARCHAR2, expression IN CLOB, reverse_expression IN VARCHAR2, attribute_spec IN VARCHAR2 DEFAULT NULL);

TBD

STACK_BIN_CAT

For every column in the stack definition that has a matching entry in the transformation definition, stacks categorical binning expression on top of the existing expression and updates the stack definition dbms_data_mining_transform.stack_bin_cat( bin_table_name IN VARCHAR2, xform_list IN OUT NOCOPY sys.dbms_data_mining_transform.transform_list, literal_flag IN BOOLEAN DEFAULT FALSE, bin_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

STACK_BIN_NUM

For every column in the stack definition that has a matching entry in the transformation definition, stacks numerical binning expression on top of the existing expression and updates the stack definition dbms_data_mining_transform.stack_bin_num( bin_table_name IN VARCHAR2, xform_list IN OUT NOCOPY sys.dbms_data_mining_transform.transform_list, literal_flag IN BOOLEAN DEFAULT FALSE, bin_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

STACK_CLIP

For every column in the stack definition that has a matching entry in the transformation definition, stacks clipping expression on top of the existing expression and updates the stack definition dbms_data_mining_transform.stack_clip( clip_table_name IN VARCHAR2, xform_list IN OUT NOCOPY sys.dbms_data_mining_transform.transform_list, clip_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

STACK_COL_REM

For every column in the stack definition that has a matching entry in the transformation definition, stacks column removal expression instead of the existing expression and updates the stack definition dbms_data_mining_transform.stack_col_rem( rem_table_name IN VARCHAR2, xform_list IN OUT NOCOPY sys.dbms_data_mining_transform.transform_list, rem_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

STACK_MISS_CAT

For every column in the stack definition that has a matching entry in the transformation definition, stacks categorical missing value treatment expression on top of the existing expression and updates the stack definition dbms_data_mining_transform.stack_miss_cat( miss_table_name IN VARCHAR2, xform_list IN OUT NOCOPY sys.dbms_data_mining_transform.transform_list, miss_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

STACK_MISS_NUM

For every column in the stack definition that has a matching entry in the transformation definition, stacks numerical missing value treatment expression on top of the existing expression and updates the stack definition dbms_data_mining_transform.stack_miss_num( miss_table_name IN VARCHAR2, xform_list IN OUT NOCOPY sys.dbms_data_mining_transform.transform_list, miss_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

STACK_NORM_LIN

For every column in the stack definition that has a matching entry in the transformation definition, stacks linear normalization expression on top of the existing expression and updates the stack definition dbms_data_mining_transform.stack_norm_lin( norm_table_name IN VARCHAR2, xform_list IN OUT NOCOPY sys.dbms_data_mining_transform.transform_list, norm_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

XFORM_BIN_CAT

Creates a view that performs categorical binning of the data table dbms_data_mining_transform.xform_bin_cat( bin_table_name IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, literal_flag IN BOOLEAN DEFAULT FALSE, bin_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(xform_bin_cat, AUTO_WITH_COMMIT);

TBD

XFORM_BIN_NUM

Creates a view that performs numerical binning of the data table. Only the columns that are specified in the xform definition are binned, the remaining columns do not change dbms_data_mining_transform.xform_bin_num( bin_table_name IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, literal_flag IN BOOLEAN DEFAULT FALSE, bin_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(xform_bin_num, AUTO_WITH_COMMIT);

TBD

XFORM_CLIP

Creates a view that performs clipping of the data table. Only the columns that are specified in the xform definition are clipped, the remaining columns do not change dbms_data_mining_transform.xform_clip( clip_table_name IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, clip_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(xform_clip, AUTO_WITH_COMMIT);

TBD

XFORM_COL_REM

Creates a view that performs column removal from the data table. Only the columns that are specified in the xform definition are removed, the remaining columns do not change dbms_data_mining_transform.xform_col_rem( rem_table_name IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, rem_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(xform_col_rem, AUTO_WITH_COMMIT);

TBD

XFORM_EXPR_NUM

Creates a view that applies a given expression for every NUMBER column in the data table that is not in the exclusion list and in the inclusion list dbms_data_mining_transform.xform_expr_num( expr_pattern IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, include_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, col_pattern IN VARCHAR2 DEFAULT ':col', data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

XFORM_EXPR_STR

Similar to xform_expr_num, except that it applies to CHAR and VARCHAR2 columns instead of NUMBER dbms_data_mining_transform.xform_expr_str( expr_pattern IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, exclude_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, include_list IN sys.dbms_data_mining_transform.column_list DEFAULT NULL, col_pattern IN VARCHAR2 DEFAULT ':col', data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL);

TBD

XFORM_MISS_CAT

Creates a view that performs categorical missing value treatment of the data table dbms_data_mining_transform.xform_miss_cat( miss_table_name IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, miss_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(xform_miss_cat, AUTO_WITH_COMMIT);

TBD

XFORM_MISS_NUM

Creates a view that performs numerical missing value treatment of the data table dbms_data_mining_transform.xform_miss_num( miss_table_name IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, miss_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(xform_miss_num, AUTO_WITH_COMMIT);

TBD

XFORM_NORM_LIN

Creates a view that performs linear normalization of the data table. Only the columns that are specified in the xform definition are normalized, the remaining columns do not change dbms_data_mining_transform.xform_norm_lin( norm_table_name IN VARCHAR2, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, norm_schema_name IN VARCHAR2 DEFAULT NULL, data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(xform_norm_lin, AUTO_WITH_COMMIT);

TBD

XFORM_STACK

Creates a view that performs transformation of the data table specified by the stack definition dbms_data_mining_transform.xform_stack( xform_list IN sys.dbms_data_mining_transform.transform_list, data_table_name IN VARCHAR2, xform_view_name IN VARCHAR2, data_schema_name IN VARCHAR2 DEFAULT NULL, xform_schema_name IN VARCHAR2 DEFAULT NULL);

TBD