FlipBook

120

PUBLIC

Predictive Analysis Library (PAL) Procedure Basics

Table Type

Definition

• Training Data Set

• Validation Data Set

• Parameter Data

PAL Interface

Generation

• Generate Store Procedure

Data

Preparation

• Input Table Type

• Parameter Table Type

• Output Table Type

PAL Interface

Invocation

• Call Store Procedure

CREATE TYPE PAL_CART_DATA_T AS TABLE

CREATE TYPE PAL_CART_TREEMODEL_T AS TABLE

CREATE TYPE PAL_CONTROL_T AS TABLE

INSERT INTO PAL_CART_PDATA_TBL VALUES (1, 'COIL.PAL_CART_DATA_T', 'in');

INSERT INTO PAL_CART_PDATA_TBL VALUES (2, 'COIL.PAL_CONTROL_T', 'in');

INSERT INTO PAL_CART_PDATA_TBL VALUES (3, 'COIL.PAL_CART_TREEMODEL_T', 'out');

INSERT INTO PAL_CART_PDATA_TBL VALUES (4, 'COIL.PAL_CART_STATISTIC_T', 'out');

call "SYSTEM".afl_wrapper_generator('PAL_CART_PROC', 'AFLPAL', 'CART', PAL_CART_PDATA_TBL);

INSERT INTO #PAL_CONTROL_TBL VALUES ('THREAD_NUMBER', 2, null, null);

INSERT INTO #PAL_CONTROL_TBL VALUES ('IS_SPLIT_MODEL', 1, null, null);

INSERT INTO #PAL_CONTROL_TBL VALUES ('PMML_EXPORT', 0, null, null);

CALL "_SYS_AFL".PAL_CART_PROC(TICDATA2000, #PAL_CONTROL_TBL, PAL_CART_TREEMODEL_TBL,

PAL_CART_STATISTIC_TBL) with OVERVIEW;