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.

ODM.ODM_MINING_TRANSFORMATION dependencies on DUAL

Line 3: LECT /+ NO_MERGE(tm) PARALLEL(tm) PARALLEL(bm) ORDERED USE_NL(tm bm) / :
1tm.id %id%, tm.cn %cn%, :
1CASE WHEN tm.b IS NOT NULL THEN tm.b :
1ELSE CASE WHEN bm.b IS NULL THEN tm.nv :
1ELSE CASE WHEN bm.b != 0 THEN bm.b :
1ELSE NULL :
1END :
1END %nv% :
1FROM (SELECT /+ NO_MERGE(tn) PARALLEL(tn) PARALLEL(bn) ORDERED USE_NL(tn bn)+
1 / :
1tn.id, tn.cn, tn.nv, :
1CASE WHEN tn.b IS NOT NULL THEN tn.b :
1ELSE bn.b :
1END b :
1FROM (SELECT /+ NO_MERGE(tr) PARALLEL(tr) PARALLEL(br) ORDERED USE_NL(tr br)+
1 / :
1tr.%id% id, tr.%cn% cn, tr.%nv% nv, br.b :
1FROM %tx_tab% tr :
1LEFT OUTER JOIN :
1%br_tab% br :
1ON %cn% = c AND %nv% > l AND %nv% < u) tn :
1%bn_tab% bn :
1ON cn = c AND nv = n) tm :
1%bd_tab% bm :
1ON tm.cn = bm.c:
1%bin_view%:
1%tx_tab%:
1%id%:
1%cn%:
1%nv%:
1COUNT_DISTINCT:
1Create active data table:
1SELECT /+ PARALLEL(a) PARALLEL(t) NO_MERGE(t) ORDERED USE_HASH(a t) / :
1 a, :
1 t :
1WHERE t.:
1 = a.attribute_name :
1AND t.:
1 IS NOT NULL :
1Create supplemental data table:
1SELECT /+ PARALLEL(t) / :
1 WHERE :
1 AND :
1 GROUP BY :
1Clean up binned data view and bin tables:
1Started analyzing.:
1ANALYZE_TABLE:
1C_AT_ESTIMATE:
1Finished analyzing.:
1 AS :
1SELECT * :
1FROM (SELECT DENSE_RANK() OVER (ORDER BY t.rowid) :
1 a) :
1Started reverse pivoting.:
1Finished reverse pivoting.:
1SELECT DENSE_RANK() OVER (ORDER BY rowid) :
1Started filtering.:
1Finished filtering.:
1V_SQL_COLUMNS:
1COLUMN_TYPE_VALID:
1C_DT_NUMBER:
1NOT:
1E_INVALID_COLUMN_TYPE_NUM:
1C_DT_VARCHAR2:
1SELECT /+ ORDERED USE_HASH(a, t) / :
1Started pivoting.:
1Finished pivoting.:
1READ_CAT_ATTRIBUTE_TABLE:
1P_DETAILS_TABLE_NAME:
1CATEGORICAL_DETAILS_LIST_TYPE:
1V_DETAILS_STMT:
1SELECT COLUMN_NAME, TOPN, OTHER_NAME FROM :
1V_LIST_COLUMNS:
1BEGIN SELECT CAST(MULTISET(:
1) AS categorical_details_list_type ) INTO ::1 FROM dual; END;:
1USING:
120000:
1DETAILS TABLE:: :
1 does not exist or cannot be accessed. Oracle Error:: :
1FIND_AND_INSERT_BIN_BOUNDARIES:
1P_COLUMN_NAME:
1MAX_VALUE:
1MIN_VALUE:
1NUMBER_OF_BINS:
1V_INCREMENT:
10.00:
1V_LOWER_BOUNDARY:
1V_UPPER_BOUNDARY:
1V_BIN_NUMBER:
1V_NUMBER_OF_BINS:
1V_INSERT_STMT:
12000:
1INSERT INTO :
1V_IS_ATTRIBUTE:
1CHAR:
1T:
1V_DISPLAY_NAME:
164:
1V_SDIG:
1SUBSTR:
1TO_DISPLAY:
1 VALUES ( ::1,::2,::3,::4,::5,::6):
1READ_NUMERIC_ATTRIBUTE_TABLE:
1NUMERIC_DETAILS_LIST_TYPE:
1BEGIN :
1SELECT CAST(MULTISET(:
1SELECT column_name, num_bins :
1) AS NUMERIC_DETAILS_LIST_TYPE) :
1INTO ::1 :
1FROM dual; :
1END;:
1FIND_BB_NUMERIC_TRANSACTIONAL:
1P_DISCRETIZATION_TABLE_NAME:
1BIN_LIST_TYPE:
1V_BIN_ID_TABLE_NAME:
1V_BIN_ID_TABLE_CREATED:
1V_DISPLAY:
1V_BIN_LIST:
1V_MAX_BIN:
1(:
1p_data_table_name:
1 => ':
1', :
1p_attribute_column_name:
1p_value_column_name:
1p_details_table_name:
1p_discretization_table_name:
1p_mining_task_id:
1 => :
1TO_CHAR:
1NULL:
1Create BIN_ID table:
1CREATE TABLE %bin_id_tab% (:
1bin NUMBER):
1%bin_id_tab%:
1Find max number of bins:
1SELECT NVL(MAX(num_bins), 0) :
1FROM %num_det%:
1%num_det%:
1Max bins:: :
1Populate BIN_ID table:
1EXTEND:
1INSERT INTO %bin_id_tab% (bin) :
1VALUES (::1):
1FORALL:
1Enable parallel DML:
1ALTER SESSION ENABLE PARALLEL DML:
1Done successfully:
1Done with an error:
1TO_CHAR(lowv)||'-'||TO_CHAR(uppv):
1odm_model_util.to_display(lowv, uppv, :
1Populate numerical bin boundaries table:
1INSERT /+ PARALLEL(%num_bin_hint%) / INTO %num_bin_tab% (:
1column_name, lower_boundary, upper_boundary, bin_id, is_attribute, display_na+
1me) :
1SELECT attribute_name column_name, :
1lowv lower_value, :
1uppv upper_value, :
1bin bin_id, :
1'T' is_attribute, :
1SUBSTR(:
1,1,64) display_name :
1FROM (SELECT /+ PARALLEL(sd) NO_MERGE(sd) NOPARALLEL(bn) CACHE(bn) ORDERED U+
1SE_NL(sd bn) / :
1sd.attribute_name, :
1CASE WHEN bn.bin = 1 THEN sd.minv ELSE sd.minv+(bn.bin-1)sd.incv END lowv, :
1CASE WHEN bn.bin = num_bins THEN sd.maxv ELSE sd.minv+bn.binsd.incv END uppv+
1, :
1bn.bin :
1FROM (SELECT /+ PARALLEL(d) PARALLEL(s) PQ_DISTRIBUTE(s HASH, HASH) ORDERED +
1USE_HASH(d s) / :
1s.attr

1: PACKAGE BODY odm_mining_transformation wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
b
9200000
1
4
0
36a
2 :e:
1PACKAGE:
1BODY:
1ODM_MINING_TRANSFORMATION:
1SUBTYPE:
1SCHEMA_OBJECT_NAME_TYPE:
1ODM_MODEL_UTIL:
1TABLE_NAME_TYPE:
1TABLE_LOCATION_TYPE:
1VIEW_NAME_TYPE:
1COLUMN_NAME_TYPE:
1SEQUENCE_NAME_TYPE:
1DBLINK_NAME_TYPE:
1COLUMN_LIST_TYPE:
1SQL_STATEMENT_TYPE:
1LONG_SQL_STATEMENT_TYPE:
1MINING_TASK_ID_TYPE:
1C_MAX_COLUMN_NAME:
1CONSTANT:
1INTEGER:
130:
1C_MAX_CASE_EXPRESSION:
1127:
1C_MAX_PARTITION_NUM:
11024:
1C_NUMERICAL_COLUMNS_PER_QUERY:
1NUMBER:
1500:
1C_NUMERIC_TYPE:
11:
1C_CAT_TYPE:
12:
1C_SESSION_USER:
1VARCHAR2:
1SYS_CONTEXT:
1userenv:
1session_user:
1C_SESSION_DETAILS:
116:
1INSTANCE:
1||:
1:::
1SESSIONID:
1C_AT_SAMPLE_SIZE:
110:
1C_MIN_SAMPLE_PERCENT:
10.000001:
1C_MIN_PILOT_COUNT:
1100:
1C_PACKAGE_NAME:
1C_PREPARE_2D_NAME:
1PREPARE_2D:
1C_PREPARE_TX_NAME:
1PREPARE_TX:
1C_REVERSE_PIVOT_NAME:
1REVERSE_PIVOT:
1C_PIVOT_NAME:
1PIVOT:
1C_INCOST_TABLE_NAME:
1INPUT_COST_MATRIX_TABLE:
1C_OUTCOST_TABLE_NAME:
1OUTPUT_COST_MATRIX_TABLE:
1C_INPRIOR_TABLE_NAME:
1INPUT_PRIORS_TABLE:
1C_OUTPRIOR_TABLE_NAME:
1OUTPUT_PRIORS_TABLE:
1C_BINCAT_TABLE_NAME:
1BIN_CATEGORICAL_TABLE:
1C_BINNUM_TABLE_NAME:
1BIN_NUMERIC_TABLE:
1C_TARGET_NAME:
1TARGET_NAME:
1C_TABLE_NAME:
1TABLE_NAME:
1C_ITEM_COLUMN_NAME:
1ITEM_COLUMN_NAME:
1C_BIN_COLUMN_NAME:
1BIN_COLUMN_NAME:
1C_UNBIN_COLUMN_NAME:
1UNBIN_COLUMN_NAME:
1C_COLUMN_NAME:
1COLUMN_NAME:
1C_PREPARE_COST_MATRIX:
1PREPARE_COST_MATRIX:
1C_PREPARE_PRIORS:
1PREPARE_PRIORS:
1C_TEST_BINNING:
1TEST_BINNING:
1C_UNBIN_TABLE:
1UNBIN_TABLE:
1THROW_EXCEPTION:
1P_LOCATION:
1P_EXCEPTION_NUM:
1P_SUBSTITUTE_1:
1P_SUBSTITUTE_2:
1P_SUBSTITUTE_3:
1P_SUBSTITUTE_4:
1V_MESSAGE_TEXT:
1MESSAGE_TEXT_TYPE:
1V_ERROR_INSTANCE_ID:
1FORM_SUBSTITUTED_STRING:
1.:
1OTHERS:
1:: Unknown exception :
1DMT_OPUTIL:
1GETERRORINSTANCEID:
1RECORDDIAGNOSTICMESSAGE:
1ERROR:
1CRITICAL:
1ODM_XFORM_SQL:
10:
1:
1ODM_SERVER_JAVA:
1ODM_SERVER_SQL:
1RAISE_APPLICATION_ERROR:
1TRUE:
1LOG_TRACE_MESSAGE:
1P_MESSAGE_LEVEL:
1P_MESSAGE_GROUP:
1P_MESSAGE_TEXT:
1P_MESSAGE_DETAILS:
1V_SESSION_USER:
1V_MESSAGE_DETAIL:
1V_CURRENT_DETAIL:
1FUNCTION:
1GET_TRACE_DETAIL:
1P_LEVEL:
1RETURN:
1=:
1LOW_DETAIL:
1ELSIF:
1MODERATE_DETAIL:
1HIGH_DETAIL:
13:
1GETTRACESETTING:
1<=:
1TRACE:
1CHOP_RPIVOT_VALUE:
1P_ACTIVE_ATTR_TABLE_NAME:
1P_SQL_LSTMT:
1OUT:
1P_SQL_COUNT:
1BINARY_INTEGER:
1TYPE:
1ATTRIBUTE_CURSOR_TYPE:
1REF:
1CURSOR:
1V_ATTRIBUTE_CURSOR:
1V_ATTRIBUTE_NAME:
1V_SQL_STMT:
1V_CASE_NUM:
1PLS_INTEGER:
1V_EXPR_NUM:
1CASE:
1OPEN:
1SELECT SUBSTR(attribute_name, 1, :
1) :
1FROM :
1LOOP:
1EXIT:
1NOTFOUND:
1+:
1CHOP_UP:
1 ELSE CASE:
1 WHEN a.attribute_name=':
1' :
1THEN t.:
1CLOSE:
1I:
1 END:
1ISOPEN:
1RAISE:
1CHOP_RPIVOT_SUPPL:
1P_SUPPL_ATTR_TABLE_NAME:
1V_ALIAS_NAME:
1),:
1SUBSTR(alias_name, 1, :
1 :
1,:
1RTRIM:
1CHOP_PIVOT_VALUES:
1P_ATTR_TABLE_NAME:
1P_ATTRIBUTE_COLUMN_NAME:
1P_VALUE_COLUMN_NAME:
1IS NULL:
1!=:
1MAX(CASE WHEN :
1=':
1THEN :
1 ELSE NULL END) :
1PILOT_SAMPLE:
1P_DEBUG_ENABLED:
1BOOLEAN:
1P_TABLE_NAME:
1P_PILOT_PERCENT:
1P_PILOT_COUNT:
1V_PILOT_PERCENT:
1V_PILOT_COUNT:
1C_SUBPROGRAM_NAME:
1E_PARSE:
1PRAGMA:
1EXCEPTION_INIT:
1-:
1933:
1DEBUG_DUMP:
1Enter :
1WHILE:
1<:
1SELECT COUNT(*) :
1 SAMPLE(:
1):
1EXECUTE:
1IMMEDIATE:
1Done:
1>:
1*:
1Leave :
1Error :
1SQLERRM:
1GET_CONFIG_ROUND:
1V_VALUE:
1NVL:
1TRUNC:
1TO_NUMBER:
1VALUE:
1ODM_CONFIGURATION:
1NAME:
1BIN_NUMERICAL_ROUND:
1NO_DATA_FOUND:
1INVALID_NUMBER:
140:
1NUMERICAL_STAT_2D:
1P_DATA_SCHEMA_NAME:
1P_DATA_TABLE_NAME:
1P_NUM_ATTR_TABLE_NAME:
1P_NUM_STAT_TABLE_NAME:
1P_MAX_SAMP_COUNT:
1P_MIN_SAMP_COUNT:
1P_MINING_TASK_ID:
1V_SAMPLE_2D_TABLE_NAME:
1V_SAMPLE_2D_TABLE_CREATED:
1FALSE:
1V_SAMPLE_TX_TABLE_NAME:
1V_SAMPLE_TX_TABLE_CREATED:
1V_COMP_STAT_TABLE_NAME:
1V_COMP_STAT_TABLE_CREATED:
1V_NUM_STAT_TABLE_CREATED:
1V_FULL_DATA_TABLE_NAME:
1V_SQL_SAMPLE_TABLE:
1V_SQL_LSTMT:
1V_SQL_COUNT:
1V_SAMPLE:
1V_ATTR_LIST:
1V_CURSOR:
1V_ROWS:
1V_DEBUG_ENABLED:
1NUMERICAL_2: STAT_TX:
1IS NOT NULL:
1Sample table:
1/:
1UNIQUE_TABLE_NAME:
1CREATE TABLE :
1 PARALLEL NOLOGGING AS :
1SELECT /*+ PARALLEL(t1) */ * :
1) t1 :
1Reverse pivot sample table:
1SELECT attribute_name :
1BULK:
1COLLECT:
1SELECT /*+ PARALLEL(f) NO_MERGE(f) */ * :
1FROM (SELECT /*+ PARALLEL(t) NOPARALLEL(a) CACHE(a) ORDERED USE_NL(t a) */ :
1a.attribute_name, :
1FIRST:
1LAST:
1 value :
1 t, :
1 a) f :
1WHERE value IS NOT NULL:
1DBMS_SQL:
1OPEN_CURSOR:
1PARSE:
1NATIVE:
1CLOSE_CURSOR:
1Clean up sample 2D:
1DROP_TABLE:
1Compute statistics:
1SELECT /*+ PARALLEL(t2) */ :
1attribute_name, min, max, dev, cnt :
1FROM (SELECT /*+ PARALLEL(t1) */ :
1attribute_name, :
1MIN(value) min, :
1MAX(value) max, :
1AVG(value) avg, :
1STDDEV(value) dev, :
1COUNT(value) cnt :
1 t1 :
1GROUP BY attribute_name) t2 :
1WHERE cnt >= :
1Clean up sample Tx:
1Fill in missing attributes:
1SELECT /*+ PARALLEL(a) PARALLEL(c) USE_HASH(a c) */ :
1a.attribute_name, c.min, c.max, c.dev, NVL(c.cnt, 0) cnt :
1 a,:
1 c :
1WHERE a.attribute_name = c.attribute_name (+):
1Clean up computed statistics:
1COMMIT:
1ROLLBACK:
1ROLLBACK_NR:
1IS_OPEN:
1P_DAT_SEQID_COLUMN_NAME:
1P_DAT_ATTR_COLUMN_NAME:
1P_DAT_VALUE_COLUMN_NAME:
1P_ATTR_NUM:
1 attribute_name, :
1MIN(:
1) min, :
1MAX(:
1) max, :
1AVG(:
1) avg, :
1STDDEV(:
1) dev, :
1COUNT(:
1) cnt :
1GROUP BY :
1) t2 :
1P_NUM_BIN_TABLE_NAME:
1P_CAT_BIN_TABLE_NAME:
1P_ACTIVE_TABLE_NAME:
1P_SUPPL_TABLE_NAME:
1P_SEQUENCE_COLUMN_NAME:
1P_PARTITION_REC_NUM:
1V_SEQID_TABLE_NAME:
1V_SEQID_TABLE_CREATED:
1V_BIN_DATA_VIEW_NAME:
1V_BIN_DATA_VIEW_CREATED:
1V_BIN_DATA_TABLE_NAME:
1V_BIN_DATA_TABLE_CREATED:
1P_ACTIVE_TABLE_CREATED:
1P_SUPPL_TABLE_CREATED:
1V_ACTIVE_LSTMT:
1V_ACTIVE_COUNT:
1V_SUPPL_LSTMT:
1V_SUPPL_COUNT:
1V_UNIQUE_COLUMN_NAME:
1V_PARTITION_NUM:
1TABLE_EXIST:
1E_TABLE_ALREADY_EXIST_NUM:
1UPPER:
1Create data with sequence IDs:
1UNIQUE_COLUMN_NAME:
1 NOLOGGING AS :
1SELECT /*+ NOPARALLEL(t) */ rownum :
1, t.* :
1 t:
1Create binned data view:
1UNIQUE_VIEW_NAME:
1DISCRETIZE_2D:
1Create binned data table:
1SELECT /*+ PARALLEL(t) */ * :
1Cleanup binned data view:
1DROP_VIEW:
1Compute number of partitions:
1PARTITIONING_AVAILABLE:
1CEIL:
1 (:
1, :
1PARTITION BY HASH (:
1PARTITIONS :
1PARALLEL NOLOGGING AS :
1Reverse pivot binned data:
1t.:
1a.attribute_name :
1WHERE :
1 IS NOT NULL:
1Cleanup binned data table:
1Create supplemental data:
1SELECT :
1 FROM :
1Cleanup data with sequence IDs:
1P_NEW_SEQUENCE_COLUMN_NAME:
1P_NEW_ATTRIBUTE_COLUMN_NAME:
1P_NEW_VALUE_COLUMN_NAME:
1V_RANGE_BIN_TABLE_NAME:
1V_RANGE_BIN_TABLE_CREATED:
1V_NVAL_BIN_TABLE_NAME:
1V_NVAL_BIN_TABLE_CREATED:
1V_DFLT_BIN_TABLE_NAME:
1V_DFLT_BIN_TABLE_CREATED:
1V_ACTIVE_TABLE_CREATED:
1V_SUPPL_TABLE_CREATED:
1V_NEW_SEQUENCE_COLUMN_NAME:
1V_NEW_ATTRIBUTE_COLUMN_NAME:
1V_NEW_VALUE_COLUMN_NAME:
1V_ACTIVE_INPUT_DATA_NAME:
1V_SQL_SEQUENCE:
1Create range bin table:
1CREATE TABLE %br_tab% (:
1c NOT NULL, :
1l NOT NULL, :
1u NOT NULL, :
1b NOT NULL, :
1CONSTRAINT %pk_con% PRIMARY KEY (c, l, u)) :
1ORGANIZATION INDEX PARALLEL NOLOGGING AS :
1SELECT column_name, lower_boundary, upper_boundary, bin_id :
1FROM %num_bin_tab% :
1WHERE lower_boundary != upper_boundary:
1REPLACE:
1%br_tab%:
1%pk_con%:
1UNIQUE_SCHEMA_OBJECT_NAME:
1%num_bin_tab%:
1Create number bin table:
1CREATE TABLE %bn_tab% (:
1n NOT NULL, :
1CONSTRAINT %pk_con% PRIMARY KEY (c, n)) :
1SELECT column_name, category_value, group_id :
1FROM %cat_bin_tab% :
1WHERE category_value IS NOT NULL :
1UNION ALL :
1SELECT column_name, lower_boundary, bin_id :
1WHERE lower_boundary != upper_boundary :
1SELECT column_name, upper_boundary, bin_id :
1FROM (SELECT t.*, MAX(bin_id) OVER (PARTITION BY column_name) max_bin :
1FROM %num_bin_tab% t) :
1WHERE bin_id = max_bin:
1%bn_tab%:
1%cat_bin_tab%:
1Create default bin table:
1CREATE TABLE %bd_tab% (:
1CONSTRAINT %pk_con% PRIMARY KEY (c)) :
1SELECT column_name, group_id :
1WHERE category_value IS NULL :
1SELECT column_name, 0 bin_id :
1WHERE bin_id = 1:
1%bd_tab%:
1CREATE VIEW %bin_view% AS :
1SE3: LECT /*+ NO_MERGE(tm) PARALLEL(tm) PARALLEL(bm) ORDERED USE_NL(tm bm) */ :
1tm.id %id%, tm.cn %cn%, :
1CASE WHEN tm.b IS NOT NULL THEN tm.b :
1ELSE CASE WHEN bm.b IS NULL THEN tm.nv :
1ELSE CASE WHEN bm.b != 0 THEN bm.b :
1ELSE NULL :
1END :
1END %nv% :
1FROM (SELECT /*+ NO_MERGE(tn) PARALLEL(tn) PARALLEL(bn) ORDERED USE_NL(tn bn)+
1 */ :
1tn.id, tn.cn, tn.nv, :
1CASE WHEN tn.b IS NOT NULL THEN tn.b :
1ELSE bn.b :
1END b :
1FROM (SELECT /*+ NO_MERGE(tr) PARALLEL(tr) PARALLEL(br) ORDERED USE_NL(tr br)+
1 */ :
1tr.%id% id, tr.%cn% cn, tr.%nv% nv, br.b :
1FROM %tx_tab% tr :
1LEFT OUTER JOIN :
1%br_tab% br :
1ON %cn% = c AND %nv% > l AND %nv% < u) tn :
1%bn_tab% bn :
1ON cn = c AND nv = n) tm :
1%bd_tab% bm :
1ON tm.cn = bm.c:
1%bin_view%:
1%tx_tab%:
1%id%:
1%cn%:
1%nv%:
1COUNT_DISTINCT:
1Create active data table:
1SELECT /*+ PARALLEL(a) PARALLEL(t) NO_MERGE(t) ORDERED USE_HASH(a t) */ :
1 a, :
1 t :
1WHERE t.:
1 = a.attribute_name :
1AND t.:
1 IS NOT NULL :
1Create supplemental data table:
1SELECT /*+ PARALLEL(t) */ :
1 WHERE :
1 AND :
1 GROUP BY :
1Clean up binned data view and bin tables:
1Started analyzing.:
1ANALYZE_TABLE:
1C_AT_ESTIMATE:
1Finished analyzing.:
1 AS :
1SELECT * :
1FROM (SELECT DENSE_RANK() OVER (ORDER BY t.rowid) :
1 a) :
1Started reverse pivoting.:
1Finished reverse pivoting.:
1SELECT DENSE_RANK() OVER (ORDER BY rowid) :
1Started filtering.:
1Finished filtering.:
1V_SQL_COLUMNS:
1COLUMN_TYPE_VALID:
1C_DT_NUMBER:
1NOT:
1E_INVALID_COLUMN_TYPE_NUM:
1C_DT_VARCHAR2:
1SELECT /*+ ORDERED USE_HASH(a, t) */ :
1Started pivoting.:
1Finished pivoting.:
1READ_CAT_ATTRIBUTE_TABLE:
1P_DETAILS_TABLE_NAME:
1CATEGORICAL_DETAILS_LIST_TYPE:
1V_DETAILS_STMT:
1SELECT COLUMN_NAME, TOPN, OTHER_NAME FROM :
1V_LIST_COLUMNS:
1BEGIN SELECT CAST(MULTISET(:
1) AS categorical_details_list_type ) INTO ::1 FROM dual; END;:
1USING:
120000:
1DETAILS TABLE:: :
1 does not exist or cannot be accessed. Oracle Error:: :
1FIND_AND_INSERT_BIN_BOUNDARIES:
1P_COLUMN_NAME:
1MAX_VALUE:
1MIN_VALUE:
1NUMBER_OF_BINS:
1V_INCREMENT:
10.00:
1V_LOWER_BOUNDARY:
1V_UPPER_BOUNDARY:
1V_BIN_NUMBER:
1V_NUMBER_OF_BINS:
1V_INSERT_STMT:
12000:
1INSERT INTO :
1V_IS_ATTRIBUTE:
1CHAR:
1T:
1V_DISPLAY_NAME:
164:
1V_SDIG:
1SUBSTR:
1TO_DISPLAY:
1 VALUES ( ::1,::2,::3,::4,::5,::6):
1READ_NUMERIC_ATTRIBUTE_TABLE:
1NUMERIC_DETAILS_LIST_TYPE:
1BEGIN :
1SELECT CAST(MULTISET(:
1SELECT column_name, num_bins :
1) AS NUMERIC_DETAILS_LIST_TYPE) :
1INTO ::1 :
1FROM dual; :
1END;:
1FIND_BB_NUMERIC_TRANSACTIONAL:
1P_DISCRETIZATION_TABLE_NAME:
1BIN_LIST_TYPE:
1V_BIN_ID_TABLE_NAME:
1V_BIN_ID_TABLE_CREATED:
1V_DISPLAY:
1V_BIN_LIST:
1V_MAX_BIN:
1(:
1p_data_table_name:
1 => ':
1', :
1p_attribute_column_name:
1p_value_column_name:
1p_details_table_name:
1p_discretization_table_name:
1p_mining_task_id:
1 => :
1TO_CHAR:
1NULL:
1Create BIN_ID table:
1CREATE TABLE %bin_id_tab% (:
1bin NUMBER):
1%bin_id_tab%:
1Find max number of bins:
1SELECT NVL(MAX(num_bins), 0) :
1FROM %num_det%:
1%num_det%:
1Max bins:: :
1Populate BIN_ID table:
1EXTEND:
1INSERT INTO %bin_id_tab% (bin) :
1VALUES (::1):
1FORALL:
1Enable parallel DML:
1ALTER SESSION ENABLE PARALLEL DML:
1Done successfully:
1Done with an error:
1TO_CHAR(lowv)||'-'||TO_CHAR(uppv):
1odm_model_util.to_display(lowv, uppv, :
1Populate numerical bin boundaries table:
1INSERT /*+ PARALLEL(%num_bin_hint%) */ INTO %num_bin_tab% (:
1column_name, lower_boundary, upper_boundary, bin_id, is_attribute, display_na+
1me) :
1SELECT attribute_name column_name, :
1lowv lower_value, :
1uppv upper_value, :
1bin bin_id, :
1'T' is_attribute, :
1SUBSTR(:
1,1,64) display_name :
1FROM (SELECT /*+ PARALLEL(sd) NO_MERGE(sd) NOPARALLEL(bn) CACHE(bn) ORDERED U+
1SE_NL(sd bn) */ :
1sd.attribute_name, :
1CASE WHEN bn.bin = 1 THEN sd.minv ELSE sd.minv+(bn.bin-1)*sd.incv END lowv, :
1CASE WHEN bn.bin = num_bins THEN sd.maxv ELSE sd.minv+bn.bin*sd.incv END uppv+
1, :
1bn.bin :
1FROM (SELECT /*+ PARALLEL(d) PARALLEL(s) PQ_DISTRIBUTE(s HASH, HASH) ORDERED +
1USE_HASH(d s) */ :
1s.attr4: ibute_name, :
1s.minv, :
1s.maxv, :
1CASE WHEN s.minv = s.maxv THEN 1 ELSE d.num_bins END num_bins, :
1(s.maxv - s.minv)/d.num_bins incv :
1FROM %num_det_tab% d, :
1(SELECT /*+ PARALLEL(t) */ :
1%attr_col% attribute_name, :
1MIN(%val_col%) minv, :
1MAX(%val_col%) maxv :
1FROM %dat_tab% t :
1GROUP BY %attr_col% :
1HAVING MIN(%val_col%) IS NOT NULL) s :
1WHERE d.column_name = s.attribute_name) sd, :
1%bin_id_tab% bn :
1WHERE bn.bin <= sd.num_bins):
1%dat_tab%:
1%attr_col%:
1%val_col%:
1%num_det_tab%:
1%num_bin_hint%:
1INSTR:
1Clean up BIN_ID table:
1FIND_BB_CAT_TRANSACTIONAL:
1V_SELECT_STMT:
132767:
11000:
1V_OTHER_BIN_NUMBER:
1V_CATEGORIES:
1NUMBER_LIST_TYPE:
1V_CURRENT_COLUMN:
1V_ROWNUM:
1V_OTHER_CATEGORY:
1V_CAT_STR:
1COUNT:
1ATTR_NAME:
1TOPN:
1BEGIN SELECT :
1 BULK COLLECT INTO ::1 :
1 FROM ( SELECT :
1, COUNT(*) cnt FROM :
1 = :
1':
1 ORDER BY cnt DESC) WHERE rownum < :
1; END;:
1CAT_ID:
1OTHER_NAME:
1EXEC_AND_INSERT_NUMERIC_STATS:
1TABLE_NAME_IN:
1STATEMENT:
1VARCHAR2S:
1TABLE_COUNT:
1NUM_COLS_IN_STMT:
1NUMERICAL_LIST:
1START_COLUMN_NUM:
1V_POSITION:
1V_MIN_LIST:
1V_MAX_LIST:
1V_NUM_STATS_ID:
1V_COLUMN_IN_TAB:
1C_CAT:
1C_DEST:
1V_FIELD_MODE_STR:
14000:
1V_CAT_STAT_ID:
1V_FIRST_TIME:
1V_STMT:
1V_MEDIAN_STMT:
1CUR_MEDIAN:
1V_STMT_INSERT:
1V_HIST_COUNT:
1V_FIELD_MODE:
1V7:
1DEFINE_COLUMN:
1EXECUTE_AND_FETCH:
1COLUMN_VALUE:
1NUM_QUANTILES:
1FIND_BB_NUMERIC_2D:
1V_DETAILS_LIST:
1V_CUR_POS:
1V_CUR_NUM:
1V_TOT_NUM:
1FIND_BB_CATEGORICAL_2D:
1NAMES_LIST_TYPE:
1V_CAT_NUM:
1 IS NOT NULL GROUP BY :
1FIND_AND_INSERT_2D_BOUNDARIES:
1P_NUMERIC_DETAILS_TABLE:
1P_CATEGORICAL_DETAILS_TABLE:
1P_NUMERIC_OUTPUT_NAME:
1P_CATEGORICAL_OUTPUT_NAME:
1P_OUTPUT_SCHEMA:
1V_DATA_TABLE_NAME:
1V_OUTPUT_TABLE_NAME:
1FIND_AND_INSERT_TX_BOUNDARIES:
1MAKE_2D_STATEMENT:
1P_VIEW_STATEMENT:
1P_TABLE_COUNT:
1P_CURRENT_COLUMN:
1P_STAT_TYPE:
1P_DETAILS_NUMERIC:
1P_DETAILS_CAT:
1P_NUMERIC_OPEN_ENDED:
1V_TEMP_STMT:
1V_SELECT_NUM_BB:
1V_SELECT_CAT_BB:
1V_UPPER_BOUNDARIES:
1V_LOWER_BOUNDARIES:
1V_BIN_NUMBERS:
1BEGIN :n SELECT LOWER_BOUNDARY,UPPER_BOUNDARY,BIN_ID BULK COLLECT INTO ::1+
1,::2,::3 :
1 COLUMN_NAME = :
1 ORDER BY BIN_ID ASC; END;:
1BEGIN:n SELECT CATEGORY,GROUP_ID BULK COLLECT INTO ::1, ::2 FROM :
1 ORDER BY GROUP_ID ASC; END;:
1 ( case when :
1>= :
1NUM_CLAUSES:
1 when :
1 >= :
1 and :
1 then :
1 else null end) :
1= :
1 is null then :
1'':
1 is null then null else :
1 end) :
1MAKE_TX_STATEMENT:
1P_ATTR_COLUMN_NAME:
1P_CURRENT_ATTR:
1BEGIN:n SELECT CATEGORY_VALUE,GROUP_ID BULK COLLECT INTO ::1, ::2 FROM :
1 end ):
1P_DATA_TABLE_SCHEMA:
1P_CAT_DETAILS_TABLE:
1P_DETAILS_SCHEMA:
1P_RESULT_TABLE_NAME:
1P_RESULT_SCHEMA_NAME:
1V_DATA_TABLE:
1V_RESULT_VIEW:
1V_VIEW_STATEMENT:
1V_NUM_COLS:
1V_REC_TAB:
1DESC_TAB:
1V_COLUMNS_LIST:
1V_TEMP_TABLE_NAME:
1V_STAT_TYPE:
1V_TABLE_COUNT:
1V_DETAILS_NUMERIC:
170:
1V_DETAILS_CAT:
1V_CREATE_CURSOR:
1V_BOOL_NUM_OPEN_ENDED:
1SELECT * FROM :
1DESCRIBE_COLUMNS:
1COL_COUNTER:
1COL_NAME:
1DISCR_:
1SYSTIMESTAMP:
1HH24_MI_SS_FF:
1DBMS_RANDOM:
1STRING:
14:
1DUAL:
1 AS :n SELECT distinct COLUMN_NAME,:
1 as stat_type FROM :
1 UNION ALL :
1 SELECT distinct COLUMN_NAME, :
1CREATE VIEW :
1 AS SELECT :
1BEGIN SELECT stat_type INTO ::1 FROM :
1 WHERE COLUMN_NAME = ::2; END;:
1":
1",:
1 DROP TABLE :
1DISCRETIZE_TRANSACTIONAL:
1P_SEQ_COLUMN_NAME:
1V_RANGE_BIN_TABLE_LOC:
1V_NVAL_BIN_TABLE_LOC:
1V_DFLT_BIN_TABLE_LOC:
1V_BIN_DATA_VIEW_LOC:
1V_DATA_TABLE_LOC:
1V_NUM_BIN_TABLE_LOC:
1V_CAT_BIN_TABLE_LOC:
1V_SQL_SELECT:
1p_data_table_schema:
1p_seq_column_name:
1p_attr_column_name:
1p_numeric_details_table:
1p_cat_details_table:
1p_details_schema:
1p_result_table_name:
1p_result_schema_name:
1p_numeric_open_ended:
1SELECT column_name, :
1CASE WHEN bin_id = 1 THEN -1.0e125 ELSE lower_boundary END l, :
1CASE WHEN bin_id = max_bin THEN 1.0e125 ELSE upper_boundary END u, :
1bin_id :
1FROM %num_bin_tab% t):
1ORGANIZATION INDEX NOPARALLEL NOLOGGING AS :
1WHERE bin_id > 1:
1COMMENT ON TABLE :
1 IS ':
1P_BIN_NUM_TABLE_NAME:
1P_BIN_CAT_TABLE_N5: AME:
1P_IS_BINNED:
1V_CURRENT_EXCEPTION:
1E_INVALID_INPUT_NUM:
1E_TABLE_NOT_FOUND_NUM:
1INSERT_BENCHMARK_MESSAGE:
1testing whether :
1 is binned categorical:
1select cnt from (select count(*) cnt from (select distinct COLUMN_NAME from :
1 where COLUMN_NAME = :
1)):
1 is binned numeric:
1select cnt from (select count(*) + 1 cnt from (select distinct COLUMN_NAME fr+
1om :
1P_IN_COST_MATRIX_TABLE_NAME:
1P_OUT_COST_MATRIX_TABLE_NAME:
1P_TARGET_NAME:
1V_SQL_FROM:
1V_SQL_WHERE:
1V_SQL_TARGET:
1V_IS_BINNED:
1creating internal costs table:
1 from :
1 TO_NUMBER(predicted_target_value) predicted_target_value, :
1TO_NUMBER(actual_target_value) actual_target_value,:
1c, :
1 bp, :
1 ba :
1 where bp.COLUMN_NAME = :
1ba.COLUMN_NAME = :
1bp.DISPLAY_NAME = c.predicted_target_value AND ba.DISPLAY_NAME = c.actual_tar+
1get_value:
1 bp.GROUP_ID predicted_target_value, ba.GROUP_ID actual_target_value,:
1create table :
1 as :
1select :
1 cost:
1done creating priors table:
1P_IN_PRIORS_TABLE_NAME:
1P_OUT_PRIORS_TABLE_NAME:
1preparing priors table:
1 TO_NUMBER(target_value) target_value, :
1 p, :
1 b :
1 where b.COLUMN_NAME = :
1b.DISPLAY_NAME = p.target_value:
1 b.GROUP_ID target_value, :
1 p, log(2, p) log2_p :
1from :
1done preparing priors table:
1P_ITEM_COLUMN_NAME:
1P_BIN_COLUMN_NAME:
1P_UNBIN_COLUMN_NAME:
1E_COLUMN_NOT_FOUND_NUM:
1COLUMN_EXIST:
1updating categorical values in unbin column:
1update :
1 t set :
1(select distinct DISPLAY_NAME from :
1 where b.COLUMN_NAME = t.:
1b.GROUP_ID = t.:
1 where PREDICTOR IN (SELECT distinct COLUMN_NAME from :
1DONE updating categorical values in unbin column:
1updating numeric values in unbin column:
1(select distinct TO_CHAR(LOWER_BOUNDARY || :
1 - :
1 || UPPER_BOUNDARY) DISPLAY_NAME :
1b.BIN_ID = t.:
1DONE updating numeric values in unbin column:
1UNBIN_TARGET:
1 where EXISTS (select COLUMN_NAME from :
0
0
0
3c5a
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 1c 51 1b
b0 87 :2 a0 1c 51 1b b0 87
:2 a0 1c 51 1b b0 87 :2 a0 1c
51 1b b0 87 :2 a0 1c 51 1b
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 87 :2 a0 1c 51 1b b0
87 :2 a0 1c 51 1b b0 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 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 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 :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 :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 8f a0 b0 3d 8f
a0 b0 3d 8f a0 4d b0 3d
b4 55 6a a3 a0 51 a5 1c
a0 :2 6e a5 b 81 b0 a3 a0
1c 81 b0 a3 a0 1c 81 b0
a0 8d 8f a0 b0 3d b4 :2 a0
2c 6a :2 a0 7e a0 6b b4 2e
a0 51 65 a0 b7 :2 a0 7e a0
6b b4 2e a0 51 65 a0 b7
19 :2 a0 7e a0 6b b4 2e a0
51 65 b7 19 a0 4d 65 b7
:2 19 3c b7 a4 a0 b1 11 68
4f :3 a0 a5 b d :4 a0 6b :2 a0
6b a5 b a5 b d :2 a0 7e
b4 2e :2 a0 6b :2 a0 6b :4 a0 7e
6e b4 2e 7e a0 b4 2e 6e
:2 51 :2 a0 6e :2 a0 6b :2 a0 6b 51
a5 57 b7 19 3c b7 a0 53
4f b7 a6 9 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 90
:2 a0 b0 3f 6: 90 :2 a0 b0 3f b4
55 6a a0 9d :2 a0 c8 77 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
a0 6e d a0 51 d a0 51
d :2 a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
a0 b4 2e 11c 11d :3 a0 e9 d3
:3 a0 f 2b :2 a0 7e b4 2e a0
51 d :2 a0 7e 51 b4 2e d
:2 a0 6b :3 a0 a5 57 a0 6e d
b7 19 3c :2 a0 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e a0 b4 2e
d :2 a0 7e 51 b4 2e d b7
a0 47 :2 a0 e9 c1 91 51 :2 a0
63 37 :2 a0 7e 6e b4 2e d
b7 a0 47 :2 a0 6b :3 a0 a5 57
b7 a0 53 :2 a0 f :2 a0 e9 c1
b7 19 3c a0 62 b7 a6 9
a4 a0 b1 11 68 4f 9a 8f
a0 b0 3d 90 :2 a0 b0 3f 90
:2 a0 b0 3f b4 55 6a a0 9d
:2 a0 c8 77 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 a0 6e d :2 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 11c 11d :4 a0 e9 d3 5
:3 a0 f 2b :2 a0 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e d b7 a0 47
:2 a0 e9 c1 :3 a0 6e a5 b d
:2 a0 6b :3 a0 a5 57 b7 a0 53
:2 a0 f :2 a0 e9 c1 b7 19 3c
a0 62 b7 a6 9 a4 a0 b1
11 68 4f 9a 8f a0 b0 3d
8f a0 b0 3d 8f a0 b0 3d
90 :2 a0 b0 3f 90 :2 a0 b0 3f
b4 55 6a a0 9d :2 a0 c8 77
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 a0 51 d :2 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 11c 11d :4 a0 e9 d3 5
:3 a0 f 2b a0 7e b4 2e :2 a0
d b7 19 3c a0 7e 51 b4
2e a0 6e d b7 a0 6e d
b7 :2 19 3c :2 a0 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
d :2 a0 6b :3 a0 a5 57 :2 a0 7e
51 b4 2e d b7 a0 47 :2 a0
e9 c1 b7 a0 53 :2 a0 f :2 a0
e9 c1 b7 19 3c a0 62 b7
a6 9 a4 a0 b1 11 68 4f
9a 90 :2 a0 b0 3f 8f a0 b0
3d 96 :2 a0 b0 54 96 :2 a0 b0
54 b4 55 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 8b b0 2a :3 a0 7e
51 b4 2e b4 5d :2 a0 6b a0
6e 7e a0 b4 2e 7e 6e b4
2e 7e a0 b4 2e a5 57 :2 a0
d :2 a0 7e 51 a0 b4 2e 82
a0 6e 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 :4 a0 11e 11d :2 a0
6b a0 6e a5 57 :3 a0 7e b4
2e 2b a0 51 7e a0 b4 2e
d b7 a0 47 a0 7e 51 b4
2e a0 6e 7e 6e b4 2e 7e
a0 b4 2e d :2 a0 6b :2 a0 a5
57 :4 a0 11e 11d :2 a0 6b a0 6e
a5 57 b7 19 3c :2 a0 d :2 a0
d :2 a0 6b a0 6e 7e a0 b4
2e 7e 6e b4 2e 7e a0 b4
2e a5 57 b7 :2 a0 51 d a0
51 d b7 a6 9 a0 53 :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 a0 8d a0 b4 a0 2c 6a
a3 a0 1c 81 b0 :4 a0 a5 b
a5 b 51 a5 b ac :2 a0 b2
ee a0 7e 6e b4 2e ac e5
d0 b2 e9 b7 :2 a0 51 d b7
a6 9 :2 a0 51 d b7 a6 9
a4 b1 11 4f a0 :2 7e 51 b4
2e b4 2e a0 7e 51 b4 2e
d a0 b7 a0 7e 51 b4 2e
a0 51 d b7 :2 19 3c :2 a0 65
b7 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 a0 b0 3d
8f a0 b0 3d 8f :2 a0 6b 4d
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 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 51 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 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 :2 a0
7e 6e b4 2e 7e a0 b4 2e
d b7 :2 a0 d b7 :2 19 3c :2 a0
6b a0 6e a5 57 :5 a0 a5 57
:2 a0 7e a0 b4 2e 7e a0 b4
2e d a0 7e 51 b4 2e :3 a0
6b a0 a5 b d a0 6e 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
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
b7 :2 a0 d :2 a0 d b7 :2 19 3c
:2 a0 6b a0 6e a5 57 :3 a0 6b
a0 a5 b d a0 6e 7e 6e
b4 2e 7e a0 b4 2e d :2 a0
6b :2 a0 a5 57 :6 a0 11e 11d :2 a0
6b a0 6e a5 57 a0 51 d
a0 51 d a0 6e 7e a0 b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e 6e b4 2e d :2 a0 6b
:3 a0 a5 57 a0 6e d 91 :2 a0
6b :2 a0 6b a0 63 37 :2 a0 7e
b4 2e a0 51 d :2 a0 7e 51
b4 2e d :2 a0 6b :3 a0 a5 57
a0 6e d b7 19 3c :2 a0 7e
67: e b4 2e 7e :2 a0 a5 b b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e :2 a0 a5 b b4 2e d
:2 a0 7e 51 b4 2e d b7 a0
47 91 51 :2 a0 63 37 :2 a0 7e
6e b4 2e d b7 a0 47 :2 a0
7e 6e b4 2e d :2 a0 6b :3 a0
a5 57 a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e 6e b4 2e
d :2 a0 6b :3 a0 a5 57 :2 a0 6b
:3 a0 a5 57 :3 a0 6b d :2 a0 6b
:2 a0 51 a0 7e 51 b4 2e :3 a0
6b a5 57 :3 a0 6b a0 a5 b
d :2 a0 d :2 a0 6b a0 a5 57
:2 a0 6b a0 6e a5 57 :2 a0 6b
a0 6e a5 57 :2 a0 6b :3 a0 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 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
a0 b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
a0 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 :2 a0 6b :3 a0 a5 57 :2 a0
6b a0 6e a5 57 a0 6e 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 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 :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 b7 a0 53 a0 57 a0
b4 e9 :2 a0 6b a0 a5 b :2 a0
6b a0 a5 57 b7 19 3c :2 a0
6b :3 a0 a5 57 :2 a0 6b :3 a0 a5
57 :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 4d 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
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 a0 7e b4 2e :2 a0 7e
6e b4 2e 7e a0 b4 2e d
b7 :2 a0 d b7 :2 19 3c :2 a0 6b
a0 6e a5 57 :5 a0 a5 57 :2 a0
7e a0 b4 2e 7e a0 b4 2e
7e a0 b4 2e d a0 7e 51
b4 2e :2 a0 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e d
b7 :2 a0 d b7 :2 19 3c :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 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 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 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 a0 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 a0 6e 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 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 :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
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 :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 4d b0 3d 8f :2 a0
6b 4d 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
81 b0 a3 a0 1c a0 81 b0
a3 a0 1c a0 81 b0 a3 a0
1c a0 81 b0 a3 a0 1c 81
b0 a3 a0 1c 51 81 b0 a3
a0 1c 81 b0 a3 a0 1c 51
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
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 a5 b :4 a0
6b :2 a0 a5 b a5 57 b7 19
3c a0 7e b4 2e :2 a0 7e 6e
b4 2e 7e a0 b4 2e d b7
:2 a0 d b7 :2 19 3c :2 a0 6b a0
6e a5 57 :3 a0 6b a0 a5 b
d :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

Line 4: ibute_name, :
1s.minv, :
1s.maxv, :
1CASE WHEN s.minv = s.maxv THEN 1 ELSE d.num_bins END num_bins, :
1(s.maxv - s.minv)/d.num_bins incv :
1FROM %num_det_tab% d, :
1(SELECT /+ PARALLEL(t) / :
1%attr_col% attribute_name, :
1MIN(%val_col%) minv, :
1MAX(%val_col%) maxv :
1FROM %dat_tab% t :
1GROUP BY %attr_col% :
1HAVING MIN(%val_col%) IS NOT NULL) s :
1WHERE d.column_name = s.attribute_name) sd, :
1%bin_id_tab% bn :
1WHERE bn.bin <= sd.num_bins):
1%dat_tab%:
1%attr_col%:
1%val_col%:
1%num_det_tab%:
1%num_bin_hint%:
1INSTR:
1Clean up BIN_ID table:
1FIND_BB_CAT_TRANSACTIONAL:
1V_SELECT_STMT:
132767:
11000:
1V_OTHER_BIN_NUMBER:
1V_CATEGORIES:
1NUMBER_LIST_TYPE:
1V_CURRENT_COLUMN:
1V_ROWNUM:
1V_OTHER_CATEGORY:
1V_CAT_STR:
1COUNT:
1ATTR_NAME:
1TOPN:
1BEGIN SELECT :
1 BULK COLLECT INTO ::1 :
1 FROM ( SELECT :
1, COUNT() cnt FROM :
1 = :
1':
1 ORDER BY cnt DESC) WHERE rownum < :
1; END;:
1CAT_ID:
1OTHER_NAME:
1EXEC_AND_INSERT_NUMERIC_STATS:
1TABLE_NAME_IN:
1STATEMENT:
1VARCHAR2S:
1TABLE_COUNT:
1NUM_COLS_IN_STMT:
1NUMERICAL_LIST:
1START_COLUMN_NUM:
1V_POSITION:
1V_MIN_LIST:
1V_MAX_LIST:
1V_NUM_STATS_ID:
1V_COLUMN_IN_TAB:
1C_CAT:
1C_DEST:
1V_FIELD_MODE_STR:
14000:
1V_CAT_STAT_ID:
1V_FIRST_TIME:
1V_STMT:
1V_MEDIAN_STMT:
1CUR_MEDIAN:
1V_STMT_INSERT:
1V_HIST_COUNT:
1V_FIELD_MODE:
1V7:
1DEFINE_COLUMN:
1EXECUTE_AND_FETCH:
1COLUMN_VALUE:
1NUM_QUANTILES:
1FIND_BB_NUMERIC_2D:
1V_DETAILS_LIST:
1V_CUR_POS:
1V_CUR_NUM:
1V_TOT_NUM:
1FIND_BB_CATEGORICAL_2D:
1NAMES_LIST_TYPE:
1V_CAT_NUM:
1 IS NOT NULL GROUP BY :
1FIND_AND_INSERT_2D_BOUNDARIES:
1P_NUMERIC_DETAILS_TABLE:
1P_CATEGORICAL_DETAILS_TABLE:
1P_NUMERIC_OUTPUT_NAME:
1P_CATEGORICAL_OUTPUT_NAME:
1P_OUTPUT_SCHEMA:
1V_DATA_TABLE_NAME:
1V_OUTPUT_TABLE_NAME:
1FIND_AND_INSERT_TX_BOUNDARIES:
1MAKE_2D_STATEMENT:
1P_VIEW_STATEMENT:
1P_TABLE_COUNT:
1P_CURRENT_COLUMN:
1P_STAT_TYPE:
1P_DETAILS_NUMERIC:
1P_DETAILS_CAT:
1P_NUMERIC_OPEN_ENDED:
1V_TEMP_STMT:
1V_SELECT_NUM_BB:
1V_SELECT_CAT_BB:
1V_UPPER_BOUNDARIES:
1V_LOWER_BOUNDARIES:
1V_BIN_NUMBERS:
1BEGIN :n SELECT LOWER_BOUNDARY,UPPER_BOUNDARY,BIN_ID BULK COLLECT INTO ::1+
1,::2,::3 :
1 COLUMN_NAME = :
1 ORDER BY BIN_ID ASC; END;:
1BEGIN:n SELECT CATEGORY,GROUP_ID BULK COLLECT INTO ::1, ::2 FROM :
1 ORDER BY GROUP_ID ASC; END;:
1 ( case when :
1>= :
1NUM_CLAUSES:
1 when :
1 >= :
1 and :
1 then :
1 else null end) :
1= :
1 is null then :
1'':
1 is null then null else :
1 end) :
1MAKE_TX_STATEMENT:
1P_ATTR_COLUMN_NAME:
1P_CURRENT_ATTR:
1BEGIN:n SELECT CATEGORY_VALUE,GROUP_ID BULK COLLECT INTO ::1, ::2 FROM :
1 end ):
1P_DATA_TABLE_SCHEMA:
1P_CAT_DETAILS_TABLE:
1P_DETAILS_SCHEMA:
1P_RESULT_TABLE_NAME:
1P_RESULT_SCHEMA_NAME:
1V_DATA_TABLE:
1V_RESULT_VIEW:
1V_VIEW_STATEMENT:
1V_NUM_COLS:
1V_REC_TAB:
1DESC_TAB:
1V_COLUMNS_LIST:
1V_TEMP_TABLE_NAME:
1V_STAT_TYPE:
1V_TABLE_COUNT:
1V_DETAILS_NUMERIC:
170:
1V_DETAILS_CAT:
1V_CREATE_CURSOR:
1V_BOOL_NUM_OPEN_ENDED:
1SELECT FROM :
1DESCRIBE_COLUMNS:
1COL_COUNTER:
1COL_NAME:
1DISCR_:
1SYSTIMESTAMP:
1HH24_MI_SS_FF:
1DBMS_RANDOM:
1STRING:
14:
1DUAL:
1 AS :n SELECT distinct COLUMN_NAME,:
1 as stat_type FROM :
1 UNION ALL :
1 SELECT distinct COLUMN_NAME, :
1CREATE VIEW :
1 AS SELECT :
1BEGIN SELECT stat_type INTO ::1 FROM :
1 WHERE COLUMN_NAME = ::2; END;:
1":
1",:
1 DROP TABLE :
1DISCRETIZE_TRANSACTIONAL:
1P_SEQ_COLUMN_NAME:
1V_RANGE_BIN_TABLE_LOC:
1V_NVAL_BIN_TABLE_LOC:
1V_DFLT_BIN_TABLE_LOC:
1V_BIN_DATA_VIEW_LOC:
1V_DATA_TABLE_LOC:
1V_NUM_BIN_TABLE_LOC:
1V_CAT_BIN_TABLE_LOC:
1V_SQL_SELECT:
1p_data_table_schema:
1p_seq_column_name:
1p_attr_column_name:
1p_numeric_details_table:
1p_cat_details_table:
1p_details_schema:
1p_result_table_name:
1p_result_schema_name:
1p_numeric_open_ended:
1SELECT column_name, :
1CASE WHEN bin_id = 1 THEN -1.0e125 ELSE lower_boundary END l, :
1CASE WHEN bin_id = max_bin THEN 1.0e125 ELSE upper_boundary END u, :
1bin_id :
1FROM %num_bin_tab% t):
1ORGANIZATION INDEX NOPARALLEL NOLOGGING AS :
1WHERE bin_id > 1:
1COMMENT ON TABLE :
1 IS ':
1P_BIN_NUM_TABLE_NAME:
1P_BIN_CAT_TABLE_N