DBA Data[Home] [Help]

ODM.ODM_NAIVE_BAYES_APPLY dependencies on ODM_MODEL_UTIL

Line 1: PACKAGE BODY odm_naive_bayes_apply wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
b
9200000
1
4
0
23f
2 :e:
1PACKAGE:
1BODY:
1ODM_NAIVE_BAYES_APPLY:
1SUBTYPE:
1SCHEMA_OBJECT_NAME_TYPE:
1ODM_MODEL_UTIL:
1TABLE_NAME_TYPE:
1TABLE_LOCATION_TYPE:
1VIEW_NAME_TYPE:
1COLUMN_NAME_TYPE:
1SEQUENCE_NAME_TYPE:
1INDEX_NAME_TYPE:
1COLUMN_LIST_TYPE:
1PARTITION_LIST_TYPE:
1SQL_STATEMENT_TYPE:
1C_PACKAGE_NAME:
1CONSTANT:
1VARCHAR2:
130:
1C_APPLY_GENERIC_NAME:
1APPLY_GENERIC:
1C_APPLY_FOR_TEST_NAME:
1APPLY_FOR_TEST:
1C_APPLY_FOR_LIFT_NAME:
1APPLY_FOR_LIFT:
1C_APPLY_NAME:
1APPLY:
1C_APPLY_RECORD_NAME:
1APPLY_RECORD:
1C_TEST_NAME:
1TEST:
1C_LIFT_NUMERICAL_NAME:
1LIFT(NUMERICAL):
1C_LIFT_CATEGORICAL_NAME:
1LIFT(CATEGORICAL):
1C_MG_APPLY:
1DMT_OPUTIL:
1ODM_NB_APPLY_SQL:
1C_MG_TEST:
1ODM_NB_TEST_SQL:
1C_MG_LIFT:
1ODM_NB_LIFT_SQL:
1C_UNDERFLOW_NUMBER:
120:
1(1.0E-129):
1THROW_EXCEPTION:
1P_MESSAGE_GROUP:
1P_LOCATION:
1P_EXCEPTION_NUM:
1NUMBER:
1P_SUBSTITUTE_1:
1P_SUBSTITUTE_2:
1P_SUBSTITUTE_3:
1P_SUBSTITUTE_4:
1V_SESSION_DETAILS:
116:
1SYS_CONTEXT:
1userenv:
1INSTANCE:
1||:
1:::
1SESSIONID:
1V_SESSION_USER:
1session_user:
1V_MESSAGE_TEXT:
1MESSAGE_TEXT_TYPE:
1V_ERROR_INSTANCE_ID:
1FORM_SUBSTITUTED_STRING:
1.:
1OTHERS:
1:: Unknown exception :
1GETERRORINSTANCEID:
1RECORDDIAGNOSTICMESSAGE:
1ERROR:
1CRITICAL:
10:
1:
1ODM_SERVER_JAVA:
1ODM_SERVER_SQL:
1RAISE_APPLICATION_ERROR:
1TRUE:
1FUNCTION:
1TARGET_BINNED:
1P_DEBUG_ENABLED:
1OUT:
1BOOLEAN:
1P_BIN_CAT_TABLE_NAME:
1P_TARGET_ATTRIBUTE_NAME:
1RETURN:
1V_SQL_STMT:
1V_BIN_CNT:
1INTEGER:
1V_TARGET_BINNED:
1C_SUBPROGRAM_NAME:
1DEBUG_DUMP:
1Enter :
1IS NOT NULL:
1SELECT COUNT(*) :
1FROM (SELECT * :
1FROM (SELECT /*+ NOPARALLEL(d) */ * :
1FROM %bin_cat_table% d :
1WHERE column_name = ::target_attr) :
1WHERE rownum <= 1):
1REPLACE:
1%bin_cat_table%:
1Bind variable target_attr = :
1EXECUTE:
1IMMEDIATE:
1USING:
1Done:
1=:
11:
1FALSE:
1Leave :
1ROLLBACK:
1ROLLBACK_NR:
1COMMIT:
1Error :
1SQLERRM:
1RAISE:
1COMPUTE_PROBABILITY:
1P_DATA_TABLE_NAME:
1P_DAT_SEQID_COLUMN_NAME:
1P_DAT_ATTR_COLUMN_NAME:
1P_DAT_VALUE_COLUMN_NAME:
1P_RULES_TABLE_NAME:
1P_PRIOR_TABLE_NAME:
1P_COMPUTATION_TYPE:
1P_RESULT_TABLE_NAME:
1P_RES_SEQID_COLUMN_NAME:
1P_RES_PRED_COLUMN_NAME:
1P_RES_PROB_COLUMN_NAME:
1V_SQL_SEQUENCE:
1V_SQL_PRIOR:
1V_SQL_PT_PAIR:
1V_SQL_CONDITIONAL:
1V_SQL_TOTAL:
1V_SQL_LIKELIHOOD:
1V_SQL_PROBABILITY:
1V_SQL_SELECT:
1V_SQL_CREATE:
1V_SQL_INSERT:
1V_RESULT_TABLE_CREATED:
1V_PARTITION_LIST:
1I:
1PLS_INTEGER:
1C_PC_UNTRAIN:
1SELECT /*+ PARALLEL(pr) */ :
1%seq_id% seq_id, :
1%value% target_value :
1FROM %profile% pr :
1WHERE %attribute_name% = %target_attr%:
1%seq_id%:
1%attribute_name%:
1%value%:
1%target_attr%:
1':
1SELECT /*+ PARALLEL(sq) NOPARALLEL(pp) NO_MERGE(sq) CACHE(pp) ORDERED USE_NL(+
1sq pp) */ :
1sq.seq_id, :
1pp.value, :
1CASE WHEN pp.value = sq.target_value :
1THEN pp.adj_log_prior :
1ELSE pp.log_prior :
1END log_probability :
1FROM %sequence% sq, :
1%prior% pp:
1%sequence%:
1(:
1):
1%prior%:
1SELECT /*+ PARALLEL(pr) */ DISTINCT :
1%seq_id% seq_id :
1FROM %profile% pr:
1pp.log_prior log_probability :
1SELECT /*+ PARALLEL(t) PARALLEL(p) ORDERED USE_HASH(t p) */ :
1p.%seq_id% seq_id, :
1p.%attribute_name% attribute_name, :
1p.%value% value, :
1t.%value% target_value :
1FROM %profile% t, :
1%profile% p :
1WHERE p.%attribute_name% != %target_attr% :
1AND t.%attribute_name% = %target_attr% :
1AND t.%seq_id% = p.%seq_id%:
1SELECT /*+ PARALLEL(pr) PARALLEL(rl) NO_MERGE(pr) ORDERED USE_HASH(rl pr) */ :
1pr.seq_id, :
1rl.consequent_value value, :
1CASE WHEN rl.consequent_value = pr.target_value :
1THEN rl.adj_log_cond_probability :
1ELSE rl.log_conditional_probability :
1FROM %rule% rl, :
1%pt_pair% pr :
1WHERE rl.antecedent_attribute_name = pr.attribute_name :
1AND rl.antecedent_value = pr.value:
1%rule%:
1%pt_pair%:
1SELECT /*+ PARALLEL(pr) PARALLEL(rl) ORDERED USE_HASH(rl pr) */ :
1pr.%seq_id% seq_id, :
1rl.log_conditional_probability log_probability :
1%profile% pr :
1WHERE

