DBA Data[Home] [Help]

ODM.ODM_ABN_MODEL dependencies on ABN_PRED_RES

Line 14: ev+
1idence_wt) :
1FROM evwt_lview) :
1AS ABN_EVIDWT_GRP) :
1dat_rec:::
1REC_INST(:
1ATTR_INST(:
1ATTR:
1SVAL:
1NVAL:
1,ATTR_INST(:
1P_TARGET_VALUE_LIST:
1TARG_LIST:
1P_PRED_RECORD:
1ABN_PRED_GRP:
1V_RULE_CLAUSE:
1V_NUM_RULES:
1V_DATA_RECORD:
1ODM.REC_INST(ODM.ATTR_INST(:
1,ODM.ATTR_INST(:
1 max(block_num) rule_id, :
1 || tree_num || SYS_CONNECT_BY_PATH(predictor_value, :
1SELECT target_value, :
1FROM TABLE(CAST(:
1 AS REC_INST))), :
1p.tnum, p.tdep:
1 || MAX(DECODE(p.tdep, :
1, t.value)) OVER(PARTITION BY p.tnum) pred_:
1 || tnum || :
1DECODE(tdep:
1, pred_1:
1 || pred_:
1FROM pivot_lview), :
1target_value, :
1TRUNC(SUM(log2_p), 20) log2_p :
1WHERE m.path = fr.path :
1GROUP BY target_value), :
1WHERE m.attribute_name = fr.predictor AND m.value=fr.predictor_value :
1 rule_id, :
1 log_lhd_lview AS (:
1SELECT /*+ NOPARALLEL(p) NOPARALLEL(d) NO_MERGE(p) NO_MERGE(d) ordered USE_HA+
1SH(p d) */ :
1p.target_value, d.log2_p dl, p.log2_p pl :
1FROM new_prior p LEFT OUTER JOIN :
1condp_lview d :
1ON p.target_value = d.target_value), :
1NVL(rule_id, 1) rule_id, :
1 log_lhood_lview AS (:
1SELECT /*+ NOPARALLEL(p) */ :
1target_value, NVL(dl + pl, pl) log2_p :
1FROM log_lhd_lview), :
1 lhood_lview AS (:
1POWER(2, log_shifted_likelihood) likelihood :
1FROM (SELECT :
1 target_value, log2_p - MAX(log2_p) OVER () log_shifted_likelihood :
1FROM log_lhood_lview sl)), :
1 prob_lview AS (:
1CASE WHEN likelihood > 1.0E-129*sum_likelihood :
1THEN likelihood/sum_likelihood ELSE 0 END probability :
1FROM (SELECT :
1 target_value, likelihood, :
1TRUNC(SUM(likelihood) OVER (), 20) sum_likelihood :
1FROM lhood_lview)), :
1cost_matrix_lview AS (:
1SELECT * :
1cost_lview AS (:
1 select c1.rule_id, c1.target_value, c1.cost, p1.probability FROM :
1(SELECT rule_id, c.predicted_target_value target_value,:
1SUM(p.probability*c.cost) cost :
1FROM prob_lview p,:
1cost_matrix_lview c :
1WHERE p.target_value = c.actual_target_value :
1GROUP BY rule_id, c.predicted_target_value) c1, prob_lview p1 :
1WHERE p1.target_value = c1.target_value):
1probability cost, probability :
1FROM prob_lview):
1C_PT_ALL:
1DESC:
1ASC:
1C_PT_BOTTOM:
1rank_lview AS (:
1SELECT /*+ NOPARALLEL(t) */ :
1probability,:
1ROW_NUMBER() OVER (ORDER BY cost :
1) rank :
1FROM cost_lview t):
1SELECT target_value,:
1NULL rank :
1filt_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))):
1tr.target_value,:
1rank :
1FROM target_list_lview tr,:
1rank_lview pr :
1WHERE tr.target_value = pr.target_value):
1FROM rank_lview):
1unbin_lview AS (:
1SELECT /*+ NOPARALLEL(bin) NOPARALLEL(prd) NO_MERGE(prd) ORDERED USE_HASH(prd+
1 bin) */ :
1bin.category spred,:
1target_value npred,:
1prd.probability,:
1prd.rank :
1FROM filt_lview prd,:
1WHERE prd.target_value = bin.group_id :
1NULL spred,:
1FROM filt_lview):
1, rule_id:
1, NULL:
1SELECT ABN_PRED_RES(spred, npred, probability, rank:
1) :
1FROM unbin_lview) :
1AS ABN_PRED_GRP) :
1targ_list:::
1TARG_LIST(:
1TARG_REC(:
1NTRG:
1STRG:
1,TARG_REC(:
1target list record_apply:
1NOT target list record_apply:
1pred_record:::
1ABN_PRED_GRP(:
1ABN_PRED_RES(:
1SPRD:
1NPRD:
1PROB:
1,ABN_PRED_RES(:
1p_pred_record.count:: :
1TEST:
1P_TEST_RESULT_NAME:
1V_APPLY_TABLE_NAME:
1V_RESULT_ID:
1Getting rules table, priors and bin cat table:
1TABLE_1:
1TABLE_5:
1BIN_CATEGORICAL_TABLE:
1ODM_MINING_MODEL:
1NAME:
1DONE Getting rules table, priors and bin cat table:
1in apply_for_test:
1actual_value:
1predicted_value:
1DONE apply_for_test:
1setting up test result:
1SETUP_TEST_RESULT:
1DONE setting up test result:
1computing confusion matrix:
1COMPUTE_CONFUSION_MATRIX:
1DONE computing confusion matrix:
1persisting test result:
1PERSIST_TEST_RESULT:
1DONE persisting test result:
1CLEANUP_TEST_RESULT:
1E_TEST_ORA_ERROR_NUM:
1LIFT:
1P_N

10: ate apply:
1DROP_VIEW:
1APPLY_FOR_LIFT:
1P_APP_PROB_COLUMN_NAME:
1V_POS_TARGET_TABLE_NAME:
1V_POS_TARGET_TABLE_CREATED:
1V_USER:
1p_positive_target_value:: :
1creating v_target_view_name:
1DONE creating v_target_view_name:: :
1creating v_pos_target_table_name:
1 target_value :
1FROM dual:
1DONE creating v_pos_target_table_name:: :
1invoking private apply (for lift):
1C_PT_LIST:
1DONE invoking private apply (for lift):
1UPDATE_NODE_P:
1V_FOO:
1V_FOO_CREATED:
1creating temp table to hold node_p values:
1 SELECT block_num, target_value, :
1 CASE WHEN likelihood > 1.0E-129*sum_likelihood THEN likelihood/sum_li+
1kelihood ELSE 0 END node_p from :
1 (SELECT block_num, target_value, power(2.0, log_shifted_likelihood) +
1likelihood, :
1 TRUNC(SUM(power(2.0,log_shifted_likelihood)) OVER (partition by bl+
1ock_num), 20) sum_likelihood from :
1 (SELECT block_num, target_value, :
1 log2_p - MAX(log2_p) OVER (partition by block_num) log_shi+
1fted_likelihood from :
1 (SELECT tt.block_num, tt.target_value, tt.log2_p+p.log2_p log2_p +
1from :
1 (SELECT block_num, target_value, odm_abn_model.parse_and_add(l+
1p) log2_p FROM :
1 (select block_num, target_value, sys_connect_by_path(log2_p, :
1) lp from :
1 (select block_num, depth_of_tree, target_value, log2_p, bl+
1ock_num || target_value rid, :
1 parent_block_num || target_value prid from :
1 START WITH depth_of_tree = 1 connect by prior rid = prid+
1)) tt, :
1 (SELECT target_value, log2_p from :
1 WHERE p.target_value = tt.target_value) lp )):
1DONE creating temp table to hold node_p values:
1updating node_p values in trees table to reflect Bayes conditional probabilit+
1ies:
1 t SET node_p = (select node_p from :
1 f :
1 where t.block_num=f.block_num and t.target_value=f.target_value):
1DONE updating node_p values in trees table to reflect Bayes conditional proba+
1bilities:
1BUILD:
1P_BIN_NUM_TABLE_NAME:
1P_MAX_BUILD_TIME:
1P_NUM_NB_PREDICTORS:
110:
1P_ABN_PRED_BIT_FRACTION:
1V_TIME_START:
1V_TIME_END:
1V_FEATURE_START:
1V_ELAPSED_MINUTES:
1V_PREVIOUS_MINUTES:
1V_FEATURE_MINUTES:
1V_MAX_BUILD_TIME:
1P_TIMING_TABLE_CREATED:
1V_EST_FEATURE_SCORING_TIME:
1V_EST_TIME_TO_NEXT_LEVEL:
1V_ESTIMATED_FEATURE_DEPTH:
1V_PREDICTOR_NAME:
1V_BIN_COLUMN_NAME:
1PREDICTOR_VALUE:
1V_UNBIN_COLUMN_NAME:
1PREDICTOR_VALUE_STRING:
1V_TAB:
1V_SEQ:
1V_STARTING_BLOCK:
1V_TREES_TABLE_CREATED:
1V_SQL_CLAUSE:
1V_TERMINATE:
1V_CURRENT_DESC:
1V_MIN_DESC_MODEL:
1V_BASELINE_DESC:
1V_MAXIMUM_TREE_DEPTH:
1V_MAX_TREE_DEPTH:
1V_ACCEPTED_TREE_CNT:
1V_MAXIMUM_PREDICTORS:
1V_MAXIMUM_REJECTIONS:
1V_CURRENT_REJECTIONS:
1V_CURRENT_NUM_TREES:
1V_NUM_TARGET_VALUES:
1V_LAST_GOOD_TREE:
1V_DEBUG_ENABLED:
1V_NUM_CANDIDATES:
1V_BASELINE_COST:
1V_TRAINING_PARTITION:
1V_ABN_PRED_BIT_FRACTION:
1V_COMPLEXITY_PRED_LIMIT:
1V_ABN_COMPLEXITY_BIAS:
1V_MAX_ATTRIBUTES:
1Entering :
1p_max_build_time:: :
1p_maximum_tree_depth:: :
1p_maximum_predictors:: :
1p_maximum_rejections:: :
1p_num_NB_predictors:: :
1p_abn_model_type:: :
1p_abn_pred_bit_fraction:: :
1p_abn_complexity_bias:: :
1ERROR:: NULL p_training_table_name:
1ERROR:: NULL p_priors_table_name:
1ERROR:: NULL p_timing_table_name:
1ERROR:: non-existing training table, name = :
1ERROR:: non-existing num bin boundary table, name = :
1ERROR:: non-existing num cat boundary table, name = :
1ERROR:: NULL p_tid_column_name:
1ERROR:: non-existing id column, name = :
1ERROR:: NULL p_item_column_name:
1ERROR:: non-existing item column, name = :
1ERROR:: non-existing value column, name = :
1ERROR:: invalid value for p_maximum_tree_depth = :
1ERROR:: invalid value for p_maximum_predictors = :
1ERROR:: NULL p_trees_table_name:
1E_TABLE_ALREADY_EXIST_NUM:
1ERROR:: already existing trees table, name = :
1creating timing table:: :
1 (tree_num NUMBER, depth_of_tree NUMBER, segment_build_time NUMBER, :
1feature_scoring_time NUMBER, is_11: terminated NUMBER(2), is_accepted NUMBER(2), +
1est_feature_scoring_time NUMBER):
1DONE creating timing table:: :
1!=:
1creating sequences:
1CREATE_SEQUENCE:
1DONE creating sequences:
1.nextval from dual:
1selecting first partition of the training table:
1PARTITION(' || partition_name || ')' :
1FROM user_tab_partitions :
1WHERE table_name = ':
1NO_DATA_FOUND:
1No partitions in training table:: :
1DONE selecting first partition of the training table:: :
1creating seed features:
1GET_TIME_MILLISECONDS:
1getting num predictors:
1select count(distinct :
1) - 1 num_candidates :
1DONE getting num predictors:: :
1getting log of max predictors:
1SELECT PARENT_ENTROPY + PARENT_CNT_BITS - CHILD_ENTROPY - CNT_BITS from :
1 WHERE TREE_NUM = (select min(TREE_NUM) from :
13.0:
1DONE getting log of max predictors:: :
1POWER:
1doing feature selection for bio data:
1DONE with feature selection for bio data:
1ELSIF:
1doing feature selection for business data:
1DONE with feature selection for business data:
1DONE creating seed features:
1inserting timings for building Naive Bayes model into :
1Estimated will exceed max build time:: :
1 current time:: :
1 minutes. Terminating....:
1CLEANUP:
1getting baseline cost:
1select entropy*cnt + odm_ABN_model.compute_log_combinations(cnt + :
1 - 1) baseline_description :
1DONE getting baseline cost:: :
1INITIAL v_maximum_predictors:: :
1v_baseline_cost / log(2,v_num_candidates):: :
1 v_baseline_cost:: :
1 log(2,v_num_candidates):: :
1 AFTER v_maximum_predictors:: :
1STARTING NAIVE BAYES COST COMPUTATION:
1max tree num for NB model:: :
1DONE WITH NAIVE BAYES COST COMPUTATION, v_current_desc:: :
1model type:: :
1building an NB Model ONLY:
1De-Activating features that are NB only:
1 t set ACTIVE = 0 WHERE t.PREDICTOR = :
1 s :
1WHERE ACTIVE = -1 AND s.:
1 = t.PREDICTOR):
1DONE De-Activating features that are NB only:
1beginning to extend first seed feature tree:
1building first tree deep - about to build depth:: :
1building first tree deep - done with depth:: :
1Terminate after inner LOOP:: TRUE:
1Estimated time to build next level will exceed max build time:: :
1inserting timings for building tree 1 depth :
1 into :
1Terminate after inner LOOP:: FALSE:
1enter sc_create_feature_log_p from first feature build (pt 2):
1p_tid_column_name:: :
1 v_tab.p_rules_subset2d_table_name:: :
1 v_tab.p_train_subset2d_table_name:: :
1 v_tab.p_model_log_p_table_name:: :
1 v_current_depth:: :
1 v_tab.p_internal_priors_table_name:: :
1Estimated time to build another feature will exceed max build time:: :
1dropping depth > 1 predictors from :
1delete from :
1 AND depth_of_tree > 1:
1dropped feature :
1reset all depth 1 features to ACTIVE:
1 set active = 1 :
1where depth_of_tree = 1:
1DONE resetting all depth 1 features to ACTIVE:
1current number of the attempts to extend trees:: :
1v_current_tree:: :
1 v_maximum_tree_depth:: :
1getting max depth of current tree:: :
1LAST:
1DONE getting max depth of current tree:: :
1enter sc_create_feature_log_p from feature complete (pt 3):
1Combined model has shortest desc:: :
1Testing standalone current tree:
1enter sc_create_feature_log_p from final build score (pt 4):
1DONE Testing standalone current tree:
1current tree beats previous best model:
1reactivate seed tree associated with child components for trees < :
1where tree_num > :
1 AND depth_of_tree = 1 AND predictor in :
1(select distinct predictor from :
1 where tree_num < :
1 AND depth_of_tree > 1 ):
1reactivated seed trees associated with child components for trees < :
1removing child predictors from exclusions table:
1 in :
1removed child predictors from exclusions table:
1deleting all trees less than :
1DONE deleting all trees less than :
1reactivate seed tree associated with child components for tree :
1reactivated seed trees associated with child components for tree :
1dropping feature :
1>=:
1done build:
1dropping inactive features and features > :
1 OR ACTIVE = 0:
1dropped inactive features and features > :
1ODM_MINING_TRA12: NSFORMATION:
1UNBIN_TABLE:
1TARGET_VALUE:
1TARGET_VALUE_STRING:
1UNBIN_TARGET:
1getting baseline cost :
1select BASELINE_DESCRIPTION from :
1got baseline cost:: :
1dropping all features :
1dropped all features :
1E_AR_BUILD_CLEAN_UP_NUM:
1unweighting the counts in the trees table:
1 t set cnt = :
1t.cnt / (select w.weight from :
1where w.target_value = t.target_value):
1DONE unweighting the counts in the trees table:
1in error code:
1E_MODEL_ORA_ERROR_NUM:
1validating whether tree table has any seed splits:
1done validating whether tree table has any seed splits:
1P_RES_RULE_COLUMN_NAME:
1P_PERSISTENCE_TYPE:
1P_ORIGINAL_TABLE_LOCATION:
1V_TREES_TABLE_NAME:
1V_COST_MATRIX_TABLE_NAME:
1V_PRIORS_TABLE_NAME:
1V_BIN_CAT_TABLE_NAME:
1V_BIN_NUM_TABLE_NAME:
1V_TARGET_VALUE_TABLE_NAME:
1V_SC_SCORES_TABLE_NAME:
1V_SC_SCORES_TABLE_CREATED:
1V_SC_DETAILED_RULES_TABLE:
1V_SC_DETAILED_RULES_CREATED:
1V_RESULT_TABLE:
1V_RESULT_CREATED:
1V_RES_RANK_COLUMN_NAME:
1V_SUP_SEQID_COLUMN_NAME:
1V_DAT_PRED_COLUMN_NAME:
1V_DAT_PROB_COLUMN_NAME:
1PREDICTED_PROBABILITY:
1TIMESTAMP:
1V_TARGET_COUNT:
1V_NUM_DETAILED_RULES:
1V_NUM_DT_RULES:
1V_SUP_COLUMN_LIST:
1V_SQL_SUPPL_COLUMNS:
1V_SQL_SELECT:
1V_SQL_PREDICTION:
1starting apply:
1p_num_rules:: :
1select count(*) from :
1GET_TIME:
1DONE invoking internal apply:
1bin the v_target_value_table_name:
1SELECT distinct t.TARGET_VALUE from :
1 t, :
1 v :
1WHERE v.TARGET_VALUE = t.TARGET_VALUE_STRING:
1DONE binning the v_target_value_table_name:: :
1RANK:
1SEQUENCE_ID:
1SELECT * FROM :
1B.:
1RTRIM:
1A.seqid:
1A.pred:
1A.cost:
1A.rank:
1A.rule:
1 A, :
1 B :
1WHERE A.seqid = B.:
1 A:
1DONE creating p_result_table_location:: :
1PERSIST_APPLY_RESULT:
1E_APPLY_ORA_ERROR_NUM:
1APPLY_RECORD:
1P_DATA_RECORD:
1REC_INST:
1P_EVIDENCE:
1ABN_EVIDWT_GRP:
1V_RULES_TABLE_NAME:
1V_PRIOR_TABLE_NAME:
1V_DEPTH1:
1V_SQL_ORDER:
1V_TARGET_ATTRIBUTE_NAME:
1V_BIN_OTHER_LVIEW:
1V_BIN_TABLES_EXIST:
1V_BIN_OTHER_CREATED:
1V_PRIOR_ATTR_NAME:
1getting rules and priors tables:
1DONE getting rules and priors tables:
1Rules:: :
1Prior:: :
1CostM:: :
1NumBB:: :
1CatBB:: :
1select COLUMN_NAME from user_tab_columns :
1where table_name=:
1 and COLUMN_ID=1:
1 FROM :
1WHERE rownum < 2:
1TAttr:: :
1SELECT max(depth_of_tree) :
1max depth:: :
1CREATE table :
1SELECT column_name c, group_id b :
1 WHERE category IS NULL AND category_value IS NULL :
1SELECT column_name c,0 b :
1 WHERE bin_id = 1:
1WITH :
1rflat_lview AS (:
1SELECT block_num, :
1target_p, :
1log2_p, :
1SYS_CONNECT_BY_PATH(trim(predictor) || :
1 || trim(predictor_value_string), :
1 :
1) attr_name_value, :
1 || to_char(predictor_value), :
1) path :
1START WITH depth_of_tree = 1 :
1CONNECT BY PRIOR block_num = parent_block_num :
1 AND PRIOR target_value = target_value), :
1 pred_lview AS (:
1SELECT /*+ NOPARALLEL(t) */ DISTINCT :
1predictor pred, :
1tree_num tnum, :
1depth_of_tree tdep :
1 t), :
1new_prior AS (:
1SELECT target_value, p, log2_p:
1 data_record_lview AS (:
1SELECT attr cn, :
1sval sv, :
1nval nv :
1FROM TABLE(CAST(::dat_rec AS REC_INST))), :
1 num_bin_lview AS (:
1SELECT * :
1),:
1 cat_bin_lview AS (:
1 bin_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),:
1 data_range_lview AS (:
1SELECT /*+ NO_MERGE(tr) NO_MERGE_(br) NOPARALLEL(tr) NOPARALLEL(br) ordered U+
1SE_HASH(tr br) */ :
1tr.cn, tr.sv, tr.nv, br.b :
1FROM data_record_lview tr :
1LEFT OUTER JOIN :
1bin_range_lview br :
1ON cn = c :
1AND nv > l AND nv < u),:
1 bin_numpt_lview AS (:
1category_value n, :
1group_id b :
1FROM cat_bin_lview :
1WHERE category_value IS NOT NULL :
1UNION ALL :
1lower_boundary n, :
1FROM num_bin_lview :
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),:
1 data_numpt_lview AS (:
1SELECT /*+ NO_MERGE(tn) NO_MERGE(bn) NOPARALLEL(tn)13: NOPARALLEL(bn) ordered US+
1E_HASH(tn bn) */ :
1tn.cn, tn.sv, tn.nv, NVL(tn.b, bn.b) b :
1FROM data_range_lview tn :
1LEFT OUTER JOIN :
1bin_numpt_lview bn :
1AND nv = n),:
1 bin_strpt_lview AS (:
1category s, :
1WHERE category IS NOT NULL),:
1 data_strpt_lview AS (:
1SELECT /*+ NO_MERGE(ts) NO_MERGE(bs) NOPARALLEL(ts) NOPARALLEL(bs) ordered US+
1E_HASH(ts bs) */ :
1ts.cn, ts.sv, ts.nv, NVL(ts.b, bs.b) b :
1FROM (SELECT cn, sv, nv, b, NVL(sv, TO_CHAR(nv)) snv :
1FROM data_numpt_lview) ts :
1bin_strpt_lview bs :
1AND snv = s),:
1 bin_other_lview AS ( select * from :
1 data_other_lview AS (:
1SELECT /*+ NO_MERGE(tm) NO_MERGE(bm) NOPARALLEL(tm) NOPARALLEL(bm) ordered US+
1E_HASH(tm bm) */ :
1tm.cn, tm.sv, tm.nv, :
1CASE WHEN tm.b IS NOT NULL THEN tm.b :
1ELSE CASE WHEN bm.b IS NULL THEN tm.nv :
1ELSE CASE WHEN tm.nv IS NULL AND tm.sv IS NULL THEN NULL :
1ELSE CASE WHEN bm.b != 0 THEN bm.b :
1ELSE NULL END END END END b :
1FROM data_strpt_lview tm :
1bin_other_lview bm :
1ON tm.cn = bm.c), :
1 data_prep_lview AS (:
1SELECT cn attribute_name, b value :
1FROM data_other_lview),:
1SELECT cn attribute_name, nv value :
1FROM data_record_lview),:
1 pivot_lview AS (:
1SELECT /*+ NOPARALLEL(p) NOPARALLEL(t) ORDERED USE_HASH(p t) */ :
1p.tnum, p.tdep, t.attribute_name, t.value:
1 FROM pred_lview p, :
1data_prep_lview t :
1WHERE p.pred = t.attribute_name),:
1 dflat1_lview AS (:
1SELECT DISTINCT tnum, tdep, :
1SYS_CONNECT_BY_PATH(trim(attribute_name) || :
1 || trim(value), :
1 FROM pivot_lview :
1START WITH tdep = 1 :
1CONNECT BY PRIOR tnum = tnum :
1 AND PRIOR tdep = tdep - 1), :
1 dflat_lview AS (:
1SELECT /*+ NOPARALLEL(d2) NOPARALLEL(d1) ORDERED USE_HASH(d2 d1) */ :
1d1.tnum, d1.tdep, path from dflat1_lview d1, :
1 (SELECT tnum, max(tdep) maxdep from dflat1_lview group by tnum) d2 :
1WHERE d1.tnum = d2.tnum AND d1.tdep = d2.maxdep), :
1 condp_lview AS (:
1SELECT /*+ NOPARALLEL(fr) NOPARALLEL(m) ORDERED USE_HASH(fr m) */ :
1block_num, m.path, target_value, attr_name_value, target_p, log(2.0, target_p+
1) target_log2p :
1FROM rflat_lview fr, :
1dflat_lview m :
1WHERE m.path = fr.path), :
1fr.predictor || :
1 || fr.predictor_value_string attr_name_value, target_value, :
1target_p, log(2.0, target_p) target_log2p :
1 fr, :
1data_prep_lview m :
1WHERE m.attribute_name = fr.predictor AND m.value=fr.predictor_value), :
1costs_lview AS (:
1SELECT actual_target_value, avg(cost) cost :
1 WHERE cost > 0),:
1altered_priors_lview AS (:
1SELECT target_value, log(2,p) log2_p from :
1 (SELECT target_value, cost * p / sum(cost * p) over() p :
1 FROM new_prior p, costs_lview c WHERE c.actual_target_value = p.target_valu+
1e)),:
1altered_priors_lview AS (select * from new_prior),:
1unbin_priors AS (:
1SELECT /*+ NOPARALLEL(bin) NOPARALLEL(ap) NO_MERGE(prd) ORDERED USE_HASH(ap b+
1in) */ :
1bin.category target_value_string,:
1target_value,:
1ap.log2_p :
1FROM altered_priors_lview ap,:
1cat_bin_lview bin :
1WHERE ap.target_value = bin.group_id :
1AND bin.column_name = ':
1'),:
1SELECT NULL target_value_string,:
1log2_p :
1FROM altered_priors_lview), :
1unbin_priors_unif AS (:
1SELECT target_value_string, target_value, log2_p, log2_p - log(2, 1/ count(*)+
1 over()) evidence_wt :
1FROM unbin_priors), :
1pred_evwt1_lview AS (:
1SELECT /*+ NOPARALLEL(c) ORDERED USE_HASH(p c) */ :
1c.attr_name_value, c.target_value, p.target_value_string, c.target_log2p - p.+
1log2_p evidence_wt :
1FROM condp_lview c, unbin_priors p WHERE c.target_value=p.target_value :
1PRIOR:
1 attr_name_value, target_value, target_value_string, evidence_wt :
1FROM unbin_priors_unif), :
1total_evwt_lview AS (:
1TOTAL:
1 attr_name_value, target_value, target_value_string, :
1sum(evidence_wt) evidence_wt from pred_evwt1_lview group by target_value, tar+
1get_value_string), :
1evwt_lview AS (:
1SELECT * from pred_evwt1_lview UNION ALL SELECT * from total_evwt_lview):
1 SELECT CAST(:
1MULTISET( :
1SELECT ABN_EVIDWT_RES(attr_name_value, target_value_string, target_value, 14: ev+
1idence_wt) :
1FROM evwt_lview) :
1AS ABN_EVIDWT_GRP) :
1dat_rec:::
1REC_INST(:
1ATTR_INST(:
1ATTR:
1SVAL:
1NVAL:
1,ATTR_INST(:
1P_TARGET_VALUE_LIST:
1TARG_LIST:
1P_PRED_RECORD:
1ABN_PRED_GRP:
1V_RULE_CLAUSE:
1V_NUM_RULES:
1V_DATA_RECORD:
1ODM.REC_INST(ODM.ATTR_INST(:
1,ODM.ATTR_INST(:
1 max(block_num) rule_id, :
1 || tree_num || SYS_CONNECT_BY_PATH(predictor_value, :
1SELECT target_value, :
1FROM TABLE(CAST(:
1 AS REC_INST))), :
1p.tnum, p.tdep:
1 || MAX(DECODE(p.tdep, :
1, t.value)) OVER(PARTITION BY p.tnum) pred_:
1 || tnum || :
1DECODE(tdep:
1, pred_1:
1 || pred_:
1FROM pivot_lview), :
1target_value, :
1TRUNC(SUM(log2_p), 20) log2_p :
1WHERE m.path = fr.path :
1GROUP BY target_value), :
1WHERE m.attribute_name = fr.predictor AND m.value=fr.predictor_value :
1 rule_id, :
1 log_lhd_lview AS (:
1SELECT /*+ NOPARALLEL(p) NOPARALLEL(d) NO_MERGE(p) NO_MERGE(d) ordered USE_HA+
1SH(p d) */ :
1p.target_value, d.log2_p dl, p.log2_p pl :
1FROM new_prior p LEFT OUTER JOIN :
1condp_lview d :
1ON p.target_value = d.target_value), :
1NVL(rule_id, 1) rule_id, :
1 log_lhood_lview AS (:
1SELECT /*+ NOPARALLEL(p) */ :
1target_value, NVL(dl + pl, pl) log2_p :
1FROM log_lhd_lview), :
1 lhood_lview AS (:
1POWER(2, log_shifted_likelihood) likelihood :
1FROM (SELECT :
1 target_value, log2_p - MAX(log2_p) OVER () log_shifted_likelihood :
1FROM log_lhood_lview sl)), :
1 prob_lview AS (:
1CASE WHEN likelihood > 1.0E-129*sum_likelihood :
1THEN likelihood/sum_likelihood ELSE 0 END probability :
1FROM (SELECT :
1 target_value, likelihood, :
1TRUNC(SUM(likelihood) OVER (), 20) sum_likelihood :
1FROM lhood_lview)), :
1cost_matrix_lview AS (:
1SELECT * :
1cost_lview AS (:
1 select c1.rule_id, c1.target_value, c1.cost, p1.probability FROM :
1(SELECT rule_id, c.predicted_target_value target_value,:
1SUM(p.probability*c.cost) cost :
1FROM prob_lview p,:
1cost_matrix_lview c :
1WHERE p.target_value = c.actual_target_value :
1GROUP BY rule_id, c.predicted_target_value) c1, prob_lview p1 :
1WHERE p1.target_value = c1.target_value):
1probability cost, probability :
1FROM prob_lview):
1C_PT_ALL:
1DESC:
1ASC:
1C_PT_BOTTOM:
1rank_lview AS (:
1SELECT /*+ NOPARALLEL(t) */ :
1probability,:
1ROW_NUMBER() OVER (ORDER BY cost :
1) rank :
1FROM cost_lview t):
1SELECT target_value,:
1NULL rank :
1filt_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))):
1tr.target_value,:
1rank :
1FROM target_list_lview tr,:
1rank_lview pr :
1WHERE tr.target_value = pr.target_value):
1FROM rank_lview):
1unbin_lview AS (:
1SELECT /*+ NOPARALLEL(bin) NOPARALLEL(prd) NO_MERGE(prd) ORDERED USE_HASH(prd+
1 bin) */ :
1bin.category spred,:
1target_value npred,:
1prd.probability,:
1prd.rank :
1FROM filt_lview prd,:
1WHERE prd.target_value = bin.group_id :
1NULL spred,:
1FROM filt_lview):
1, rule_id:
1, NULL:
1SELECT ABN_PRED_RES(spred, npred, probability, rank:
1) :
1FROM unbin_lview) :
1AS ABN_PRED_GRP) :
1targ_list:::
1TARG_LIST(:
1TARG_REC(:
1NTRG:
1STRG:
1,TARG_REC(:
1target list record_apply:
1NOT target list record_apply:
1pred_record:::
1ABN_PRED_GRP(:
1ABN_PRED_RES(:
1SPRD:
1NPRD:
1PROB:
1,ABN_PRED_RES(:
1p_pred_record.count:: :
1TEST:
1P_TEST_RESULT_NAME:
1V_APPLY_TABLE_NAME:
1V_RESULT_ID:
1Getting rules table, priors and bin cat table:
1TABLE_1:
1TABLE_5:
1BIN_CATEGORICAL_TABLE:
1ODM_MINING_MODEL:
1NAME:
1DONE Getting rules table, priors and bin cat table:
1in apply_for_test:
1actual_value:
1predicted_value:
1DONE apply_for_test:
1setting up test result:
1SETUP_TEST_RESULT:
1DONE setting up test result:
1computing confusion matrix:
1COMPUTE_CONFUSION_MATRIX:
1DONE computing confusion matrix:
1persisting test result:
1PERSIST_TEST_RESULT:
1DONE persisting test result:
1CLEANUP_TEST_RESULT:
1E_TEST_ORA_ERROR_NUM:
1LIFT:
1P_N
15: UM_QUANTILES:
1P_LIFT_RESULT_NAME:
1invoking apply_for_lift:
1probability:
1DONE invoking apply_for_lift:
1SETUP_LIFT_RESULT:
1invoking odm_supervised_model.compute_lift:
1COMPUTE_LIFT:
1DONE invoking odm_supervised_model.compute_lift:
1invoking odm_supervised_model.persist_lift_result:
1PERSIST_LIFT_RESULT:
1DONE invoking odm_supervised_model.persist_lift_result:
1CLEANUP_LIFT_RESULT:
1E_LIFT_ORA_ERROR_NUM:
1V_POSITIVE_TARGET_VALUE:
1in lift (categorical):
1getting bin_categorical_table:
1DONE getting bin_categorical_table:
1getting bin positive target value:
1SELECT group_id :
1WHERE category = ':
1' :
1AND column_name = ':
1DONE getting bin positive target value:: :
1call numerical lift:
1DONE calling numerical lift:
1ESTIMATE_FEATUREBLD_TIME:
1P_FEATURE_BLD_TIME:
1getting estimate of time to build a feature:
1select max(est_feature_scoring_time) from :
1(select feature_scoring_time est_feature_scoring_time from :
1 where feature_scoring_time IS NOT NULL AND tree_num = 1 :
1 UNION:
1 select est_feature_scoring_time from :
1 where tree_num <= 1 AND depth_of_tree = (select max(depth_of_tree) from :
1 where tree_num <= 1) ):
1DONE getting estimate of time to build a feature:: :
1GET_MODEL_STATE:
1P_MODEL_STATE:
1V_MAX_TREE_NUM:
1V_IS_TERMINATED:
1getting max tree_num and max value of is_terminated:
1select max(tree_num) cnt, max(is_terminated) from :
1DONE getting max tree_num and max value of is_terminated:
1computing model state:
1model state c_naive_bayes:
1model state c_complete_single_feature:
1model state c_incomplete_single_feature:
1model state c_complete_multi_feature:
1GET_DETAILED_RULE:
1P_RULE_ID:
1P_RULE_STRING:
1P_PRED_LIST:
1STRVAL_LIST_TYPE:
1P_PREDVAL_STR_LIST:
1P_PREDVAL_NUM_LIST:
1P_TARGET_VAL_LIST:
1P_TARGET_PROB_LIST:
1P_SUPPORT:
1V_RULE_COMPONENT:
1V_PARENT_BLOCK_NUM:
1V_PREDICTOR:
1V_PREDICTOR_VALUE_STR:
1V_PREDICTOR_VALUE:
1V_RULE_ID:
1V_RULE_COUNT_LIST:
1getting trees_table name:
1SELECT table_1 FROM odm_mining_model where name = :
1getting target probabilities and support counts:
1select target_value_string, target_p, cnt from :
1 WHERE block_num = :
1Target Value:: :
1 Prob:: :
1 Count:: :
1p_support:: :
1getting leaf rule component:
1select distinct predictor, predictor_value, predictor_value_string from :
1DONE getting leaf rule component:: :
1p_pred_list(:
1):: :
1 p_predval_str_list(:
1 p_predval_num_list(:
1select distinct block_num, predictor, predictor_value, predictor_value_string+
1 from :
1(select distinct parent_block_num from :
1) pbn, :
1 b WHERE pbn.parent_block_num = b.block_num :
1p_predval_str_list(:
1p_predval_num_list(:
1DONE getting parent rule component:: :
1DONE getting parent rule components:
0
0
0
8cb3
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 a0
9b :2 a0 6b 1c 70 87 :2 a0 1c
51 1b b0 87 :2 a0 51 a5 1c
6e 1b b0 87 :2 a0 51 a5 1c
6e 1b b0 a3 a0 1c :2 a0 6b
:6 6e a5 b 81 b0 a3 a0 1c
:2 a0 6b 6e a5 b 81 b0 a3
a0 1c 51 81 b0 a3 a0 1c
51 81 b0 a3 a0 1c 51 81
b0 a3 a0 1c 51 81 b0 a3
a0 1c 51 81 b0 a3 a0 1c
51 81 b0 a3 a0 1c 51 81
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 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 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 6e 1b
b0 87 :2 a0 51 a5 1c 6e 1b
b0 87 :2 a0 51 a5 1c 6e 1b
b0 8716: :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 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 1c 51 1b b0 a0
9d a0 a3 a0 1c b0 81 a3
a0 1c b0 81 a3 a0 51 a5
1c b0 81 a3 a0 1c b0 81
a3 a0 1c b0 81 a3 a0 1c
b0 81 60 77 a0 9d :2 a0 c8
77 a0 9d a0 1c a0 40 a8
c 77 a0 9d a0 1c a0 40
a8 c 77 a0 9d a0 a3 a0
1c b0 81 a3 a0 1c a0 b0
81 a3 a0 1c b0 81 a3 a0
1c a0 b0 81 a3 a0 1c b0
81 a3 a0 1c a0 b0 81 a3
a0 1c b0 81 a3 a0 1c a0
b0 81 a3 a0 1c b0 81 a3
a0 1c a0 b0 81 a3 a0 1c
b0 81 a3 a0 1c a0 b0 81
a3 a0 1c b0 81 a3 a0 1c
a0 b0 81 a3 a0 1c b0 81
a3 a0 1c a0 b0 81 a3 a0
1c b0 81 a3 a0 1c a0 b0
81 a3 a0 1c b0 81 a3 a0
1c a0 b0 81 a3 a0 1c b0
81 a3 a0 1c a0 b0 81 a3
a0 1c b0 81 a3 a0 1c a0
b0 81 a3 a0 1c b0 81 a3
a0 1c a0 b0 81 a3 a0 1c
b0 81 a3 a0 1c a0 b0 81
a3 a0 1c b0 81 a3 a0 1c
a0 b0 81 a3 a0 1c b0 81
a3 a0 1c a0 b0 81 a3 a0
1c b0 81 a3 a0 1c a0 b0
81 a3 a0 1c b0 81 a3 a0
1c a0 b0 81 a3 a0 1c b0
81 a3 a0 1c a0 b0 81 a3
a0 1c b0 81 a3 a0 1c a0
b0 81 a3 a0 1c b0 81 a3
a0 1c a0 b0 81 a3 a0 1c
b0 81 a3 a0 1c a0 b0 81
a3 a0 1c b0 81 a3 a0 1c
a0 b0 81 a3 a0 1c b0 81
a3 a0 1c a0 b0 81 a3 a0
1c b0 81 a3 a0 1c a0 b0
81 a3 a0 1c b0 81 a3 a0
1c a0 b0 81 60 77 a0 9d
a0 a3 a0 1c b0 81 a3 a0
1c a0 b0 81 a3 a0 1c b0
81 a3 a0 1c a0 b0 81 a3
a0 1c b0 81 a3 a0 1c a0
b0 81 60 77 a0 9d a0 a3
a0 1c b0 81 a3 a0 1c b0
81 a3 a0 1c b0 81 a3 a0
1c b0 81 a3 a0 1c b0 81
a3 a0 1c b0 81 60 77 a0
9d a0 a3 a0 1c b0 81 a3
a0 51 a5 1c b0 81 a3 a0
1c b0 81 a3 a0 1c b0 81
a3 a0 1c b0 81 a3 a0 1c
b0 81 a3 a0 1c b0 81 60
77 a0 9d a0 a3 a0 51 a5
1c b0 81 a3 a0 51 a5 1c
b0 81 a3 a0 1c b0 81 60
77 a0 9d a0 1c a0 40 a8
c 77 a0 9d a0 a3 a0 1c
b0 81 a3 a0 1c b0 81 a3
a0 51 a5 1c b0 81 a3 a0
1c b0 81 60 77 a0 9d a0
1c a0 40 a8 c 77 a0 8d
8f a0 b0 3d 8f a0 b0 3d
b4 :2 a0 2c 6a a3 a0 1c 51
81 b0 a3 a0 1c 81 b0 a0
7e 51 b4 2e :2 a0 7e b4 2e
52 10 :2 a0 65 b7 19 3c :2 a0
51 a0 a5 b d 91 51 :2 a0
63 37 :2 a0 7e a0 51 a0 7e
a0 b4 2e 7e 51 b4 2e a5
b b4 2e 7e a0 51 a0 a5
b b4 2e d b7 a0 47 :2 a0
65 b7 a4 a0 b1 11 68 4f
a0 8d 8f a0 b0 3d b4 :2 a0
2c 6a a3 a0 1c 51 81 b0
a3 a0 1c 7e 51 b4 2e 81
b0 a3 a0 1c 7e 51 b4 2e
81 b0 a3 a0 1c :2 a0 a5 b
81 b0 a3 a0 1c :2 a0 a5 b
81 b0 a3 a0 1c 51 81 b0
a3 a0 1c a0 81 b0 :2 a0 6b
:2 a0 a5 57 :3 a0 6e :2 a0 a5 b
d :2 a0 7e 51 a0 b4 2e 82
:2 a0 6b a0 6e 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 a0 b4 2e
7e 6e b4 2e 7e :3 a0 7e 51
b4 2e a0 a5 b b4 2e a5
57 :2 a0 7e :4 a0 7e 51 b4 2e
a0 a5 b a5 b b4 2e d
:2 a0 6b a0 6e 7e a0 b4 2e
a5 57 :2 a0 7e 51 b4 2e d
:2 a0 7e 51 b4 2e d :3 a0 6e
:2 a0 a5 b d :2 a0 7e a0 b4
2e d :2 a0 6b a0 6e 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 a0
b4 2e a5 57 b7 a0 47 :2 a0
65 b7 a4 a0 b1 11 68 4f
a0 8d 90 :2 a0 b0 3f 8f a0
b0 3d b4 :2 a0 2c 6a a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 :2 a0 6b 1c 81 b0 a3 a0
1c :2 a0 6b b4 2e 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 :3 a0 6b d :2 a0 6b :4 a0 6b
a5 57 :2 a0 6b :3 a0 a5 57 :2 a0
6b a0 a5 57 a0 7e b4 2e
a0 7e 51 b4 2e a 10 :2 a0
6b a0 a5 57 91 51 :2 a0 63
37 :2 a0 a5 b :2 a0 a5 b a0
6b d b7 a0 47 b7 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 7e 51 b4
2e :2 a0 6b a0 a5 57 b7 19
3c 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 b4 55 6a
a0 7e b4 2e a0 7e b4 2e
:2 a0 7e 6e b4 2e d b7 19
3c :2 a0 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e d b7
19 3c 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
17: 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 7e a0 b4 2e a5 57 :2 a0
6b a0 6e 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 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 :2 a0 6b 1c 81 b0
a3 a0 1c 81 b0 87 :2 a0 51
a5 1c a0 :2 6e a5 b 1b b0
87 :2 a0 51 a5 1c a0 :2 6e a5
b 7e 6e b4 2e 7e a0 :2 6e
a5 b b4 2e 1b b0 :3 a0 6b
a0 7e 6e b4 2e 7e a0 b4
2e :5 a0 a5 b d :3 a0 6b d
:2 a0 6b :2 a0 6b :2 a0 6b :2 a0 6b
:2 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 9a 8f a0 b0 3d 8f a0
b0 3d 90 :2 a0 b0 3f b4 55
6a :3 a0 7e a0 b4 2e 5a 7e
51 b4 2e a5 b d b7 a4
a0 b1 11 68 4f 9a 90 :2 a0
b0 3f 90 :2 a0 b0 3f 8f a0
4d b0 3d 90 :2 a0 b0 3f b4
55 6a :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d :2 a0 6b :2 a0 6b a0 a5
b d b7 a4 a0 b1 11 68
4f 9a 90 :2 a0 b0 3f 90 :2 a0
b0 3f 90 :2 a0 b0 3f b4 55
6a :2 a0 65 b7 19 3c :2 a0 6b
a0 6e a5 57 :2 a0 6b :2 a0 6b
:2 a0 6b a5 57 :2 a0 6b :2 a0 6b
:2 a0 6b a5 57 :2 a0 6b :2 a0 6b
:2 a0 6b a5 57 :2 a0 6b a0 6e
a5 57 :2 a0 6b a0 6e a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b a0 6e a5 57 b7 a4
a0 b1 11 68 4f 9a 8f a0
b0 3d 8f a0 b0 3d 90 :2 a0
b0 3f 90 :2 a0 b0 3f b4 55
6a a3 a0 1c 81 b0 :2 a0 6b
a0 6e a5 57 a0 6e 7e a0
b4 2e 7e 6e b4 2e 7e :2 a0
6b b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e 7e
:2 a0 6b b4 2e 7e 6e b4 2e
d :2 a0 6b :2 a0 a5 57 :4 a0 11e
11d :2 a0 6b a0 6e 7e a0 b4
2e a5 57 b7 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 8f
a0 b0 3d 8f a0 b0 3d 90
:2 a0 b0 3f 8f a0 b0 3d 8f
a0 b0 3d 8f a0 4d b0 3d
90 :2 a0 b0 3f b4 55 6a a3
a0 1c 81 b0 a3 a0 1c :2 a0
6b a0 a5 b 81 b0 a3 a0
1c :2 a0 6b a0 a5 b 81 b0
a3 a0 1c :2 a0 6b a0 a5 b
81 b0 a3 a0 1c :2 a0 6b a0
a5 b 81 b0 a3 a0 1c a0
81 b0 a3 a0 1c a0 81 b0
:2 a0 7e b4 2e :2 a0 d b7 19
3c :2 a0 6b a0 6e a5 57 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
18: 2e 7e 6e b4 2e 7e 6e b4
2e 7e a0 b4 2e 7e 6e b4
2e 7e 6e b4 2e 7e :2 a0 6b
b4 2e 7e 6e 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 6b :3 a0 6b a0
a5 57 :2 a0 6b a0 d :2 a0 6b
a0 6e 7e :2 a0 6b b4 2e a5
57 :2 a0 d :2 a0 7e b4 2e :2 a0
6b a0 6e a5 57 a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e d :2 a0 6b :2 a0 a5
57 :3 a0 11e 11d :2 a0 6b a0 6e
a5 57 b7 19 3c :2 a0 6b a0
6e a5 57 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 :2 a0 6b
b4 2e 7e 6e b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e :2 a0 6b 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
6e b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e 7e
:2 a0 6b 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
d :2 a0 7e b4 2e :2 a0 7e 6e
b4 2e 7e 6e b4 2e 7e a0
b4 2e 7e 6e b4 2e 7e :2 a0
6b b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e :2 a0 6b b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e a0 b4 2e d b7 19 3c
:2 a0 6b :2 a0 a5 57 :3 a0 11e 11d
:2 a0 6b :3 a0 6b a0 a5 57 :2 a0
6b a0 d :2 a0 6b a0 6e 7e
:2 a0 6b b4 2e a5 57 :2 a0 d
:2 a0 6b a0 6e a5 57 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 :2 a0 6b b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e a0 b4 2e 7e 6e b4
2e 7e :2 a0 6b 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 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e :2 a0 6b 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 d :2 a0 6b :2 a0 a5
57 :3 a0 11e 11d :2 a0 6b :3 a0 6b
a0 a5 57 :2 a0 6b a0 d :2 a0
6b a0 6e 7e :2 a0 6b b4 2e
a5 57 :2 a0 d a0 57 a0 b4
e9 b7 a4 a0 b1 11 68 4f
9a 8f a0 b0 3d 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 90 :2 a0 b0
3f b4 55 6a a3 a0 1c 81
b0 a3 a0 1c 6e 81 b0 a3
a0 1c 6e 81 b0 a3 a0 1c
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 81 b0 a3 a0 1c 6e 81
b0 :2 a0 6b a0 7e b4 2e a0
6e d a0 6e 7e :2 a0 6b b4
2e 7e 6e b4 2e d :2 a0 7e
6e b4 2e d b7 19 3c :2 a0
6b :3 a0 6b :2 a0 6b a5 57 :2 a0
6b a0 6e a5 57 a0 6e 7e
:2 a0 6b b4 2e 7e 6e 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 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e :2 a0 6b 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 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 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 a0 b4 2e d :2 a0 6b
:2 a0 a5 57 :3 a0 11e 11d :2 a0 6b
a0 d a0 57 a0 b4 e9 :2 a0
6b a0 7e b4 2e a0 6e d
a0 6e d b7 a0 6e d b7
:2 19 3c :2 a0 6b a0 6e a5 57
a0 6e 7e :2 a0 6b 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
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
:2 a0 6b b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e :2 a0 6b b4
2e 7e 6e b4 2e 7e :2 a0 6b
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 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 :2 a0
6b b4 2e 7e 6e b4 2e 7e
:2 a0 6b 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 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 6b a0
6e a5 57 :2 a0 6b :2 a0 6b :2 a0
6b a0 a5 57 :2 a0 6b a0 6e
7e :2 a0 6b b4 2e a5 57 a0
57 a0 b4 e9 b7 a4 a0 b1
11 68 4f 9a 8f a0 b0 3d
8f a0 b0 3d 8f a0 b0 3d
8f a0 b0 3d 90 :2 a0 b0 3f
8f a0 b0 3d 90 :2 a0 b0 3f
b4 55 6a a3 a0 1c 81 b0
a3 a0 1c 81 b0 a3 a0 1c
6e 81 b0 a0 7e b4 2e a0
6e 7e :2 a0 6b b4 2e 7e 6e
b4 2e d b7 a0 6e 7e a0
b4 2e 7e 6e b4 2e d :2 a0
7e 6e b4 2e d b7 :2 19 3c
:2 a0 6b :3 a0 6b :2 a0 6b a5 57
:2 a0 6b a0 6e a5 57 a0 6e
7e :2 a0 6b b4 2e 7e 6e b4