1: PACKAGE BODY odm_naive_bayes_apply wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
b
9200000
1
4
0
23f
2 :e:
1PACKAGE:
1BODY:
1ODM_NAIVE_BAYES_APPLY:
1SUBTYPE:
1SCHEMA_OBJECT_NAME_TYPE:
1ODM_MODEL_UTIL:
1TABLE_NAME_TYPE:
1TABLE_LOCATION_TYPE:
1VIEW_NAME_TYPE:
1COLUMN_NAME_TYPE:
1SEQUENCE_NAME_TYPE:
1INDEX_NAME_TYPE:
1COLUMN_LIST_TYPE:
1PARTITION_LIST_TYPE:
1SQL_STATEMENT_TYPE:
1C_PACKAGE_NAME:
1CONSTANT:
1VARCHAR2:
130:
1C_APPLY_GENERIC_NAME:
1APPLY_GENERIC:
1C_APPLY_FOR_TEST_NAME:
1APPLY_FOR_TEST:
1C_APPLY_FOR_LIFT_NAME:
1APPLY_FOR_LIFT:
1C_APPLY_NAME:
1APPLY:
1C_APPLY_RECORD_NAME:
1APPLY_RECORD:
1C_TEST_NAME:
1TEST:
1C_LIFT_NUMERICAL_NAME:
1LIFT(NUMERICAL):
1C_LIFT_CATEGORICAL_NAME:
1LIFT(CATEGORICAL):
1C_MG_APPLY:
1DMT_OPUTIL:
1ODM_NB_APPLY_SQL:
1C_MG_TEST:
1ODM_NB_TEST_SQL:
1C_MG_LIFT:
1ODM_NB_LIFT_SQL:
1C_UNDERFLOW_NUMBER:
120:
1(1.0E-129):
1THROW_EXCEPTION:
1P_MESSAGE_GROUP:
1P_LOCATION:
1P_EXCEPTION_NUM:
1NUMBER:
1P_SUBSTITUTE_1:
1P_SUBSTITUTE_2:
1P_SUBSTITUTE_3:
1P_SUBSTITUTE_4:
1V_SESSION_DETAILS:
116:
1SYS_CONTEXT:
1userenv:
1INSTANCE:
1||:
1:::
1SESSIONID:
1V_SESSION_USER:
1session_user:
1V_MESSAGE_TEXT:
1MESSAGE_TEXT_TYPE:
1V_ERROR_INSTANCE_ID:
1FORM_SUBSTITUTED_STRING:
1.:
1OTHERS:
1:: Unknown exception :
1GETERRORINSTANCEID:
1RECORDDIAGNOSTICMESSAGE:
1ERROR:
1CRITICAL:
10:
1:
1ODM_SERVER_JAVA:
1ODM_SERVER_SQL:
1RAISE_APPLICATION_ERROR:
1TRUE:
1FUNCTION:
1TARGET_BINNED:
1P_DEBUG_ENABLED:
1OUT:
1BOOLEAN:
1P_BIN_CAT_TABLE_NAME:
1P_TARGET_ATTRIBUTE_NAME:
1RETURN:
1V_SQL_STMT:
1V_BIN_CNT:
1INTEGER:
1V_TARGET_BINNED:
1C_SUBPROGRAM_NAME:
1DEBUG_DUMP:
1Enter :
1IS NOT NULL:
1SELECT COUNT(*) :
1FROM (SELECT * :
1FROM (SELECT /*+ NOPARALLEL(d) */ * :
1FROM %bin_cat_table% d :
1WHERE column_name = ::target_attr) :
1WHERE rownum <= 1):
1REPLACE:
1%bin_cat_table%:
1Bind variable target_attr = :
1EXECUTE:
1IMMEDIATE:
1USING:
1Done:
1=:
11:
1FALSE:
1Leave :
1ROLLBACK:
1ROLLBACK_NR:
1COMMIT:
1Error :
1SQLERRM:
1RAISE:
1COMPUTE_PROBABILITY:
1P_DATA_TABLE_NAME:
1P_DAT_SEQID_COLUMN_NAME:
1P_DAT_ATTR_COLUMN_NAME:
1P_DAT_VALUE_COLUMN_NAME:
1P_RULES_TABLE_NAME:
1P_PRIOR_TABLE_NAME:
1P_COMPUTATION_TYPE:
1P_RESULT_TABLE_NAME:
1P_RES_SEQID_COLUMN_NAME:
1P_RES_PRED_COLUMN_NAME:
1P_RES_PROB_COLUMN_NAME:
1V_SQL_SEQUENCE:
1V_SQL_PRIOR:
1V_SQL_PT_PAIR:
1V_SQL_CONDITIONAL:
1V_SQL_TOTAL:
1V_SQL_LIKELIHOOD:
1V_SQL_PROBABILITY:
1V_SQL_SELECT:
1V_SQL_CREATE:
1V_SQL_INSERT:
1V_RESULT_TABLE_CREATED:
1V_PARTITION_LIST:
1I:
1PLS_INTEGER:
1C_PC_UNTRAIN:
1SELECT /*+ PARALLEL(pr) */ :
1%seq_id% seq_id, :
1%value% target_value :
1FROM %profile% pr :
1WHERE %attribute_name% = %target_attr%:
1%seq_id%:
1%attribute_name%:
1%value%:
1%target_attr%:
1':
1SELECT /*+ PARALLEL(sq) NOPARALLEL(pp) NO_MERGE(sq) CACHE(pp) ORDERED USE_NL(+
1sq pp) */ :
1sq.seq_id, :
1pp.value, :
1CASE WHEN pp.value = sq.target_value :
1THEN pp.adj_log_prior :
1ELSE pp.log_prior :
1END log_probability :
1FROM %sequence% sq, :
1%prior% pp:
1%sequence%:
1(:
1):
1%prior%:
1SELECT /*+ PARALLEL(pr) */ DISTINCT :
1%seq_id% seq_id :
1FROM %profile% pr:
1pp.log_prior log_probability :
1SELECT /*+ PARALLEL(t) PARALLEL(p) ORDERED USE_HASH(t p) */ :
1p.%seq_id% seq_id, :
1p.%attribute_name% attribute_name, :
1p.%value% value, :
1t.%value% target_value :
1FROM %profile% t, :
1%profile% p :
1WHERE p.%attribute_name% != %target_attr% :
1AND t.%attribute_name% = %target_attr% :
1AND t.%seq_id% = p.%seq_id%:
1SELECT /*+ PARALLEL(pr) PARALLEL(rl) NO_MERGE(pr) ORDERED USE_HASH(rl pr) */ :
1pr.seq_id, :
1rl.consequent_value value, :
1CASE WHEN rl.consequent_value = pr.target_value :
1THEN rl.adj_log_cond_probability :
1ELSE rl.log_conditional_probability :
1FROM %rule% rl, :
1%pt_pair% pr :
1WHERE rl.antecedent_attribute_name = pr.attribute_name :
1AND rl.antecedent_value = pr.value:
1%rule%:
1%pt_pair%:
1SELECT /*+ PARALLEL(pr) PARALLEL(rl) ORDERED USE_HASH(rl pr) */ :
1pr.%seq_id% seq_id, :
1rl.log_conditional_probability log_probability :
1%profile% pr :
1WHERE
2: rl.antecedent_attribute_name = pr.%attribute_name% :
1AND rl.antecedent_value = pr.%value%:
1%seq_prior% :
1UNION ALL :
1%seq_conditional%:
1%seq_prior%:
1SELECT /*+ PARALLEL(bl) NO_MERGE(bl) */ :
1seq_id, :
1value, :
1TRUNC(SUM(log_probability), 20) log_likelihood :
1FROM %total% bl :
1GROUP BY seq_id, value:
1%total%:
1SELECT seq_id :
1, :
1value :
1CASE WHEN likelihood > :
1*sum_likelihood :
1THEN likelihood/sum_likelihood :
1ELSE 0 :
1END :
1 :
1FROM (SELECT seq_id, value, EXP(log_shifted_likelihood) likelihood, :
1TRUNC(SUM(EXP(log_shifted_likelihood)) OVER(PARTITION BY seq_id), 20) sum_lik+
1elihood :
1FROM (SELECT seq_id, value, :
1log_likelihood - :
1MAX(log_likelihood) OVER (PARTITION BY seq_id) log_shifted_likelihood :
1FROM :
1)):
1CREATE TABLE :
1 PARALLEL NOLOGGING AS:
1INSERT /*+ PARALLEL(:
1) */ INTO :
1GET_PARTITION_LIST:
1FIRST:
1LAST:
1LOOP:
1Partition :
1/:
1%profile%:
1DROP_TABLE:
1P_MINING_TASK_ID:
1MINING_TASK_ID_TYPE:
1P_SUPPL_TABLE_NAME:
1P_SUP_SEQID_COLUMN_NAME:
1P_COST_MATRIX_TABLE_NAME:
1P_PREDICTION_TYPE:
1P_PREDICTION_NUM:
1P_TARGET_VALUE_TABLE_NAME:
1P_RESULT_TABLE_LOCATION:
1P_RES_RANK_COLUMN_NAME:
1V_PROBABILITY_TABLE_NAME:
1V_PROBABILITY_TABLE_CREATED:
1V_DEBUG_ENABLED:
1Compute probabilities:
1UNIQUE_TABLE_NAME:
1seqid:
1tval:
1prob:
1Compute predictions:
1ODM_SUPERVISED_MODEL:
1COMPUTE_PREDICTION:
1Clean up:
1P_APPLY_TABLE_NAME:
1P_APP_ACTUAL_COLUMN_NAME:
1P_APP_PREDICTED_COLUMN_NAME:
1V_TARGET_VIEW_NAME:
1V_TARGET_VIEW_CREATED:
1V_APPLY_TABLE_CREATED:
1V_APPLY_DATA_OBJECT_NAME:
1V_ADT_SEQID_COLUMN_NAME:
1V_ADT_ATTR_COLUMN_NAME:
1V_ADT_VALUE_COLUMN_NAME:
1Target attributes:
1UNIQUE_VIEW_NAME:
1CREATE VIEW :
1 AS :
1SELECT :
1 seq_id, :
1WHERE :
1 = ':
1Generic apply:
1seq_id:
1C_PT_TOP:
1DROP_VIEW:
1P_POSITIVE_TARGET_VALUE:
1P_APP_PROB_COLUMN_NAME:
1V_POS_TARGET_TABLE_NAME:
1V_POS_TARGET_TABLE_CREATED:
1Positive target value:
1 target_value :
1FROM dual:
1C_PT_LIST:
1P_MODEL_NAME:
1P_PERSISTENCE_TYPE:
1P_APPLY_RESULT_NAME:
1P_ORIGINAL_TABLE_LOCATION:
1V_RULES_TABLE_NAME:
1V_PRIOR_TABLE_NAME:
1V_COST_MATRIX_TABLE_NAME:
1V_BIN_CAT_TABLE_NAME:
1V_TIME_START:
1TIMESTAMP:
1V_TIME_END:
1V_RESULT_ID:
1TABLE_1:
1TABLE_2:
1TABLE_7:
1BIN_CATEGORICAL_TABLE:
1ODM_MINING_MODEL:
1NAME:
1GET_TIME:
1C_PC_ASIS:
1SETUP_APPLY_RESULT:
1PERSIST_APPLY_RESULT:
1CLEANUP_APPLY_RESULT:
1E_APPLY_ORA_ERROR_NUM:
1P_DATA_RECORD:
1REC_INST:
1P_TARGET_VALUE_LIST:
1TARG_LIST:
1P_RESULT_RECORD:
1PRED_GRP:
1V_BIN_NUM_TABLE_NAME:
1V_SQL_ORDER:
1V_TARGET_ATTRIBUTE_NAME:
1BIN_NUMERICAL_TABLE:
1Rules:: :
1Prior:: :
1CostM:: :
1NumBB:: :
1CatBB:: :
1SELECT /*+ NOPARALLEL(t) */ attribute_name :
1 t :
1WHERE rownum < 2:
1TAttr:: :
1WITH :
1data_record_lview AS (:
1SELECT attr cn,:
1sval sv,:
1nval nv :
1FROM TABLE(CAST(::dat_rec AS REC_INST))):
1,:
1num_bin_lview AS (:
1SELECT /*+ NOPARALLEL(t) */ * :
1 t):
1cat_bin_lview AS (:
1bin_range_lview AS (:
1SELECT column_name c,:
1lower_boundary l,:
1upper_boundary u,:
1bin_id b :
1FROM num_bin_lview :
1WHERE lower_boundary != upper_boundary):
1data_range_lview AS (:
1SELECT /*+ NO_MERGE(tr) NO_MERGE_(br) NOPARALLEL(tr) NOPARALLEL(br) ORDERED U+
1SE_HASH(tr br) */ :
1tr.cn,:
1tr.sv,:
1tr.nv,:
1br.b :
1FROM data_record_lview tr :
1LEFT OUTER JOIN :
1bin_range_lview br :
1ON cn = c :
1AND nv > l :
1AND nv < u):
1bin_numpt_lview AS (:
1category_value n,:
1group_id b :
1FROM cat_bin_lview :
1WHERE category_value IS NOT NULL :
1lower_boundary n,:
1WHERE lower_boundary != upper_boundary :
1upper_boundary n,:
1FROM (SELECT t.*,:
1MAX(bin_id) OVER (PARTITION BY column_name) max_bin :
1FROM num_bin_lview t) :
1WHERE bin_id = max_bin):
1data_numpt_lview AS (:
1SELECT /*+ NO_MERGE(tn) NO_MERGE(bn) NOPARALLEL(tn) NOPARALLEL(bn) ORDERED US+
1E_HASH(tn bn) */ :
1tn.cn,:
1tn.sv,:
1tn.nv,:
1NVL(tn.b, bn.b) b :
1FROM data_range_lview tn :
1bin_numpt_lview bn :
1AND nv = n):
1bin_strpt_lview AS (:
1category s,:
1WHERE category IS NOT NULL):
1data_strpt_lview AS (:
1SELECT /*+ NO_MERGE(ts) NO_MERGE(bs) NOPAR3: ALLEL(ts) NOPARALLEL(bs) ORDERED US+
1E_HASH(ts bs) */ :
1ts.cn,:
1ts.sv,:
1ts.nv,:
1NVL(ts.b, bs.b) b :
1FROM (SELECT cn,:
1sv,:
1nv,:
1b,:
1NVL(sv, TO_CHAR(nv)) snv :
1FROM data_numpt_lview) ts :
1bin_strpt_lview bs :
1AND snv = s):
1bin_other_lview AS (:
1WHERE category IS NULL :
1AND category_value IS NULL :
10 b :
1WHERE bin_id = 1):
1data_other_lview AS (:
1SELECT /*+ NO_MERGE(tm) NO_MERGE(bm) NOPARALLEL(tm) NOPARALLEL(bm) ORDERED US+
1E_HASH(tm bm) */ :
1tm.cn,:
1tm.sv,:
1tm.nv,:
1CASE WHEN tm.b IS NOT NULL THEN tm.b ELSE :
1CASE WHEN bm.b IS NULL THEN tm.nv ELSE :
1CASE WHEN tm.nv IS NULL AND tm.sv IS NULL THEN NULL ELSE :
1CASE WHEN bm.b != 0 THEN bm.b ELSE NULL END END END END b :
1FROM data_strpt_lview tm :
1bin_other_lview bm :
1ON tm.cn = bm.c):
1data_prep_lview AS (:
1SELECT cn,:
1b :
1FROM data_other_lview):
1nv b :
1FROM data_record_lview):
1nb_rules_lview AS (:
1SELECT * :
1nb_prior_lview AS (:
1log_prob_lview AS (:
1SELECT /*+ NO_MERGE(pr) NOPARALLEL(pr) NOPARALLEL(rl) ORDERED USE_HASH(pr rl)+
1 */ :
1rl.consequent_value value,:
1FROM data_prep_lview pr,:
1nb_rules_lview rl :
1WHERE rl.antecedent_attribute_name = pr.cn :
1AND rl.antecedent_value = pr.b :
1SELECT /*+ NOPARALLEL(pp) */ :
1value,:
1log_prior log_probability :
1FROM nb_prior_lview pp):
1log_lhood_lview AS (:
1SELECT /*+ NO_MERGE(cp) NOPARALLEL(cp) */ :
1cp.value,:
1TRUNC(SUM(cp.log_probability), 20) log_likelihood :
1FROM log_prob_lview cp :
1GROUP BY cp.value):
1lhood_lview AS (:
1SELECT value,:
1EXP(log_shifted_likelihood) likelihood :
1FROM (SELECT value,:
1log_likelihood - MAX(log_likelihood) OVER () log_shifted_likelihood :
1FROM log_lhood_lview)):
1prob_lview AS (:
1CASE WHEN likelihood > 1.0E-129*sum_likelihood :
1THEN likelihood/sum_likelihood ELSE 0 END probability :
1likelihood,:
1TRUNC(SUM(likelihood) OVER(), 20) sum_likelihood :
1FROM lhood_lview)):
1cost_matrix_lview AS (:
1SELECT /*+ NOPARALLEL(c) */ * :
1 c):
1cost_lview AS (:
1SELECT c.predicted_target_value value,:
1SUM(p.probability*c.cost) cost :
1FROM prob_lview p,:
1cost_matrix_lview c :
1WHERE p.value = c.actual_target_value :
1GROUP BY c.predicted_target_value):
1probability cost :
1FROM prob_lview):
1!=:
1C_PT_ALL:
1IS NULL:
1DESC:
1ASC:
1ELSIF:
1C_PT_BOTTOM:
1rank_lview AS (:
1SELECT /*+ NOPARALLEL(t) */ :
1cost,:
1ROW_NUMBER() OVER (ORDER BY cost :
1) rank :
1FROM cost_lview t):
1NULL rank :
1filter_lview AS (:
1FROM rank_lview :
1WHERE rank <= :
1target_list_lview AS (:
1SELECT b.group_id target_value :
1FROM TABLE(CAST(::targ_list AS TARG_LIST)) t,:
1cat_bin_lview b :
1WHERE t.strg = b.category :
1AND b.column_name = ':
1'):
1SELECT ntrg target_value :
1FROM TABLE(CAST(::targ_list AS TARG_LIST))):
1rank :
1FROM target_list_lview tr,:
1rank_lview pr :
1WHERE tr.target_value = pr.value):
1FROM rank_lview):
1pred_unbin_lview AS (:
1SELECT /*+ NOPARALLEL(bin) NOPARALLEL(prd) NO_MERGE(prd) ORDERED USE_HASH(prd+
1 bin) */ :
1bin.category sprd,:
1NULL nprd,:
1prd.cost prob,:
1prd.rank :
1FROM filter_lview prd,:
1cat_bin_lview bin :
1WHERE prd.value = bin.group_id :
1AND bin.column_name = ':
1SELECT NULL sprd,:
1value nprd,:
1cost prob,:
1FROM filter_lview):
1SELECT CAST(:
1MULTISET(:
1SELECT PRED_RES(sprd, nprd, prob, rank) :
1FROM pred_unbin_lview) :
1AS PRED_GRP) :
1dat_rec:::
1REC_INST(:
1COUNT:
1>:
1ATTR_INST(:
1ATTR:
1SVAL:
1NVL:
1TO_CHAR:
1NVAL:
1NULL:
12:
1,ATTR_INST(:
1targ_list:::
1TARG_LIST(:
1TARG_REC(:
1NTRG:
1STRG:
1,TARG_REC(:
1P_TEST_RESULT_NAME:
1V_APPLY_TABLE_NAME:
1actual_value:
1predicted_value:
1SETUP_TEST_RESULT:
1COMPUTE_CONFUSION_MATRIX:
1value:
1PERSIST_TEST_RESULT:
1CLEANUP_TEST_RESULT:
1E_TEST_ORA_ERROR_NUM:
1LIFT:
1P_NUM_QUANTILES:
1P_LIFT_RESULT_NAME:
1Get model table names:
1Cost:: :
1Apply:
1probability:
1Setup lift result persistence:
1SETUP_LIFT_RESULT:
1Compute lift:
1COMPUTE_LIFT:
1Persist lift result:
1PERSIST_LIFT_RESULT:
1CLEANUP_LIFT_RESULT:
1E_LIFT_ORA_ERROR_NUM:
1V_POSITIVE_TARGET_VALUE:
1Get bin table name:
1Bin cat:: :
1Bin 4: positive target value:
1SELECT group_id :
1WHERE category = ':
1' :
1AND column_name = ':
1Positive bin value:: :
1Numerical lift:
0
0
0
17d1
2
0 :2 a0 97 a0 9b :2 a0 6b 1c
70 a0 9b :2 a0 6b 1c 70 a0
9b :2 a0 6b 1c 70 a0 9b :2 a0
6b 1c 70 a0 9b :2 a0 6b 1c
70 a0 9b :2 a0 6b 1c 70 a0
9b :2 a0 6b 1c 70 a0 9b :2 a0
6b 1c 70 a0 9b :2 a0 6b 1c
70 a0 9b :2 a0 6b 1c 70 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c 6e 1b b0 87
:2 a0 51 a5 1c :2 a0 6b 1b b0
87 :2 a0 51 a5 1c :2 a0 6b 1b
b0 87 :2 a0 51 a5 1c :2 a0 6b
1b b0 87 :2 a0 51 a5 1c 6e
1b b0 9a 8f a0 b0 3d 8f
a0 b0 3d 8f a0 b0 3d 8f
a0 4d b0 3d 8f a0 4d b0
3d 8f a0 4d b0 3d 8f a0
4d b0 3d b4 55 6a a3 a0
51 a5 1c a0 :2 6e a5 b 7e
6e b4 2e 7e a0 :2 6e a5 b
b4 2e 81 b0 a3 a0 51 a5
1c a0 :2 6e a5 b 81 b0 a3
:2 a0 6b 1c 81 b0 a3 a0 1c
81 b0 :3 a0 6b a0 7e 6e b4
2e 7e a0 b4 2e :5 a0 a5 b
d b7 a0 53 :2 a0 7e 6e b4
2e 7e a0 b4 2e 7e 6e b4
2e 7e a0 b4 2e 7e 6e b4
2e d b7 a6 9 a4 b1 11
4f :3 a0 6b d :2 a0 6b :2 a0 6b
:2 a0 6b :3 a0 7e 6e b4 2e 7e
a0 b4 2e a0 51 :2 a0 :2 6e :2 a0
6b :2 a0 6b a0 a5 57 b7 a0
53 4f b7 a6 9 a4 b1 11
4f :4 a0 a5 57 b7 a4 a0 b1
11 68 4f a0 8d 90 :2 a0 b0
3f 8f :2 a0 6b b0 3d 8f a0
b0 3d b4 :2 a0 2c 6a a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 a0 1c 81 b0 87 :2 a0 51
a5 1c 6e 1b b0 :2 a0 6b a0
6e 7e a0 b4 2e 7e 6e b4
2e 7e a0 b4 2e a5 57 a0
7e b4 2e a0 6e 7e 6e b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e 6e b4 2e 7e 6e b4
2e d :3 a0 6e a0 a5 b d
:2 a0 6b :2 a0 a5 57 :2 a0 6b a0
6e 7e a0 b4 2e a5 57 :6 a0
112 11e 11a 11d :2 a0 6b a0 6e
a5 57 a0 7e 51 b4 2e :2 a0
d b7 :2 a0 d b7 :2 19 3c b7
:2 a0 d b7 :2 19 3c :2 a0 6b a0
6e 7e a0 b4 2e 7e 6e b4
2e 7e a0 b4 2e a5 57 :2 a0
65 b7 a0 53 a0 57 a0 b4
e9 a0 57 a0 b4 e9 :2 a0 6b
a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e a5 57
:2 a0 6b :2 a0 a5 57 a0 62 b7
a6 9 a4 a0 b1 11 68 4f
9a 90 :2 a0 b0 3f 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d b4 55 6a
a3 a0 1c 81 b0 a3 a0 1c
81 b0 a3 a0 1c 81 b0 a3
a0 1c 81 b0 a3 a0 1c 81
b0 a3 a0 1c 81 b0 a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 a0 1c 81 b0 a3 a0 1c
81 b0 a3 a0 1c 81 b0 a3
a0 1c a0 81 b0 a3 a0 1c
81 b0 a3 a0 1c 81 b0 87
:2 a0 51 a5 1c 6e 1b b0 :2 a0
6b a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e a5
57 :2 a0 7e b4 2e a0 6e 7e
6e b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e 6e b4 2e d
:3 a0 6e a0 a5 b d :3 a0 6e
a0 a5 b d :3 a0 6e a0 a5
b d :3 a0 :2 6e 7e a0 b4 2e
7e 6e b4 2e a5 b d a0
6e 7e 6e b4 2e 7e 6e b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e 6e b4 2e 7e 6e b4
2e d :3 a0 :2 6e 7e a0 b4 2e
7e 6e b4 2e a5 b d :3 a0
6e a0 a5 b d b7 a0 6e
7e 6e b4 2e 7e 6e b4 2e
d :3 a0 6e a0 a5 b d a0
6e 7e 6e b4 2e 7e 6e b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e 6e b4 2e d :3 a0 :2 6e
7e a0 b4 2e 7e 6e b4 2e
a5 b d :3 a0 6e a0 a5 b
d b7 :2 19 3c :2 a0 7e b4 2e
a0 6e 7e 6e b4 2e 7e 6e
b4 2e 7e 6e b4 2e 7e 6e
b4 2e 7e 6e b4 2e 7e 6e
b4 2e 7e 6e b4 2e 7e 6e
b4 2e 7e 6e b4 2e d :3 a0
6e a0 a5 b d :3 a0 6e a0
a5 b d :3 a0 6e a0 a5 b
d :3 a0 :2 6e 7e a0 b4 2e 7e
6e b4 2e a5 b d a0 6e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
d :3 a0 6e a0 a5 b d :3 a0
:2 6e 7e a0 b4 2e 7e 6e b4
2e a5 b d b7 a0 6e 7e
6e b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
6e b4 2e d :3 a0 6e a0 a5
b d :3 a0 6e a0 a5 b d
:3 a0 6e a0 a5 b d :3 a0 6e
a0 a5 b d b7 :2 19 3c a0
6e 7e 6e b4 2e 7e 6e b4
2e d :3 a0 6e a0 a5 b d
:3 a0 6e a0 a5 b d a0 6e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e d :3 a0 :2 6e 7e
a0 b4 2e 7e 6e b4 2e a5
b d a0 6e 7e a0 b4 2e
7e 6e b4 2e d a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e 6e b4 2e 75: e
6e b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e d :2 a0 d a0 6e
7e a0 b4 2e 7e 6e b4 2e
d a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e d
:3 a0 6b :2 a0 a5 b d 91 :2 a0
6b :2 a0 6b a0 63 37 :2 a0 6b
a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e :2 a0 6b b4 2e a5
57 :2 a0 7e a0 6b b4 2e :2 a0
7e 6e b4 2e 7e :2 a0 6e :2 a0
a5 b a5 b b4 2e d b7
:2 a0 7e 6e b4 2e 7e :2 a0 6e
:2 a0 a5 b a5 b b4 2e d
b7 :2 19 3c :2 a0 6b :2 a0 a5 57
:3 a0 11e 11d :2 a0 d a0 57 a0
b4 e9 :2 a0 6b a0 6e a5 57
b7 a0 47 :2 a0 6b a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e a5 57 b7 a0 53
a0 57 a0 b4 e9 :2 a0 6b :3 a0
a5 57 a0 57 a0 b4 e9 :2 a0
6b a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e a5
57 :2 a0 6b :2 a0 a5 57 a0 62
b7 a6 9 a4 a0 b1 11 68
4f 9a 8f :2 a0 6b b0 3d 8f
:2 a0 6b b0 3d 8f :2 a0 6b b0
3d 8f :2 a0 6b b0 3d 8f :2 a0
6b b0 3d 8f :2 a0 6b b0 3d
8f :2 a0 6b b0 3d 8f a0 b0
3d 8f :2 a0 6b b0 3d 8f a0
b0 3d 8f :2 a0 6b b0 3d 8f
:2 a0 6b b0 3d 8f :2 a0 6b b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f :2 a0 6b b0 3d 8f :2 a0
6b b0 3d 8f :2 a0 6b b0 3d
8f :2 a0 6b b0 3d 8f :2 a0 6b
b0 3d 8f :2 a0 6b b0 3d b4
55 6a a3 a0 1c 81 b0 a3
a0 1c a0 81 b0 a3 a0 1c
a0 81 b0 87 :2 a0 51 a5 1c
6e 1b b0 :2 a0 6b a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e a5 57 :2 a0 6b a0
6e a5 57 :3 a0 6b a0 a5 b
d :b a0 :3 6e a5 57 :2 a0 d :2 a0
6b a0 6e a5 57 :2 a0 6b a0
:3 6e :d a0 a5 57 :2 a0 6b a0 6e
a5 57 :2 a0 6b :3 a0 a5 57 :2 a0
6b a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e a5
57 b7 a0 53 a0 57 a0 b4
e9 :2 a0 6b :3 a0 a5 57 a0 57
a0 b4 e9 :2 a0 6b a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e a5 57 :2 a0 6b :2 a0
a5 57 a0 62 b7 a6 9 a4
a0 b1 11 68 4f 9a 8f :2 a0
6b b0 3d 8f :2 a0 6b b0 3d
8f :2 a0 6b b0 3d 8f :2 a0 6b
b0 3d 8f :2 a0 6b b0 3d 8f
:2 a0 6b b0 3d 8f :2 a0 6b b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f :2 a0 6b b0 3d 8f :2 a0
6b b0 3d 8f :2 a0 6b b0 3d
8f :2 a0 6b b0 3d b4 55 6a
a3 a0 1c 81 b0 a3 a0 1c
a0 81 b0 a3 a0 1c a0 81
b0 a3 a0 1c 81 b0 a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 a0 1c 81 b0 a3 a0 1c
81 b0 a3 a0 1c a0 81 b0
87 :2 a0 51 a5 1c 6e 1b b0
:2 a0 6b a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
a5 57 :2 a0 6b a0 6e a5 57
:3 a0 6b a0 a5 b d a0 6e
7e a0 b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e d :2 a0 6b :2 a0
a5 57 :3 a0 11e 11d :2 a0 d :2 a0
6b a0 6e a5 57 :2 a0 6b a0
6e a5 57 :9 a0 6e :2 a0 6e :3 a0
6b 51 6e a0 6e a0 :2 6e a5
57 :2 a0 d :2 a0 6b a0 6e a5
57 :2 a0 6b :3 a0 a5 57 :2 a0 6b
a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e a5 57
b7 a0 53 a0 57 a0 b4 e9
:2 a0 6b :3 a0 a5 57 :2 a0 6b :3 a0
a5 57 a0 57 a0 b4 e9 :2 a0
6b a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e a5
57 :2 a0 6b :2 a0 a5 57 a0 62
b7 a6 9 a4 a0 b1 11 68
4f 9a 8f :2 a0 6b b0 3d 8f
:2 a0 6b b0 3d 8f :2 a0 6b b0
3d 8f :2 a0 6b b0 3d 8f :2 a0
6b b0 3d 8f :2 a0 6b b0 3d
8f :2 a0 6b b0 3d 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f :2 a0 6b b0 3d 8f :2 a0
6b b0 3d 8f :2 a0 6b b0 3d
8f :2 a0 6b b0 3d 8f :2 a0 6b
b0 3d b4 55 6a a3 a0 1c
81 b0 a3 a0 1c a0 81 b0
a3 a0 1c 81 b0 a3 a0 1c
a0 81 b0 a3 a0 1c a0 81
b0 a3 a0 1c 81 b0 a3 a0
1c a0 81 b0 87 :2 a0 51 a5
1c 6e 1b b0 :2 a0 6b a0 6e
7e a0 b4 2e 7e 6e b4 2e
7e a0 b4 2e a5 57 :2 a0 6b
a0 6e a5 57 :3 a0 6b a0 a5
b d a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
d :2 a0 6b :2 a0 a5 57 :3 a0 11e
11d :2 a0 d :2 a0 6b a0 6e a5
57 :2 a0 6b a0 6e a5 57 :3 a0
6b a0 a5 b d a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e 6e b4 2e d
:2 a0 6b :2 a0 a5 57 :3 a0 11e 11d
:2 a0 d :2 a0 6b a0 6e a5 57
:2 a0 6b a0 6e a5 57 :9 a0 6e
:2 a0 6e :3 a0 6b 4d :2 a0 6e :2 a0
6e a5 57 :2 a0 d :2 a0 6b a0
6e a5 57 :2 a0 6b :3 a0 a5 57
:2 a0 6b :3 a0 a5 57 :2 a0 6b a0
6e 7e a0 b4 2e 7e 6e b4
2e 7e a0 b4 2e a5 57 b7
a0 53 a0 57 a0 b4 e9 :2 a0
6b :3 a0 a5 57 :2 a0 6b :3 a0 a5
57 :2 a0 6b