---------------------- M4 Operators --------------------------

INSERT INTO operator_t VALUES (34, 'MultiRelationalFeatureConstruction', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   34,    1,      1,    'TheInputConcept',    'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   34,    1,   NULL,    'TheConcepts',        'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   34,    1,   NULL,    'TheRelations',       'IN', 'REL', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   34,    1,   NULL,    'TheChainedFeatures', 'IN', 'FEA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   34,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 34, 'COMP',     'TheInputConcept',  'TheRelations',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 34, 'COMP',        'TheRelations',   'TheConcepts',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 34,   'IN',  'TheChainedFeatures',  'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 34,   'IN',  'TheChainedFeatures',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 34,   'IN',  'TheChainedFeatures',  'TheConcepts',      NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 34, 'PROJ', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 
-- input is proj of output
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 34, 'PROJ', 'TheConcepts',     'TheOutputConcept', NULL, NULL); 
-- theConcepts are proj of output

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 34, 'SZ_BY_REL', 'TheRelations', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 34, 'MM_FROM',   'TheChainedFeatures', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 34, 'VL_FROM',   'TheChainedFeatures', NULL, NULL, NULL);


-------------------------------------------------------
INSERT INTO operator_t VALUES (37, 'RowSelectionByRandomSampling', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   37,    1,      1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   37,    1,      1,             'HowMany',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   37,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 37, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 37,      'TYPE',          'HowMany',         'NUMERIC',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 37,        'GE',          'HowMany',                 1,  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 37, 'SUBSET', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is subset of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 37, 'SZ_BY_VAL',  'HowMany', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 37, 'MM_UNCH', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 37, 'VL_UNCH', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 37, 'MV_BY_SEL', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 37, 'VF_BY_SEL', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (38, 'DeleteRecordsWithMissingValues', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   38,    1,      1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   38,    1,      1,  'TheTargetAttribute',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   38,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 38, 'SAME_FEAT',   'TheOutputConcept',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 38, 'IN',        'TheTargetAttribute',  'TheInputConcept',  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 38, 'SUBSET', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is subset of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 38, 'SZ_MIN_MV',  'TheTargetAttribute', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 38, 'NOT_NULL',    'TheTargetAttribute', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 38, 'MM_UNCH', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 38, 'VL_UNCH', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 38, 'MV_BY_SEL', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 38, 'VF_BY_SEL', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (39, 'RowSelectionByQuery', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   39,    1,      1,    'TheInputConcept',    'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   39,    1,      1,   'TheLeftCondition',    'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   39,    1,      1,'TheConditionOperator',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   39,    1,      1,   'TheRightCondition',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   39,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 39, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 39,        'IN', 'TheLeftCondition', 'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 39, 'IS_LOOPED', 'TheLeftCondition',              NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 39, 'IS_LOOPED', 'TheConditionOperator',          NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 39, 'IS_LOOPED', 'TheRightCondition',             NULL,  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 39, 'SUBSET', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is subset of input

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 39, 'ES_SELECT', 'TheInputConcept', 'TheLeftCondition', NULL, NULL); 

-------------------------------------------------------
INSERT INTO operator_t VALUES (40, 'SegmentationStratified', 'NO', 'YES','YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   40,    1,      1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   40,    1,      1,        'TheAttribute',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   40,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);

-- 'TheAttribute' is missing in the OutputConcept:
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 40,        'IN',     'TheAttribute',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 40, 'ALL_EXCEPT',    'TheAttribute',  'TheOutputConcept',  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 40, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 40, 'SZ_DIV_BY', 'TheAttribute',    NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 40, 'MM_UNCH',   'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 40, 'VL_UNCH',   'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 40, 'VF_BY_SEL', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
   
-------------------------------------------------------
INSERT INTO operator_t VALUES (42, 'SegmentationByPartitioning', 'NO', 'YES','YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   42,    1,      1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   42,    1,      1,   'HowManyPartitions',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   42,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 42, 'SAME_FEAT',  'TheOutputConcept',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 42,        'GE', 'HowManyPartitions',                  1,  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 42, 'SUBSET', 'TheOutputConcept', 'TheInputConcept', NULL, NULL);

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 42, 'SZ_DIV_BY', 'HowManyPartitions', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 42, 'MM_UNCH',   'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 42, 'VL_UNCH',   'TheInputConcept', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 42, 'VF_BY_SEL', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (43, 'FeatureSelectionByAttributes', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 43, 1,    1,       'TheInputConcept',     'IN',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 43, 1,    1,       'TheOutputConcept',    'OUT', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 43, 1, NULL,       'TheSelectedFeatures', 'OUT', 'FEA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 43, 'IN',         'TheOutputConcept',    'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 43, 'IN',         'TheSelectedFeatures', 'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 43, 'IN',         'TheSelectedFeatures', 'TheOutputConcept', NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 43, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 43, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (44, 'LinearScaling', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 44, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 44, 1,    1,       'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 44, 1,    1,              'NewRangeMin',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 44, 1,    1,              'NewRangeMax',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 44, 1,    1,       'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44, 'IS_LOOPED',   'TheTargetAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44, 'IS_LOOPED',   'NewRangeMin',                    NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44, 'IS_LOOPED',   'NewRangeMax',                    NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44, 'IS_LOOPED',   'TheOutputAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44,        'IN',   'TheTargetAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44,        'IN',   'TheOutputAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44, 'SAME_TYPE',   'TheTargetAttribute',  'TheOutputAttribute',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44,      'TYPE',   'NewRangeMin',         'NUMERIC',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44,      'TYPE',   'NewRangeMax',         'NUMERIC',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 44,        'GT',   'NewRangeMax',         'NewRangeMin',         NULL, NULL);

-- why not allow nulls? there will be nulls in the output, so what?
-- INSERT INTO op_cond_t VALUES (
--   COND_ID, 44, 'NOT_NULL', 'TheTargetAttribute', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 44, 'NOT_NULL', 'TheOutputAttribute',          NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 44, 'GE',       'TheOutputAttribute', 'NewRangeMin', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 44, 'LE',       'TheOutputAttribute', 'NewRangeMax', NULL, NULL);


-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 44, 'MIN_FROM',  'TheOutputAttribute', 'NewRangeMin',  NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 44, 'MAX_FROM',  'TheOutputAttribute', 'NewRangeMax',  NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 44, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (45, 'LogScaling', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 45, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 45, 1,    1,       'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 45, 1,    1,                  'LogBase',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 45, 1,    1,       'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 45, 'IS_LOOPED',   'TheTargetAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 45, 'IS_LOOPED',   'LogBase',                        NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 45, 'IS_LOOPED',   'TheOutputAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 45,        'IN',   'TheTargetAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 45,        'IN',   'TheOutputAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 45, 'SAME_TYPE',   'TheTargetAttribute',  'TheOutputAttribute',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 45,      'TYPE',   'LogBase',             'NUMERIC',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 45,        'GT',   'LogBase',             0,                     NULL, NULL);

-- why not allow nulls? there will be nulls in the output, so what?
-- INSERT INTO op_cond_t VALUES (
--   COND_ID, 45, 'NOT_NULL', 'TheTargetAttribute', NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 45, 'LOWERBOUND',       'TheTargetAttribute', 0,    NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 45, 'NOT_NULL', 'TheOutputAttribute', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 44, 'MV_FROM',  'TheTargetAttribute', 'TheOutputAttribute',  NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (46, 'AssignDefault', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 46, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 46, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 46, 1,   1,        'DefaultValue',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 46, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 46,        'IN',   'TheTargetAttribute',     'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 46,        'IN',   'TheOutputAttribute',     'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 46, 'IS_LOOPED',   'TheTargetAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 46, 'IS_LOOPED',   'DefaultValue',                   NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 46, 'IS_LOOPED',   'TheOutputAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 46, 'SAME_TYPE',   'TheOutputAttribute',  'TheTargetAttribute',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 46, 'TYPE',              'DefaultValue',             'NOMINAL',  NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 46, 'HAS_NULLS', 'TheTargetAttribute', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 46, 'NOT_NULL', 'TheOutputAttribute', NULL, NULL, NULL);

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 46, 'VL_FROM',  'TheTargetAttribute',  'TheOutputAttribute', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 46, 'MM_FROM',  'TheTargetAttribute',  'TheOutputAttribute', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 46, 'VF_REPL_MV', 'TheOutputAttribute',  'DefaultValue', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (47, 'AssignModalValue', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 47, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 47, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 47, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 47, 'IS_LOOPED',   'TheTargetAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 47, 'IS_LOOPED',   'TheOutputAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 47,        'IN',   'TheTargetAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 47,        'IN',   'TheOutputAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 47, 'SAME_TYPE',   'TheTargetAttribute',  'TheOutputAttribute', NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 47, 'HAS_NULLS', 'TheTargetAttribute', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 47, 'NOT_NULL', 'TheOutputAttribute', NULL, NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (48, 'AssignMedianValue', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 48, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 48, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 48, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 48, 'IS_LOOPED',   'TheTargetAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 48, 'IS_LOOPED',   'TheOutputAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 48,        'IN',   'TheTargetAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 48,        'IN',   'TheOutputAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 48, 'SAME_TYPE',   'TheTargetAttribute',  'TheOutputAttribute', NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 48, 'HAS_NULLS', 'TheTargetAttribute', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 48, 'NOT_NULL', 'TheOutputAttribute', NULL, NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (49, 'AssignAverageValue', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 49, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 49, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 49, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 49, 'IS_LOOPED',   'TheTargetAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 49, 'IS_LOOPED',   'TheOutputAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 49,        'IN',   'TheTargetAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 49,        'IN',   'TheOutputAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 49, 'SAME_TYPE',   'TheTargetAttribute',  'TheOutputAttribute', NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 49, 'HAS_NULLS', 'TheTargetAttribute', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 49, 'NOT_NULL', 'TheOutputAttribute', NULL, NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (50, 'AssignStochasticValue',  'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 50, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 50, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 50, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 50, 'IS_LOOPED',   'TheTargetAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 50, 'IS_LOOPED',   'TheOutputAttribute',             NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 50,        'IN',   'TheTargetAttribute',     'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 50,        'IN',   'TheOutputAttribute',     'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 50, 'SAME_TYPE',   'TheTargetAttribute',  'TheOutputAttribute',  NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 50, 'HAS_NULLS', 'TheTargetAttribute', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 50, 'NOT_NULL', 'TheOutputAttribute', NULL, NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (53, 'MissingValuesWithRegressionSVM', 'YES', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1,    1,       'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1, NULL,  'ThePredictingAttributes',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1,    1,               'KernelType',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 0,    1,               'SampleSize',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1,    1,          'LossFunctionPos',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1,    1,          'LossFunctionNeg',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1,    1,                        'C',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1,    1,                  'Epsilon',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 1,    1,       'TheOutputAttribute', 'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 0,    1,                'UseDB_SVM',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 53, 0,    1,                   'TheKey',  'IN',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED', 'TheTargetAttribute',      NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED', 'ThePredictingAttributes', NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED',        'KernelType',       NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED',        'SampleSize',       NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED',   'LossFunctionPos',       NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED',   'LossFunctionNeg',       NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED',                 'C',       NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED',           'Epsilon',       NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED','TheOutputAttribute',       NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED',         'UseDB_SVM',       NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'IS_LOOPED',            'TheKey',       NULL, NULL, NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'IN',       'TheTargetAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'IN',  'ThePredictingAttributes', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'IN',       'TheOutputAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53, 'SAME_TYPE',       'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,      'TYPE',  'ThePredictingAttributes',  'NOMINAL',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,      'TYPE',  'ThePredictingAttributes',  'BINARY',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,      'TYPE',  'ThePredictingAttributes',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,      'TYPE',               'SampleSize',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,      'TYPE',          'LossFunctionPos',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,      'TYPE',          'LossFunctionNeg',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,      'TYPE',                        'C',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,      'TYPE',                  'Epsilon',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'GE',               'SampleSize',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'GE',          'LossFunctionPos',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'GE',          'LossFunctionNeg',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'GE',                        'C',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'GE',                  'Epsilon',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,    'ONE_OF',               'KernelType',
    'dot polynomial neural radial anova', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 53,        'IN',                   'TheKey', 'TheInputConcept',    NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 53, 'HAS_NULLS',     'TheTargetAttribute',      NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 53, 'HAS_VALUES', 'TheTargetAttribute',      NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 53, 'NOT_NULL',      'ThePredictingAttributes', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 53, 'NOT_NULL', 'TheOutputAttribute',      NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 53, 'NOT_NULL', 'ThePredictingAttributes', NULL, NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (63, 'SupportVectorMachineForRegression', 'YES', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1,    1,       'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1, NULL,  'ThePredictingAttributes',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1,    1,               'KernelType',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 0,    1,               'SampleSize',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1,    1,          'LossFunctionPos',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1,    1,          'LossFunctionNeg',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1,    1,                        'C',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1,    1,                  'Epsilon',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 1,    1,       'TheOutputAttribute', 'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 0,    1,                'UseDB_SVM',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 63, 0,    1,                   'TheKey',  'IN',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED', 'TheTargetAttribute', NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED', 'ThePredictingAttributes', NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED',        'KernelType',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED',        'SampleSize',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED',   'LossFunctionPos',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED',   'LossFunctionNeg',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED',                 'C',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED',           'Epsilon',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED','TheOutputAttribute',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED',         'UseDB_SVM',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'IS_LOOPED',            'TheKey',  NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'IN',       'TheTargetAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'IN',  'ThePredictingAttributes', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'IN',       'TheOutputAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63, 'SAME_TYPE',       'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,      'TYPE',  'ThePredictingAttributes',  'NOMINAL',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,      'TYPE',  'ThePredictingAttributes',  'BINARY',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,      'TYPE',  'ThePredictingAttributes',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,      'TYPE',               'SampleSize',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,      'TYPE',          'LossFunctionPos',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,      'TYPE',          'LossFunctionNeg',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,      'TYPE',                        'C',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,      'TYPE',                  'Epsilon',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'GE',               'SampleSize',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'GE',          'LossFunctionPos',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'GE',          'LossFunctionNeg',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'GE',                        'C',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'GE',                  'Epsilon',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,    'ONE_OF',               'KernelType',
    'dot polynomial neural radial anova', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 63,        'IN',                   'TheKey', 'TheInputConcept',    NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 63, 'HAS_NULLS',          'TheTargetAttribute', NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 63, 'HAS_VALUES',         'TheTargetAttribute', NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 63, 'NOT_NULL',      'ThePredictingAttributes', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 63, 'NOT_NULL', 'TheOutputAttribute',      NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 63, 'NOT_NULL', 'ThePredictingAttributes', NULL, NULL, NULL);

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 63, 'VL_FROM', 'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (67, 'Windowing', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   67,    1,    1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   67,    1,    1,      'TimeBaseAttrib',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   67,    1,    1,     'ValueBaseAttrib',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   67,    1,    1,          'WindowSize',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   67,    1,    1,   'OutputTimeStartBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   67,    1,    1,     'OutputTimeEndBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   67,    1,    1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67,        'IN',   'TimeBaseAttrib',    'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67,        'IN',   'ValueBaseAttrib',   'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67,        'IN',   'OutputTimeStartBA', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67,        'IN',   'OutputTimeEndBA',   'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67,  'CREATE_BY',  'ValueBaseAttrib',        'WindowSize', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67,      'TYPE',   'TimeBaseAttrib',                'TIME', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67, 'SAME_TYPE',   'OutputTimeStartBA',   'TimeBaseAttrib', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67, 'SAME_TYPE',   'OutputTimeEndBA',     'TimeBaseAttrib', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67,      'TYPE',   'WindowSize',                 'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 67,        'GE',   'WindowSize',                        1,  NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 67, 'NOT_NULL', 'TimeBaseAttrib',  NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 67, 'UNIQUE',   'TimeBaseAttrib',  NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 67, 'ORDERED',  'TimeBaseAttrib', 'INC', NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'REL_N_1', 'TheOutputConcept',    'TheInputConcept',   NULL, NULL);
-- an n:1 relationship from output to input will model the foreign key relationship that holds
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'REL_N_K', 'OutputTimeStartBA', NULL, NULL, NULL);
-- the key on the "many-side" is given by the start time index in the output
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'REL_1_K',  'TimeBaseAttrib', NULL, NULL, NULL);
-- the key on the "one-side" is given by the time attribute in the input
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'NOT_NULL', 'OutputTimeStartBA',  NULL,             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'UNIQUE',   'OutputTimeStartBA',  NULL,             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'ORDERED',  'OutputTimeStartBA',  'INC',            NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'NOT_NULL', 'OutputTimeEndBA',    NULL,             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'UNIQUE',   'OutputTimeEndBA',    NULL,             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'ORDERED',  'OutputTimeEndBA',    'INC',            NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'LT',       'OutputTimeStartBA', 'OutputTimeEndBA', NULL, NULL);

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'SZ_DIV_BY', 'WindowSize', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'VL_FROM',   'ValueBaseAttrib', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'MM_FROM',   'ValueBaseAttrib', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'MM_FROM',   'TimeBaseAttrib', 'OutputTimeStartBA', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 67, 'MM_FROM',   'TimeBaseAttrib', 'OutputTimeEndBA', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (68, 'SignalToSymbolProcessing', 'NO', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,     'TheInputConcept',   'IN',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,         'InputTimeBA',   'IN',   'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,        'InputValueBA',   'IN',   'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,           'Tolerance',   'IN',    'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,      'AverageValueBA',   'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,     'IncreaseValueBA',   'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,   'OutputTimeStartBA',   'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,     'OutputTimeEndBA',   'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   68,    1,    1,    'TheOutputConcept',   'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,        'IN',   'InputTimeBA',       'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,        'IN',   'InputValueBA',      'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,        'IN',   'AverageValueBA',    'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,        'IN',   'IncreaseValueBA',   'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,        'IN',   'OutputTimeStartBA', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,        'IN',   'OutputTimeEndBA',   'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,      'TYPE',   'InputTimeBA',                  'TIME',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,      'TYPE',   'InputValueBA',              'NOMINAL',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,      'TYPE',   'InputValueBA',               'BINARY',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,      'TYPE',   'InputValueBA',              'NUMERIC',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68, 'SAME_TYPE',   'OutputTimeStartBA',     'InputTimeBA',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68, 'SAME_TYPE',   'OutputTimeEndBA',       'InputTimeBA',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68, 'SAME_TYPE',   'AverageValueBA',       'InputValueBA',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68, 'SAME_TYPE',   'IncreaseValueBA',      'InputValueBA',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,      'TYPE',   'Tolerance',                  'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 68,        'GE',   'Tolerance',                          1, NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 68, 'NOT_NULL', 'InputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 68, 'UNIQUE',   'InputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 68, 'ORDERED',  'InputTimeBA',  'INC', NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 68, 'NOT_NULL', 'InputValueBA', 'INC', NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'NOT_NULL', 'OutputTimeStartBA', NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'UNIQUE',   'OutputTimeStartBA', NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'ORDERED',  'OutputTimeStartBA', 'INC',             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'NOT_NULL', 'OutputTimeEndBA',   NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'UNIQUE',   'OutputTimeEndBA',   NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'ORDERED',  'OutputTimeEndBA',   'INC',             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'LT',       'OutputTimeStartBA', 'OutputTimeEndBA', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'NOT_NULL', 'AverageValueBA',    NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 68, 'NOT_NULL', 'IncreaseValueBA',   NULL,              NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (70, 'SimpleMovingFunction', 'NO', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,         'InputTimeBA',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,        'InputValueBA',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,          'WindowSize',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,            'Distance',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,   'OutputTimeStartBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,     'OutputTimeEndBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,       'OutputValueBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   70,    1,    1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,        'IN',   'InputTimeBA',       'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,        'IN',   'InputValueBA',      'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,        'IN',   'OutputTimeStartBA', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,        'IN',   'OutputTimeEndBA',   'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,        'IN',   'OutputValueBA',     'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,      'TYPE',   'InputTimeBA',                   'TIME', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,      'TYPE',   'InputValueBA',              'NOMINAL',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,      'TYPE',   'InputValueBA',               'BINARY',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,      'TYPE',   'InputValueBA',              'NUMERIC',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70, 'SAME_TYPE',   'OutputTimeStartBA',      'InputTimeBA', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70, 'SAME_TYPE',   'OutputTimeEndBA',        'InputTimeBA', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70, 'SAME_TYPE',   'InputValueBA',         'OutputValueBA', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,      'TYPE',   'WindowSize',                 'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,      'TYPE',   'Distance',                   'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,        'GE',   'WindowSize',                        1,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 70,        'GE',   'Distance',                          1,  NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 70, 'NOT_NULL', 'InputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 70, 'UNIQUE',   'InputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 70, 'ORDERED',  'InputTimeBA',  'INC', NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 70, 'NOT_NULL', 'InputValueBA', 'INC', NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 70, 'NOT_NULL', 'OutputTimeStartBA', NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 70, 'UNIQUE',   'OutputTimeStartBA', NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 70, 'ORDERED',  'OutputTimeStartBA', 'INC',             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 70, 'NOT_NULL', 'OutputTimeEndBA',   NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 70, 'UNIQUE',   'OutputTimeEndBA',   NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 70, 'ORDERED',  'OutputTimeEndBA',   'INC',             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 70, 'LT',       'OutputTimeStartBA', 'OutputTimeEndBA', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 70, 'NOT_NULL', 'OutputValueBA',     NULL,              NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (71, 'WeightedMovingFunction', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1,    1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1,    1,         'InputTimeBA',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1,    1,        'InputValueBA',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1, NULL,             'Weights',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1,    1,            'Distance',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1,    1,   'OutputTimeStartBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1,    1,     'OutputTimeEndBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1,    1,       'OutputValueBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   71,    1,    1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,        'IN',   'InputTimeBA',       'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,        'IN',   'InputValueBA',      'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,        'IN',   'OutputTimeStartBA', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,        'IN',   'OutputTimeEndBA',   'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,        'IN',   'OutputValueBA',     'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,      'TYPE',   'InputTimeBA',                   'TIME', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,      'TYPE',   'InputValueBA',              'NOMINAL',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,      'TYPE',   'InputValueBA',               'BINARY',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,      'TYPE',   'InputValueBA',              'NUMERIC',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71, 'SAME_TYPE',   'OutputTimeStartBA',     'InputTimeBA',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71, 'SAME_TYPE',   'OutputTimeEndBA',       'InputTimeBA',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71, 'SAME_TYPE',   'InputValueBA',         'OutputValueBA', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,      'TYPE',   'Weights',                   'NUMERIC',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,      'TYPE',   'Distance',                  'NUMERIC',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,       'SUM',   'Weights',                           1,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 71,        'GE',   'Distance',                          1,  NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 71, 'NOT_NULL', 'InputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 71, 'UNIQUE',   'InputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 71, 'ORDERED',  'InputTimeBA',  'INC', NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 71, 'NOT_NULL', 'InputValueBA', 'INC', NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 71, 'NOT_NULL', 'OutputTimeStartBA', NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 71, 'UNIQUE',   'OutputTimeStartBA', NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 71, 'ORDERED',  'OutputTimeStartBA', 'INC',             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 71, 'NOT_NULL', 'OutputTimeEndBA',   NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 71, 'UNIQUE',   'OutputTimeEndBA',   NULL,              NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 71, 'ORDERED',  'OutputTimeEndBA',   'INC',             NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 71, 'LT',       'OutputTimeStartBA', 'OutputTimeEndBA', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 71, 'NOT_NULL', 'OutputValueBA',     NULL,              NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (72, 'ExponentialMovingFunction', 'NO', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,         'InputTimeBA',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,        'InputValueBA',   'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,          'HeadWeight',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,          'TailWeight',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,            'Distance',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,        'OutputTimeBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,       'OutputValueBA',  'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   72,    1,    1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,        'IN',   'InputTimeBA',       'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,        'IN',   'InputValueBA',      'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,        'IN',   'OutputTimeBA',     'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,        'IN',   'OutputValueBA',    'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,      'TYPE',   'InputTimeBA',                  'TIME', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,      'TYPE',   'InputValueBA',              'NOMINAL',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,      'TYPE',   'InputValueBA',               'BINARY',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,      'TYPE',   'InputValueBA',              'NUMERIC',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72, 'SAME_TYPE',   'OutputTimeBA',          'InputTimeBA', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72, 'SAME_TYPE',   'InputValueBA',        'OutputValueBA', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,      'TYPE',   'HeadWeight',                'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,      'TYPE',   'TailWeight',                'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,      'TYPE',   'Distance',                  'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,       'SUM',   'HeadWeight,TailWeight',             1, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 72,        'GE',   'Distance',                          1, NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 72, 'NOT_NULL', 'InputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 72, 'UNIQUE',   'InputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 72, 'ORDERED',  'InputTimeBA',  'INC', NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 72, 'NOT_NULL', 'InputValueBA', 'INC', NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 72, 'NOT_NULL', 'OutputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 72, 'UNIQUE',   'OutputTimeBA',  NULL,  NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 72, 'ORDERED',  'OutputTimeBA',  'INC', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 72, 'NOT_NULL', 'OutputValueBA', NULL,  NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (73, 'ComputeSVMError', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 73, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 73, 1,    1,       'TheTargetValueAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 73, 1,    1,   'ThePredictedValueAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 73, 0,    1,          'LossFunctionPos',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 73, 0,    1,          'LossFunctionNeg',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 73, 1,    1,                        'C',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 73, 1,    1,                  'Epsilon',  'IN',   'V', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,        'IN',      'TheTargetValueAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,        'IN',   'ThePredictedValueAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',     'TheTargetValueAttribute',  'NOMINAL',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',     'TheTargetValueAttribute',  'BINARY',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',     'TheTargetValueAttribute',  'NUMERIC',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',  'ThePredictedValueAttribute',  'NOMINAL',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',  'ThePredictedValueAttribute',  'BINARY',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',  'ThePredictedValueAttribute',  'NUMERIC',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',         'LossFunctionPos',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',         'LossFunctionNeg',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',                       'C',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,       'TYPE',                 'Epsilon',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,         'GE',         'LossFunctionPos',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,         'GE',         'LossFunctionNeg',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,         'GE',                       'C',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 73,         'GE',                 'Epsilon',          0,           NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 73, 'NOT_NULL',      'ThePredictedValueAttribute', NULL, NULL, NULL);

-- no assertions
-------------------------------------------------------
INSERT INTO operator_t VALUES (74, 'Unsegment', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   74,    1,      1,    'TheInputConcept',    'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   74,    1,      1,    'UnsegmentAttribute', 'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   74,    1,      1,    'TheOutputConcept',   'OUT', 'CON', NULL);

-- constraint: 'UnsegmentAttribute' in 'TheOutputConcept' or pseudo-BA,
--       In one of the preceding steps: Segment by 'UnsegmentAttribute'
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 74,        'IN',   'UnsegmentAttribute', 'TheOutputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 74, 'SAME_FEAT',   'TheOutputConcept',   'TheInputConcept',  NULL, NULL);
  
-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID,  74, 'SUBSET', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 
-- input is subset of output
INSERT INTO op_assert_t VALUES (
  ASSERT_ID,  74, 'NOT_NULL', 'UnsegmentAttribute', NULL, NULL, NULL); 

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

INSERT INTO operator_t VALUES (76, 'JoinByKey', 'NO', 'NO', 'YES', NULL);

-- (the operator is not applied in loops but 
--  uses the loop mechanism for parameter specification)

INSERT INTO op_params_t VALUES (
  PARAM_ID,   76,    2,   NULL,    'TheConcepts',        'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   76,    2,   NULL,    'TheKeys',            'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   76,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   76,    0,   NULL,    'MapInput',              'IN', 'FEA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   76,    0,   NULL,    'MapOutput',            'OUT', 'FEA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76,   'IN',        'TheKeys',   'TheConcepts',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76,   'IN',        'MapInput',  'TheConcepts',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76, 'COORD', 'MapInput',  'MapOutput',	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76, 'COORD', 'TheKeys', 'TheConcepts',	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76, 'ALL_EXCEPT',   'TheKeys',   'TheOutputConcept',	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76, 'ALL_EXCEPT',   'MapInput',  'TheOutputConcept',	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76, 'MATCHBYCON',   'TheKeys',   NULL,	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76, 'RENAME_OUT',  'MapInput',  'MapOutput',	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 76, 'NO_COMMON',  'TheConcepts',  NULL,	 NULL, NULL);


-- no conditions
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 76, 'PROJ',     'TheConcepts', 'TheOutputConcept', NULL, NULL); 
-- theConcepts are projs of output

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 76, 'SZ_BY_REL', 'TheConcepts', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 76, 'MM_UNCH', 'TheConcepts', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 76, 'VL_UNCH', 'TheConcepts', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (77, 'SpecifiedStatistics', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    1,   1,    'TheInputConcept',          'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'GroupBy',                  'IN', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'AttributesComputeSum',     'IN', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'AttributesComputeCount',   'IN', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'AttributesComputeUnique',  'IN', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'AttributesComputeMin',     'IN', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'AttributesComputeMax',     'IN', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'AttributesComputeAvg',     'IN', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'AttributesComputeDistrib', 'IN', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    0,   NULL, 'DistribValues',            'IN', 'V',   NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   77,    1,      1, 'TheOutputConcept',        'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'GroupBy',                  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'GroupBy',                  'TheOutputConcept',   NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'AttributesComputeSum',     'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'AttributesComputeCount',   'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'AttributesComputeUnique',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'AttributesComputeDistrib', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'AttributesComputeMin',     'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'AttributesComputeMax',     'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'IN',   'AttributesComputeAvg',     'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77, 'COORD', 'AttributesComputeDistrib', 'DistribValues',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'TYPE', 'AttributesComputeSum',     'NUMERIC',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'TYPE', 'AttributesComputeAvg',     'NUMERIC',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'TYPE', 'AttributesComputeMin',     'NUMERIC',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'TYPE', 'AttributesComputeMax',     'NUMERIC',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'CR_SUFFIX', 'AttributesComputeMax',     'MAX',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'CR_SUFFIX', 'AttributesComputeSum',     'SUM',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'CR_SUFFIX', 'AttributesComputeMin',     'MIN',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'CR_SUFFIX', 'AttributesComputeAvg',     'AVG',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'CR_SUFFIX', 'AttributesComputeUnique',  'UNIQUE',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'CR_SUFFIX', 'AttributesComputeCount',   'COUNT',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'OUT_TYPE', 'AttributesComputeMax',     'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'OUT_TYPE', 'AttributesComputeSum',     'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'OUT_TYPE', 'AttributesComputeMin',     'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'OUT_TYPE', 'AttributesComputeAvg',    'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'OUT_TYPE', 'AttributesComputeUnique',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'OUT_TYPE', 'AttributesComputeCount',   'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'OUT_TYPE', 'AttributesComputeDistrib', 'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'CREATE_BY', 'AttributesComputeDistrib',   'DistribValues',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID,  77,  'USE_VALS',  'DistribValues',    'AttributesComputeDistrib', NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 77, 'REL_N_1', 'TheInputConcept',    'TheOutputConcept',   NULL, NULL);
-- an n:1 relationship from input to output exists (if there are any group-by attributes)
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 77, 'REL_N_K', 'GroupBy',            NULL, NULL, NULL);
-- the keys on the "many-side" are given by the GroupBy attributes
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 77, 'REL_1_K', 'GroupBy',            NULL, NULL, NULL);
-- the keys on the "one-side" are given by the GroupBy attributes

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 77, 'SZ_BY_VL', 'GroupBy', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 77, 'VF_BY_AGG', 'GroupBy', NULL, NULL, NULL);

-------------------------------------------------------
-- INSERT INTO operator_t VALUES (82, 'PredictionWithDecisionTree','YES','NO','NO',NULL);

-- INSERT INTO op_params_t VALUES (
--   PARAM_ID, 82, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
-- INSERT INTO op_params_t VALUES (
--   PARAM_ID, 82, 1,    1,       'TheTargetAttribute',  'IN',  'BA', NULL);
-- INSERT INTO op_params_t VALUES (
--   PARAM_ID, 82, 1, NULL,  'ThePredictingAttributes',  'IN',  'BA', NULL);
-- INSERT INTO op_params_t VALUES (
--   PARAM_ID, 82, 1,    1,               'SampleSize',  'IN',   'V', NULL);
-- INSERT INTO op_params_t VALUES (
--   PARAM_ID, 82, 1,    1,       'TheOutputAttribute', 'OUT',  'BA', NULL);
-- INSERT INTO op_params_t VALUES (
--   PARAM_ID, 82, 1,    1,               'PruningConf',  'IN',   'V', NULL);

--- Constraints

-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82, 'IS_LOOPED',       'TheTargetAttribute',  NULL, NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82, 'IS_LOOPED',  'ThePredictingAttributes',  NULL, NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82, 'IS_LOOPED',               'SampleSize',  NULL, NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82, 'IS_LOOPED',       'TheOutputAttribute',  NULL, NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82, 'IS_LOOPED',               'PruningConf', NULL, NULL, NULL);
-- 
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,        'IN',       'TheTargetAttribute', 'TheInputConcept',    NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,        'IN',  'ThePredictingAttributes', 'TheInputConcept',    NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,        'IN',       'TheOutputAttribute', 'TheInputConcept',    NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82, 'SAME_TYPE',       'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,      'TYPE',  'ThePredictingAttributes',  'NOMINAL',            NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,      'TYPE',  'ThePredictingAttributes',  'NUMERIC',        NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,      'TYPE',  'ThePredictingAttributes',  'BINARY',        NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,      'TYPE',  'TheTargetAttribute',  'NOMINAL',            NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,      'TYPE',               'SampleSize',  'NUMERIC',           NULL, NULL);
-- INSERT INTO op_constr_t VALUES (
--   CONSTR_ID, 82,      'TYPE',               'PruningConf',  'NUMERIC',           NULL, NULL);
-- 
-- conditions

-- INSERT INTO op_cond_t VALUES (
--   COND_ID, 82, 'HAS_NULLS',     'TheTargetAttribute',      NULL, NULL, NULL);
-- INSERT INTO op_cond_t VALUES (
--   COND_ID, 82, 'HAS_VALUES', 'TheTargetAttribute',      NULL, NULL, NULL);
-- INSERT INTO op_cond_t VALUES (
--   COND_ID, 82, 'NOT_NULL',      'ThePredictingAttributes', NULL, NULL, NULL);
-- 
-- assertions

-- INSERT INTO op_assert_t VALUES (
--   ASSERT_ID, 82, 'NOT_NULL', 'TheOutputAttribute',      NULL, NULL, NULL);
-- INSERT INTO op_assert_t VALUES (
--   ASSERT_ID, 82, 'NOT_NULL', 'ThePredictingAttributes', NULL, NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (84, 'Apriori', 'NO', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'TheInputConcept',  'IN',  'CON', NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'TheOutputConcept', 'OUT', 'CON', NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'CustID',           'IN',  'BA',  NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'TransID',          'IN',  'BA',  NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'Item',             'IN',  'BA',  NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'MinSupport',       'IN',  'V',   NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'MinConfidence',    'IN',  'V',   NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'SampleSize',       'IN',  'V',   NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'PremiseBA',       'OUT', 'BA',   NULL );
INSERT INTO op_params_t VALUES (
PARAM_ID, 84, 1, 1, 'ConclusionBA',    'OUT', 'BA',   NULL );

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84,        'IN',   'CustID',       'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84,        'IN',   'TransID',      'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84,        'IN',   'Item',         'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84,        'IN',   'PremiseBA',    'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84,        'IN',   'ConclusionBA', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84,        'TYPE', 'PremiseBA',    'NOMINAL',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84,        'TYPE', 'ConclusionBA', 'NOMINAL',          NULL, NULL );
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84, 'GE', 'MinSupport',    0, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84, 'GE', 'MinConfidence',    0, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 84, 'LE', 'MinConfidence',    1, NULL, NULL);

-- further constraints still missing
-- conditions still missing
-- assertions still missing
-------------------------------------------------------
INSERT INTO operator_t VALUES (85, 'StatisticalFeatureSelection','NO','NO','NO',NULL);

-- Parameters

INSERT INTO op_params_t VALUES (
  PARAM_ID, 85, 1,    1,          'TheInputConcept',  'IN',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 85, 1,    NULL,       'TheAttributes',    'IN',   'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 85, 1,    1,               'SampleSize',  'IN',    'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 85, 1,    1,       'TheOutputConcept',   'OUT',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 85, 1,    1,               'Threshold',   'IN',    'V', NULL);

-- Constraints

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 85,      'IN',    'TheAttributes',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 85,      'TYPE',  'TheAttributes',  'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 85,      'TYPE',  'TheAttributes',  'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 85,      'TYPE',  'TheAttributes',  'BINARY',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 85,      'TYPE',  'SampleSize',     'NUMERIC',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 85,      'TYPE',  'Threshold',      'NUMERIC',            NULL, NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 85, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- conditions still missing

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 85, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 85, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (86, 'GeneticFeatureSelection','NO','NO','NO',NULL);

-- Parameters

INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    NULL,       'TheAttributes',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    1,       'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    1,               'SampleSize',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    1,       'TheOutputConcept', 'OUT',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    1,               'PopDim',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    1,               'StepNum',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    1,               'ProbMut',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 86, 1,    1,               'ProbCross',  'IN',   'V', NULL);

-- Constraints

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,        'IN',  'TheAttributes',       'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,        'IN',  'TheTargetAttribute',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'TheTargetAttribute',  'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'TheAttributes',       'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'TheAttributes',       'BINARY',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'TheAttributes',       'NOMINAL',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'SampleSize',          'NUMERIC',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'PopDim',              'NUMERIC',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'StepNum',             'NUMERIC',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'ProbMut',             'NUMERIC',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86,      'TYPE',  'ProbCross',           'NUMERIC',          NULL, NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 86, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- conditions still missing

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 86, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 86, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (87, 'SGFeatureSelection','NO','NO','NO',NULL);

-- Parameters

INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'TheInputConcept',  'IN',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    NULL,    'TheAttributes',    'IN',   'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'TheTargetAttribute', 'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'SampleSize',       'IN',   'V',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'TheOutputConcept', 'OUT',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'Threshold',        'IN',   'V',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'PopDim',           'IN',   'V',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'StepNum',          'IN',   'V',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'ProbMut',          'IN',   'V',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 87, 1,    1,       'ProbCross',        'IN',   'V',  NULL);

-- Constraints

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,        'IN',  'TheAttributes',       'TheInputConcept',   NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,        'IN',  'TheTargetAttribute',  'TheInputConcept',   NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'TheTargetAttribute',  'NOMINAL',        NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'TheAttributes',       'NOMINAL',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'TheAttributes',       'NUMERIC',        NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'TheAttributes',       'BINARY',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'SampleSize',          'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'PopDim',              'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'StepNum',             'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'ProbMut',             'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'ProbCross',           'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87,      'TYPE',  'Threshold',           'NUMERIC',           NULL, NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 87, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- conditions still missing

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 87, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 87, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);

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

INSERT INTO operator_t VALUES (88, 'FeatureSelectionWithSVM', 'NO', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,       'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1, NULL,            'TheAttributes',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,               'KernelType',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,                        'C',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,                  'Epsilon',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,          'SearchDirection',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,      'PositiveTargetValue',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,                   'TheKey',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 1,    1,       'TheOutputConcept',   'OUT', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 0,    1,               'SampleSize',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 88, 0,    1,                'UseDB_SVM',  'IN',   'V', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,        'IN',       'TheTargetAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,        'IN',            'TheAttributes', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88, 'SAME_TYPE',       'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,      'TYPE',                        'C',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,      'TYPE',                  'Epsilon',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,      'TYPE',               'SampleSize',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,        'GE',                        'C',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,        'GE',                  'Epsilon',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,        'GE',               'SampleSize',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,    'ONE_OF',               'KernelType',   'dot polynomial neural radial anova', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,    'ONE_OF',          'SearchDirection',   'backward forward', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,    'ONE_OF',                'UseDB_SVM',      'true false',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88,        'IN',                   'TheKey', 'TheInputConcept',    NULL, NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 88, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 88, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL);
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 88, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);

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

INSERT INTO operator_t VALUES (89, 'SupportVectorMachineForClassification', 'YES', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 1,    1,       'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 1, NULL,  'ThePredictingAttributes',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 1,    1,               'KernelType',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 0,    1,               'SampleSize',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 1,    1,                        'C',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 1,    1,                  'Epsilon',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 1,    1,       'TheOutputAttribute', 'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 1,    1,      'PositiveTargetValue',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 0,    1,                'UseDB_SVM',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 89, 0,    1,                   'TheKey',  'IN',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED',  'TheTargetAttribute',      NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED',  'ThePredictingAttributes', NULL, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED',         'KernelType',       NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED',         'SampleSize',       NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED',                  'C',       NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED',            'Epsilon',       NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED', 'TheOutputAttribute',       NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED', 'PositiveTargetValue',      NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED',         'UseDB_SVM',        NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'IS_LOOPED',            'TheKey',        NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,        'IN',       'TheTargetAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,        'IN',  'ThePredictingAttributes', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,        'IN',       'TheOutputAttribute', 'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89, 'SAME_TYPE',       'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,      'TYPE',  'ThePredictingAttributes',  'NOMINAL',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,      'TYPE',  'ThePredictingAttributes',  'BINARY',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,      'TYPE',  'ThePredictingAttributes',  'NUMERIC',            NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,      'TYPE',               'SampleSize',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,      'TYPE',                        'C',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,      'TYPE',                  'Epsilon',  'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,        'GE',               'SampleSize',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,        'GE',                        'C',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,        'GE',                  'Epsilon',          0,           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,    'ONE_OF',               'KernelType',
    'dot polynomial neural radial anova', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 89,        'IN',                   'TheKey', 'TheInputConcept',    NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 89, 'HAS_NULLS',          'TheTargetAttribute', NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 89, 'HAS_VALUES',         'TheTargetAttribute', NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 89, 'NOT_NULL',      'ThePredictingAttributes', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 89, 'NOT_NULL', 'TheOutputAttribute',      NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 89, 'NOT_NULL', 'ThePredictingAttributes', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 89, 'VL_FROM',  'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (90, 'GenericFeatureConstruction', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 90, 1,    1,           'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 90, 1,    1,        'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 90, 1,    1,                'SQL_String',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 90, 1,    1,        'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 90,         'IN', 'TheTargetAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 90,         'IN', 'TheOutputAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 90,  'SAME_TYPE', 'TheOutputAttribute',  'TheTargetAttribute',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 90, 'IS_LOOPED',  'TheTargetAttribute',  NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 90, 'IS_LOOPED',  'SQL_String',          NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 90, 'IS_LOOPED',  'TheOutputAttribute',  NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 90,      'TYPE',  'SQL_String',          'NOMINAL',             NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 90, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (91, 'UnionByKey', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,	91,	2,	NULL,	'TheConcepts',		'IN',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	91,	2,	NULL,	'TheKeys',		'IN',	'BA',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	91,	0,	NULL,	'MapInput',		'IN',	'FEA',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	91,	0,	NULL,	'MapOutput',		'OUT',	'FEA',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	91,	1,	1,	'TheOutputConcept',	'OUT',	'CON',	NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91,   'IN',       'TheKeys',    'TheConcepts',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91,   'IN',       'MapInput',   'TheConcepts',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91,'COORD', 'MapInput',   'MapOutput',        NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91,'COORD', 'TheKeys',  'TheConcepts',        NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91, 'ALL_EXCEPT',   'TheKeys',   'TheOutputConcept',	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91, 'ALL_EXCEPT',   'MapInput',  'TheOutputConcept',	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91, 'MATCHBYCON',   'TheKeys',   NULL,	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91, 'RENAME_OUT',  'MapInput',  'MapOutput',	 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 91, 'NO_COMMON',  'TheConcepts',  NULL,	 NULL, NULL);

-- no conditions
 
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 91, 'PROJ',     'TheConcepts', 'TheOutputConcept', NULL, NULL); 
-- TheConcepts are projs of output

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 91, 'MM_UNCH', 'TheConcepts', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 91, 'VL_UNCH', 'TheConcepts', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (92, 'TimeIntervalManualDiscretization', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	1,	'TheInputConcept',	'IN',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	1,	'TheTargetAttribute',	'IN',	'BA',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	NULL,	'IntervalStart',	'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	NULL,	'IntervalEnd',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	NULL,	'MapTo',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	NULL,	'StartIncExc',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	NULL,	'EndIncExc',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	1,	'DefaultValue',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	1,	'TimeFormat',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	92,	1,	1,	'TheOutputAttribute',	'OUT',	'BA',	NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'IN',     'TheTargetAttribute', 'TheInputConcept',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'IN',     'TheOutputAttribute', 'TheInputConcept',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',   'TheTargetAttribute',  'TIME',                NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',	'IntervalStart',    'TIME',                NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',	'IntervalEnd',      'TIME',                NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',	'MapTo',            'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',	'StartIncExc',      'NOMINAL',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',	'EndIncExc',        'NOMINAL',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92, 'COORD', 'IntervalStart',    'IntervalEnd',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92, 'COORD', 'IntervalEnd',      'StartIncExc',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92, 'COORD', 'StartIncExc',      'EndIncExc',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92, 'COORD', 'EndIncExc',        'MapTo',               NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',	'DefaultValue',     'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',	'TimeFormat',       'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'TYPE',   'TheOutputAttribute',  'NOMINAL',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'ONE_OF', 'StartIncExc',         'I E',                 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 92,   'ONE_OF', 'EndIncExc',           'I E',                 NULL, NULL);

-- conditions still missing

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 92, 'VL_BY_PAR', 'TheOutputAttribute', 'MapTo', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 92, 'VL_ADD', 'TheOutputAttribute', 'DefaultValue', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 92, 'MV_FROM', 'TheTargetAttribute', 'TheOutputAttribute',  NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (93, 'NumericalIntervalManualDiscretization', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	1,	'TheInputConcept',	'IN',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	1,	'TheTargetAttribute',	'IN',	'BA',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	NULL,	'IntervalStart',	'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	NULL,	'IntervalEnd',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	NULL,	'MapTo',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	NULL,	'StartIncExc',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	NULL,	'EndIncExc',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	1,	'DefaultValue',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	93,	1,	1,	'TheOutputAttribute',	'OUT',	'BA',	NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'IN',     'TheTargetAttribute', 'TheInputConcept',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'IN',     'TheOutputAttribute', 'TheInputConcept',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'ONE_OF', 'StartIncExc',         'I E',                 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'ONE_OF', 'EndIncExc',           'I E',                 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'TYPE',   'TheTargetAttribute',  'NUMERIC',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'TYPE',	'IntervalStart',    'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'TYPE',	'IntervalEnd',      'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'TYPE',	'MapTo',            'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'TYPE',	'StartIncExc',      'NOMINAL',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'TYPE',	'EndIncExc',        'NOMINAL',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93, 'COORD', 'IntervalStart',    'IntervalEnd',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93, 'COORD', 'IntervalEnd',      'StartIncExc',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93, 'COORD', 'StartIncExc',      'EndIncExc',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93, 'COORD', 'EndIncExc',        'MapTo',               NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'TYPE',	'DefaultValue',     'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 93,   'TYPE',   'TheOutputAttribute',  'NOMINAL',          NULL, NULL);

-- conditions still missing
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 93, 'VL_BY_PAR', 'TheOutputAttribute', 'MapTo', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 93, 'VL_ADD', 'TheOutputAttribute', 'DefaultValue', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 93, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);

----------------------------------------------------------------------
---------------------- M4 Operators from UEP -------------------------
----------------------------------------------------------------------

-------------------------------------------------------
-- WP16: 1.1.1
INSERT INTO operator_t VALUES (95, 'EquidistantDiscretizationGivenWidth', 'YES', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 95, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 95, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 95, 0,   1,  'StartPoint',          'IN',  'V',  NULL);   
INSERT INTO op_params_t VALUES (
  PARAM_ID, 95, 0,   1,  'EndPoint',            'IN',  'V',  NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 95, 1,   1,  'IntervalWidth',       'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 95, 1,   1,   'ClosedTo',           'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 95, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'IN',        'TheTargetAttribute', 'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'IN',        'TheOutputAttribute', 'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'TYPE',      'TheTargetAttribute', 'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'ONE_OF',    'ClosedTo',           'left right',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'TYPE',      'IntervalWidth',      'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'GT',        'IntervalWidth',      0,                 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'TYPE',      'StartPoint',         'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'TYPE',      'EndPoint',           'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'GT',        'EndPoint',           'StartPoint',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 95, 'TYPE',      'TheOutputAttribute', 'NOMINAL',      NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 95, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 95, 'OPERATOR', 
'This operator divides the range of TheTargetAttribute into intervals with given width IntWidth starting at StartPoint and ending at EndPoint. The first and the last interval cover also the out of range values. Values of TheOutputAattribute can be specified in Labels ');


-------------------------------------------------------
-- WP16: 1.1.2
INSERT INTO operator_t VALUES (96, 'EquidistantDiscretizationGivenNoOfIntervals', 'YES', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 96, 1,   1,  'TheInputConcept',    'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 96, 1,   1,  'TheTargetAttribute', 'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 96, 1,   1,  'NoOfIntervals',      'IN',   'V', NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 96, 1,   1,  'ClosedTo',           'IN',   'V', NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 96, 0, NULL, 'Labels',             'IN',   'V', NULL);    
INSERT INTO op_params_t VALUES (
  PARAM_ID, 96, 1,   1,  'TheOutputAttribute', 'OUT', 'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 96, 'IN',   'TheTargetAttribute',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 96, 'IN',   'TheOutputAttribute',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 96, 'TYPE', 'TheTargetAttribute',  'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 96,  'ONE_OF',  'ClosedTo',        'left right',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 96, 'TYPE', 'NoOfIntervals',       'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 96, 'GT', 'NoOfIntervals',         1,                 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 96, 'TYPE', 'Labels',              'NOMINAL',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 96, 'TYPE', 'TheOutputAttribute',  'NOMINAL',      NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 96, 'VL_BY_PAR', 'TheOutputAttribute', 'Labels', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 96, 'VL_BY_SYM', 'TheOutputAttribute', 'NoOfIntervals', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 96, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 96, 'OPERATOR', 
'This operator divides the range of TheTargetAttribute into given number of intervals NoOfIntervals with the same width. The first and the last interval cover also the out of range values. Values of TheOutputAattribute can be specified in Labels.');


-------------------------------------------------------
-- WP16: 1.1.3
INSERT INTO operator_t VALUES (97, 'EquifrequentDiscretizationGivenCardinality', 'YES', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 97, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 97, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 97, 1,   1,  'Cardinality', 'IN',  'V',  NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 97, 1,   1,  'CardinalityType', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 97, 1,   1,   'ClosedTo', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 97, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 97, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 97, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 97, 'TYPE', 'TheTargetAttribute', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 97,  'ONE_OF',  'ClosedTo', 'left right',
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 97, 'TYPE', 'Cardinality', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 97, 'GT', 'Cardinality', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 97, 'ONE_OF', 'CardinalityType', 'absolute relative', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 97, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 97, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 97, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);

INSERT INTO docu_t VALUES (
  DOCU_ID, 97, 'OPERATOR', 
'This operator divides the range of TheTargetAttribute into intervals with given cardinality Cardinality (number of examples with values within the interval). The first and the last interval cover also the out of range values. Values of TheOutputAattribute can be specified in Labels (this makes sense only if CardinalityType is relative.');


-------------------------------------------------------
-- WP16: 1.1.4
INSERT INTO operator_t VALUES (98, 'EquifrequentDiscretizationGivenNoOfIntervals', 'YES', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 98, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 98, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 98, 1,   1,  'NoOfIntervals', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 98, 1,   1,   'ClosedTo', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 98, 0,   NULL,   'Labels', 'IN',  'V',  NULL);    
INSERT INTO op_params_t VALUES (
  PARAM_ID, 98, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
 
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 98, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 98, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 98, 'TYPE', 'TheTargetAttribute', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 98,  'ONE_OF',  'ClosedTo', 'left right',
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 98, 'TYPE', 'NoOfIntervals', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 98, 'GT', 'NoOfIntervals', 1, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 98, 'TYPE', 'Labels', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 98, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 98, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 98, 'VL_BY_PAR', 'TheOutputAttribute', 'Labels', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 98, 'VL_BY_SYM', 'TheOutputAttribute', 'NoOfIntervals', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 98, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 98, 'OPERATOR', 
'This operator divides the range of TheTargetAttribute into given number of intervals NoOfIntervals. The intervals have the same cardinality (number of examples with values within the interval). The first and the last interval cover also the out of range values. Values of TheOutputAattribute can be specified in Labels.');


-------------------------------------------------------
-- WP16: 1.1.5
INSERT INTO operator_t VALUES (99, 'UserDefinedDiscretization', 'NO', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 99, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 99, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 99, 1,   1,   'ClosedTo', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 99, 1,   NULL,   'TheCutpoints', 'IN',  'V',  NULL);    
INSERT INTO op_params_t VALUES (
  PARAM_ID, 99, 0,   NULL,   'Labels', 'IN',  'V',  NULL);    
INSERT INTO op_params_t VALUES (
  PARAM_ID, 99, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
 
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99, 'IN',   'TheTargetAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99, 'IN',   'TheOutputAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99, 'TYPE', 'TheTargetAttribute', 'NUMERIC',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99,  'ONE_OF',  'ClosedTo', 'left right',                NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99, 'TYPE', 'TheCutpoints', 'NUMERIC',                   NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99, 'ORDERED', 'TheCutpoints', 'INC',                    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99, 'COORD', 'TheCutpoints',    'Labels',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99, 'TYPE', 'Labels', 'NOMINAL',                      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 99, 'TYPE', 'TheOutputAttribute', 'NOMINAL',          NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 99, 'VL_BY_PAR', 'TheOutputAttribute', 'Labels', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 99, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 99, 'OPERATOR', 
'This operator divides the range of TheTargetAttribute into intervals according to user given cutpoints TheCutpoints. Values of TheOutputAttribute can be specified in Labels.');


-------------------------------------------------------
-- WP16: 1.2.1
INSERT INTO operator_t VALUES (100, 'ImplicitErrorBasedDiscretization', 'YES', 'NO', 'NO', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 100, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 100, 1,   1,  'TheClassAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 100, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 100, 1,   1,   'FullMerge', 'IN',  'V',  NULL);      
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 100, 1,   1,   'ClosedTo', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 100, 0,   1,   'SampleSize', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 100, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
 
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100, 'TYPE', 'TheTargetAttribute', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100, 'IN',   'TheClassAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100, 'TYPE', 'TheClassAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100,  'ONE_OF',  'FullMerge', 'yes no',
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100,  'ONE_OF',  'ClosedTo', 'left right',
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100, 'TYPE', 'SampleSize', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100, 'GT', 'SampleSize', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 100, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 100, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 100, 'NOT_NULL', 'TheClassAttribute', 
NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 100, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);

INSERT INTO docu_t VALUES (
  DOCU_ID, 100, 'OPERATOR', 
'This operator divides the range of TheTargetAttribute into intervals by merging subsequent values with the same majority class (or classes) given in TheClassAttribute. The resulting intervals  minimize the classification error. If FullMerge is set to yes, then an interval with two or more majority classes is merged with its neighbour, if both intervals share the same majority class.');



-------------------------------------------------------
-- WP16: 2.1.1
INSERT INTO operator_t VALUES (101, 'GroupingGivenMinCardinality', 'YES', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 101, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 101, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 101, 1,   1,  'MinCardinality', 'IN',  'V',  NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 101, 1,   1,  'MinCardinalityType', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 101, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 101, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 101, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 101, 'TYPE', 'TheTargetAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 101, 'TYPE', 'MinCardinality', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 101, 'GT', 'MinCardinality', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 101, 'ONE_OF', 'MinCardinalityType', 'absolute relative', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 101, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 101, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 101, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);

INSERT INTO docu_t VALUES (
  DOCU_ID, 101, 'OPERATOR', 
'This operator groups values of TheTargetAttribute by iteratively merging in each step two groups with the lowest frequencies until all groups have the cardinality (number of examples with values within the interval) at least MinCardinality.');


-------------------------------------------------------
-- WP16: 2.1.2
INSERT INTO operator_t VALUES (102, 'GroupingGivenNoOfGroups', 'YES', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 102, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 102, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 102, 1,   1,  'NoOfGroups', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 102, 0,   NULL,   'Labels', 'IN',  'V',  NULL);       
INSERT INTO op_params_t VALUES (
  PARAM_ID, 102, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 102, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 102, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 102, 'TYPE', 'TheTargetAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 102, 'TYPE', 'NoOfGroups', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 102, 'GT', 'NoOfGroups', 1, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 102, 'TYPE', 'Labels', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 102, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 102, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 102, 'VL_BY_PAR', 'TheOutputAttribute', 'Labels', NULL, NULL);
  
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 102, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 102, 'OPERATOR', 
'This operator groups values of TheTargetAttribute by iteratively  merging in each step two groups with the lowest frequencies until the number of groups NoOfGroups is reached. Values of TheOutputAttribute can be specified in Labels.');


-------------------------------------------------------
-- WP16: 2.1.3
INSERT INTO operator_t VALUES (103, 'UserDefinedGrouping', 'NO', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 103, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 103, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 103, 1,   NULL,  'TheGroupings', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 103, 0,   NULL,   'Labels', 'IN',  'V',  NULL);       
INSERT INTO op_params_t VALUES (
  PARAM_ID, 103, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 103, 'IN',   'TheTargetAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 103, 'IN',   'TheOutputAttribute',  'TheInputConcept',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 103, 'TYPE', 'TheTargetAttribute', 'NOMINAL', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 103, 'TYPE', 'TheGroupings', 'NOMINAL', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 103, 'TYPE', 'Labels', 'NOMINAL', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 103, 'COORD', 'TheGroupings',    'Labels',    NULL, NULL);
INSERT INTO op_assert_t VALUES (
  CONSTR_ID, 103, 'TYPE', 'TheOutputAttribute', 'NOMINAL',    NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 103, 'USE_VALS', 'TheGroupings', 'TheTargetAttribute', NULL, NULL);

-- no conditions 

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 103, 'VL_BY_PAR', 'TheOutputAttribute', 'Labels', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 103, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 103, 'OPERATOR', 
'This operator creates groups of TheTargetAttribute according to specifications given by the user in TheGroupings. Values not specified for grouping retain their original values. Values of TheOutputAttribute can be specified in Labels.');


-------------------------------------------------------
-- WP16: 2.1.4
INSERT INTO operator_t VALUES (104, 'UserDefinedGroupingWithDefaultValue', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 104, 1,   1,     'TheInputConcept',  'IN', 'CON',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 104, 1,   1,  'TheTargetAttribute',  'IN',  'BA',  NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 104, 0,   1,             'Default',  'IN',   'V',  NULL);    
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 104, 1,   NULL,     'TheGroupings',  'IN',   'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 104, 0,   NULL,           'Labels',  'IN',   'V',  NULL);       
INSERT INTO op_params_t VALUES (
  PARAM_ID, 104, 1,   1,  'TheOutputAttribute', 'OUT',  'BA',  NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'IN',   'TheTargetAttribute',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'IN',   'TheOutputAttribute',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'TYPE', 'TheTargetAttribute',  'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'TYPE', 'Default',             'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'TYPE', 'TheGroupings',        'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'TYPE', 'Labels',              'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'COORD', 'TheGroupings', 'Labels',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'TYPE', 'TheOutputAttribute',  'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 104, 'USE_VALS', 'TheGroupings', 'TheTargetAttribute', NULL, NULL);

-- no conditions 

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 104, 'VL_BY_PAR', 'TheOutputAttribute', 'Labels', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 104, 'VL_ADD', 'TheOutputAttribute', 'Default', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 104, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 104, 'OPERATOR', 
'This operator creates groups of TheTargetAttribute according to specifications given by the user in TheGroupings. Values not specified for grouping are grouped into default group Default. Values of TheOutputAttribute can be specified in Labels.');


-------------------------------------------------------
-- WP16: 1.2.2
INSERT INTO operator_t VALUES (105, 'ErrorBasedDiscretizationGivenMinCardinality', 'YES', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 105, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 105, 1,   1,  'TheClassAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 105, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 105, 1,   1,  'MinCardinality', 'IN',  'V',  NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 105, 1,   1,  'MinCardinalityType', 'IN',  'V',  NULL);        
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 105, 1,   1,   'ClosedTo', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 105, 0,   1,   'SampleSize', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 105, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
 
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'TYPE', 'TheTargetAttribute', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'IN',   'TheClassAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'TYPE', 'TheClassAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105,  'ONE_OF',  'ClosedTo', 'left right',
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'TYPE', 'MinCardinality', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'GT', 'MinCardinality', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'ONE_OF', 'MinCardinalityType', 'absolute relative', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'TYPE', 'SampleSize', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'GT', 'SampleSize', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 105, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

-- If CardinalityType is 'relative', then Cardinality < 0.5

INSERT INTO op_cond_t VALUES (
  COND_ID, 105, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 105, 'NOT_NULL', 'TheClassAttribute', 
NULL, NULL, NULL);
-- If CardinalityType is 'absolute', then Cardinality < TheTargetAttribute.allNumber/2

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 105, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 105, 'OPERATOR', 
'This operator divides the range of TheTargetAttribute into intervals with cardinality greater or equal to MinCardinality. The numeric attribute is divided into intervals with respect to TheClassAttribute, but unlike the implicit discretization, intervals with single majority class are further merged if they do not have the required cardinality. This will increase the classification error.');


-------------------------------------------------------
-- WP16: 1.2.3
INSERT INTO operator_t VALUES (106, 'ErrorBasedDiscretizationGivenNoOfIntervals', 'YES', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 106, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 106, 1,   1,  'TheClassAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 106, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 106, 1,   1,  'NoOfIntervals', 'IN',  'V',  NULL);       
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 106, 1,   1,   'ClosedTo', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 106, 0,   1,   'SampleSize', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 106, 0,   NULL,   'Labels', 'IN',  'V',  NULL);      
INSERT INTO op_params_t VALUES (
  PARAM_ID, 106, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
 
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'TYPE', 'TheTargetAttribute', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'IN',   'TheClassAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'TYPE', 'TheClassAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106,  'ONE_OF',  'ClosedTo', 'left right',
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'TYPE', 'NoOfIntervals', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'GT', 'NoOfIntervals', 1, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'TYPE', 'SampleSize', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'GT', 'SampleSize', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'TYPE', 'Labels', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 106, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 106, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 106, 'NOT_NULL', 'TheClassAttribute', 
NULL, NULL, NULL);
-- INSERT INTO op_cond_t VALUES (2369, 106, 'LT', 'NoOfIntervals', TheTargetAttribute.unique, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 106, 'VL_BY_PAR', 'TheOutputAttribute', 'Labels', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 106, 'VL_BY_SYM', 'TheOutputAttribute', 'NoOfIntervals', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 106, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 106, 'OPERATOR', 
'This operator divides the range of TheTargetAttribute into at most NoOfIntervals intervals. The numeric attribute is divided into intervals with respect to TheClassAttribute, but unlike the implicit discretization, if the number of interval exceeds NoOfIntervals, intervals are further merged. This will increase the classification error. Values of TheOutputAttribute can be specified in Labels.');


-------------------------------------------------------
-- WP16: 2.2.1
INSERT INTO operator_t VALUES (107, 'ImplicitErrorBasedGrouping', 'YES', 'NO', 'NO', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 107, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 107, 1,   1,  'TheClassAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 107, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 107, 1,   1,   'FullMerge', 'IN',  'V',  NULL);      
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 107, 0,   1,   'SampleSize', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 107, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
 
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107, 'TYPE', 'TheTargetAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107, 'IN',   'TheClassAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107, 'TYPE', 'TheClassAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107,  'ONE_OF',  'FullMerge', 'yes no',
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107, 'TYPE', 'SampleSize', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107, 'GT', 'SampleSize', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 107, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 107, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 107, 'NOT_NULL', 'TheClassAttribute', 
NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 107, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 107, 'OPERATOR', 
'This operator merges the values of TheTargetAttribute into groups with the same majority class (or classes) given in TheClassAttribute. If FullMerge is set to yes, then a group with two or more majority classes is merged with a group that have the same majority class. The resulting grouping  minimize the classification error.');


-------------------------------------------------------
-- WP16: 2.2.2
INSERT INTO operator_t VALUES (108, 'ErrorBasedGroupingGivenMinCardinality', 'YES', 'NO', 'NO', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 108, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 108, 1,   1,  'TheClassAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 108, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 108, 1,   1,  'MinCardinality', 'IN',  'V',  NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 108, 1,   1,  'MinCardinalityType', 'IN',  'V',  NULL);        
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 108, 0,   1,   'SampleSize', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 108, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
 
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'TYPE', 'TheTargetAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'IN',   'TheClassAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'TYPE', 'TheClassAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'TYPE', 'MinCardinality', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'GT', 'MinCardinality', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'ONE_OF', 'MinCardinalityType', 'absolute relative', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'TYPE', 'SampleSize', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'GT', 'SampleSize', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 108, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);
-- If CardinalityType is 'relative', then Cardinality < 0.5

INSERT INTO op_cond_t VALUES (
  COND_ID, 108, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 108, 'NOT_NULL', 'TheClassAttribute', 
NULL, NULL, NULL);
-- If CardinalityType is 'absolute', then Cardinality < TheTargetAttribute.allNumber/2

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 108, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 108, 'OPERATOR', 
'This operator merges the values of TheTargetAttribute into groups with the cardinality above given threshold MinCardinality. The grouping is performed with respect to TheClassAttribute, but unlike implicit grouping, groups with single majority class are further merged if they do not have the required cardinality. This will increase the classification error.');


-------------------------------------------------------
-- WP16: 2.2.3
INSERT INTO operator_t VALUES (109, 'ErrorBasedGroupingGivenNoOfGroups', 'YES', 'NO', 'NO', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 109, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 109, 1,   1,  'TheClassAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 109, 1,   1,  'TheTargetAttribute',  'IN',  'BA', NULL);  
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 109, 1,   1,  'NoOfGroups', 'IN',  'V',  NULL);       
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 109, 0,   1,   'SampleSize', 'IN',  'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 109, 0,   NULL,   'Labels', 'IN',  'V',  NULL);      
INSERT INTO op_params_t VALUES (
  PARAM_ID, 109, 1,   1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
 
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'IN',   'TheTargetAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'IN',   'TheOutputAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'TYPE', 'TheTargetAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'IN',   'TheClassAttribute',  'TheInputConcept',    
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'TYPE', 'TheClassAttribute', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'TYPE', 'NoOfGroups', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'GT', 'NoOfGroups', 1, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'TYPE', 'SampleSize', 'NUMERIC', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'GT', 'SampleSize', 0, 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'TYPE', 'Labels', 'NOMINAL', 
NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 109, 'TYPE', 'TheOutputAttribute', 'NOMINAL', 
NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 109, 'NOT_NULL', 'TheTargetAttribute', 
NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 109, 'NOT_NULL', 'TheClassAttribute', 
NULL, NULL, NULL);
-- INSERT INTO op_cond_t VALUES (2717, 109, 'LT', 'NoOfGroups', TheTargetAttribute.unique, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 109, 'VL_BY_PAR', 'TheOutputAttribute', 'Labels', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 109, 'VL_BY_SYM', 'TheOutputAttribute', 'NoOfGroups', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 109, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 109, 'OPERATOR', 
'This operator merges the values of TheTargetAttribute into at most  NoOfGropus groups. The grouping is performed with respect to TheClassAttribute, but unlike the implicit discretization, if the number of groups exceeds NoOfGroups, groups are further merged. Values of TheOutputAttribute can be specified in Labels.');



---------------------- M4 Operators from UEP--------------------------
----------------------------------------------------------------------

-------------------------------------------------------
-- WP14: 1.1
INSERT INTO operator_t VALUES (110, 'SimpleForwardFeatureSelectionGivenNoOfAttributes', 'NO', 'NO', 'YES', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 110, 1,   1,    'TheInputConcept',    'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 110, 1,   1,    'NoOfAttributes',     'IN',   'V', NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 110, 0,   1,    'SampleSize',         'IN',   'V', NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 110, 1,   NULL, 'TheAttributes',      'IN',  'BA', NULL);    
INSERT INTO op_params_t VALUES (
  PARAM_ID, 110, 1,   1,    'TheClassAttribute',  'IN',  'BA', NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 110, 1,   1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'IN',   'TheClassAttribute', 'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'TYPE', 'TheClassAttribute', 'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'IN',   'TheAttributes',     'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'TYPE', 'TheAttributes',     'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'TYPE', 'NoOfAttributes',    'NUMERIC',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'GT',   'NoOfAttributes',    0,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'TYPE', 'SampleSize',       'NUMERIC',           NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'GT',   'SampleSize',        0,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 110, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- INSERT INTO op_cond_t VALUES (2762, 110, 'LT', 'NoOfAttributes', TheInputConcept.NoOfCollumns, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 110, 'NOT_NULL', 'TheAttributes',     NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 110, 'NOT_NULL', 'TheClassAttribute', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 110, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 110, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);

INSERT INTO docu_t VALUES (
  DOCU_ID, 110, 'OPERATOR', 
'This operator adds one feature a time starting from empty set until the required number of features NoOfAttributes is reached. The attributes are selected with respect to TheClassAttribute, the group optimises the information dependence criterion. Use this operator if only a small number of original attributes is to be selected. The selection is done from the set of TheAttributes, attributes not specified in this set are selected automatically.');


-------------------------------------------------------
-- WP14: 1.2
INSERT INTO operator_t VALUES (111, 'SimpleBackwardFeatureSelectionGivenNoOfAttributes', 'NO', 'NO', 'NO', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 111,    1,      1,    'TheInputConcept',   'IN', 'CON',  NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 111, 1,   1,          'NoOfAttributes',    'IN',   'V',  NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 111, 0,   1,          'SampleSize',        'IN',   'V',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 111, 1,   NULL,       'TheAttributes',     'IN',  'BA',  NULL);    
INSERT INTO op_params_t VALUES (
  PARAM_ID, 111, 1,   1,          'TheClassAttribute', 'IN',  'BA',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 111, 1,   1,          'TheOutputConcept',  'OUT', 'CON', NULL);
  
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'IN',   'TheClassAttribute',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'TYPE', 'TheClassAttribute',  'NOMINAL',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'IN',   'TheAttributes',      'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'TYPE', 'TheAttributes',      'NOMINAL',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'TYPE', 'NoOfAttributes',     'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'GT',   'NoOfAttributes',     0,                 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'TYPE', 'SampleSize',         'NUMERIC',         NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'GT',   'SampleSize',         0,                 NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 111, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- INSERT INTO op_cond_t VALUES (2812, 111, 'LT', 'NoOfIntervals', TheInputConcept.NoOfCollumns, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 111, 'NOT_NULL', 'TheAttributes',     NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 111, 'NOT_NULL', 'TheClassAttribute', NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 111, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL);
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 111, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 111, 'OPERATOR', 
'This operator removes one feature a time starting from all attributes until the required number of features NoOfAttributes is reached. The attributes are selected with respect to TheClassAttribute, the group optimises the information dependence criterion. Use this operator if  a large number of original attributes is to be selected. The selection is done from the set of TheAttributes, attributes not specified in this set are selected automatically.');


-------------------------------------------------------
-- WP14: 1.3
INSERT INTO operator_t VALUES (112, 'FloatingForwardFeatureSelectionGivenNoOfAttributes', 'NO', 'NO', 'NO', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 112, 1,   1,     'TheInputConcept',   'IN',  'CON', NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 112, 1,   1,     'NoOfAttributes',    'IN',    'V', NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 112, 0,   1,     'SampleSize',        'IN',    'V', NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 112, 1,   NULL,  'TheAttributes',     'IN',  'BA', NULL);    
INSERT INTO op_params_t VALUES (
  PARAM_ID, 112, 1,   1,     'TheClassAttribute', 'IN',  'BA', NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 112, 1,   1,     'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'IN',   'TheClassAttribute',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'TYPE', 'TheClassAttribute',  'NOMINAL', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'IN',   'TheAttributes',      'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'TYPE', 'TheAttributes',      'NOMINAL', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'TYPE', 'NoOfAttributes',     'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'GT',   'NoOfAttributes',             0, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'TYPE', 'SampleSize',         'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'GT', 'SampleSize',                   0, NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 112, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- INSERT INTO op_cond_t VALUES (2862, 112, 'LT', 'NoOfIntervals', TheInputConcept.NoOfCollumns, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 112, 'NOT_NULL', 'TheAttributes', 
NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 112, 'NOT_NULL', 'TheClassAttribute', 
NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 112, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 112, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 112, 'OPERATOR', 
'This operator adds one feature a time starting from empty set until the required number of features NoOfAttributes is reached. The attributes are selected with respect to TheClassAttribute, the group optimises the information dependence criterion. Unlike the simple operator, after adding a feature a check is performed if another feature should be removed. Use this operator if only a small number of original attributes is to be selected. The selection is done from the set of TheAttributes, attributes not specified in this set are selected automatically.');


-------------------------------------------------------
-- WP14: 1.4
INSERT INTO operator_t VALUES (113, 'FloatingBackwardFeatureSelectionGivenNoOfAttributes', 'NO', 'NO', 'NO', 
NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 113, 1,   1,    'TheInputConcept',   'IN', 'CON',  NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 113, 1,   1,    'NoOfAttributes',    'IN',  'V',   NULL);   
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 113, 0,   1,    'SampleSize',        'IN',  'V',   NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 113, 1,   NULL, 'TheAttributes',     'IN', 'BA',  NULL);    
INSERT INTO op_params_t VALUES (
  PARAM_ID, 113, 1,   1,    'TheClassAttribute', 'IN', 'BA',  NULL);  
INSERT INTO op_params_t VALUES (
  PARAM_ID, 113, 1,   1,    'TheOutputConcept',  'OUT', 'CON', NULL);
  
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'IN',   'TheClassAttribute',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'TYPE', 'TheClassAttribute',  'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'IN',   'TheAttributes',      'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'TYPE', 'TheAttributes',      'NOMINAL',       NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'TYPE', 'NoOfAttributes',     'NUMERIC',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'GT', 'NoOfAttributes',       0,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'TYPE', 'SampleSize',         'NUMERIC',          NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'GT', 'SampleSize',           0,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 113, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- INSERT INTO op_cond_t VALUES (2912, 113, 'LT', 'NoOfAttributes', TheInputConcept.NoOfCollumns, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 113, 'NOT_NULL', 'TheAttributes', 
NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 113, 'NOT_NULL', 'TheClassAttribute', 
NULL, NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 113, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 113, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 113, 'OPERATOR', 
'This operator removes one feature a time starting from all attributes until the required number of features NoOfAttributes is reached. The attributes are selected with respect to TheClassAttribute, the group optimises the information dependence criterion. Unlike the simple operator, after removing a feature a check is performed if another feature should be added. Use this operator if  a large number of original attributes is to be selected. The selection is done from the set of TheAttributes, attributes not specified in this set are selected automatically.');

-------------------------------------------------------
-- WP14: 1.5
INSERT INTO operator_t VALUES (114, 'UserDefinedFeatureSelection', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 114,    1,      1,    'TheInputConcept',        'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 114,    1,      1,    'TheOutputConcept',      'OUT', 'CON', NULL);
INSERT INTO op_params_t VALUES (  
  PARAM_ID, 114,    1,   NULL,    'TheSelectedAttributes', 'OUT',  'BA', NULL);   
  
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 114, 'IN',   'TheOutputConcept',       'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 114, 'IN',   'TheSelectedAttributes',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 114, 'IN',   'TheSelectedAttributes',  'TheOutputConcept', NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 114, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 114, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
INSERT INTO docu_t VALUES (
  DOCU_ID, 114, 'OPERATOR', 
'This operator selects the attributes TheSelectedAttributes given by the user.');

-------------------------------------------------------
INSERT INTO operator_t VALUES (115, 'FeatureConstructionWithTFIDF', 'NO', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 115, 1,    1,	    'TheInputConcept',        'IN',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 115, 1,    1,           'TheTimeStamp',           'OUT', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 115, 1,    1,           'TheKey',                 'OUT', 'BA',  NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 115, 1,    1,           'TheOutputConcept',       'OUT', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 115, 1,    NULL,        'TheSelectedAttributes',  'OUT', 'BA',  NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 115,        'IN',      'TheTimeStamp',          'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 115,        'IN',      'TheKey',                'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 115,        'IN',      'TheSelectedAttributes', 'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 115,        'IN',      'TheTimeStamp',          'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 115,        'IN',      'TheKey',                'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 115,        'IN',      'TheSelectedAttributes', 'TheOutputConcept', NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 115, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

--------------------------------------------------------------------------------------------------------------
INSERT INTO operator_t VALUES (116, 'EvaluateAdvantageOfTFIDFTransformation', 'NO', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 116, 1,    1,          'TheInputConcept',        'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 116, 1,    1,          'TheTimeStamp',           'IN', 'BA',  NULL); 
INSERT INTO op_params_t VALUES (
  PARAM_ID, 116, 1,    1,          'TheKey',                 'IN', 'BA',  NULL); 
INSERT INTO op_params_t VALUES (
  PARAM_ID, 116, 1,    NULL,       'TheSelectedAttributes',  'IN', 'BA',  NULL); 

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 116,        'IN',     'TheTimeStamp',          'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 116,        'IN',     'TheKey',                'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 116,        'IN',     'TheSelectedAttributes', 'TheInputConcept', NULL, NULL);

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

INSERT INTO operator_t VALUES (117, 'Union', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,	117,	1,	1,	'TheInputConcept',	'IN',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	117,	1,	NULL,	'FurtherConcepts',	'IN',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	117,	1,	1,	'DataMode',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	117,	1,	1,	'TheOutputConcept',	'OUT',	'CON',	NULL);


INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 117, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 117, 'SAME_FEAT', 'FurtherConcepts',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 117,    'ONE_OF', 'DataMode',         'set multi-set',    NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 117, 'SUBSET', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 
-- input is subset of output
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 117, 'SUBSET', 'FurtherConcepts', 'TheOutputConcept', NULL, NULL); 
-- furtherCons are subsets of output

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 117, 'SZ_ADD', 'TheInputConcept', 'FurtherConcepts', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 117, 'MM_COMB', 'TheInputConcept, FurtherConcepts', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 117, 'VL_COMB', 'TheInputConcept, FurtherConcepts', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 117, 'MV_ADD', 'TheInputConcept, FurtherConcepts', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 117, 'VF_ADD', 'TheInputConcept, FurtherConcepts', 'TheOutputConcept', NULL, NULL);
  
--------------------------------------------------------------------------------------------------------------

INSERT INTO operator_t VALUES (118, 'Materialize', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,	118,	1,	1,	'TheInputConcept',	'IN',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	118,	0,	1,	'TableName',		'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	118,	1,	1,	'TheOutputConcept',	'OUT',	'CON',	NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 118, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 118, 'SUBSET', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 
-- input concept is subset of output concept 
-- (output is also subset of input but we want only one direction)  

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 118, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
--------------------------------------------------------------------------------------------------------------

INSERT INTO operator_t VALUES (119, 'DateToNumeric', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 119, 1,    1,           'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 119, 1,    1,        'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 119, 1,    1,                'OutputFormat',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 119, 1,    1,        'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 119,         'IN', 'TheTargetAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 119,         'IN', 'TheOutputAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 119,      'TYPE', 'TheOutputAttribute',   'TIME',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 119, 'IS_LOOPED',  'TheTargetAttribute',  NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 119, 'IS_LOOPED',  'OutputFormat',        NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 119, 'IS_LOOPED',  'TheOutputAttribute',  NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 119,    'ONE_OF',  'OutputFormat',
    'Year_YYYY Year_YY Month_of_Year Day_of_Month Hour_of_Day Minute_of_Hour Second_of_Minute',
  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 119, 'MV_FROM',   'TheTargetAttribute', 'TheOutputAttribute', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (120, 'YaleModelApplier', 'YES', 'NO', 'NO', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 120, 1,    1,             'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 120, 1, NULL,                  'PrimaryKey',  'IN', 'FEA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 120, 1, NULL,        'PredictingAttributes',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 120, 1,    1,                   'ModelFile',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 120, 1,    1,          'PredictedAttribute', 'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 120, 1,    1,            'TheOutputConcept', 'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120,         'IN', 'PrimaryKey',            'TheInputConcept',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120,         'IN', 'PredictingAttributes',  'TheInputConcept',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120,         'IN', 'PrimaryKey',            'TheOutputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120,         'IN', 'PredictingAttributes',  'TheOutputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120,         'IN', 'PredictedAttribute',    'TheOutputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120,      'TYPE', 'PredictedAttribute',     'NUMERIC',              NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120,      'TYPE', 'ModelFile',              'NOMINAL',              NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120, 'IS_LOOPED', 'ModelFile',               NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 120, 'IS_LOOPED', 'PredictedAttribute',      NULL,                  NULL, NULL);

-- no conditions
-- no assertions
-------------------------------------------------------

INSERT INTO operator_t VALUES (121, 'CreatePrimaryKey', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,	121,	1,	1,	'TheInputConcept',	'IN',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	121,	1,	1,	'AllowDuplicates',	'IN',	'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	121,	1,	1,	'PrimaryKey',		'OUT',	'BA',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	121,	1,	1,	'TheOutputConcept',	'OUT',	'CON',	NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 121, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 121, 'IN',        'PrimaryKey',       'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 121, 'TYPE',      'PrimaryKey',       'NOMINAL',        NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 121, 'ONE_OF',    'AllowDuplicates',  'true false',       NULL, NULL);
-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 121, 'PROJ', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 
-- input is proj of output

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 121, 'NOT_NULL',    'PrimaryKey', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 121, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);

-------------------------------------------------------
INSERT INTO operator_t VALUES (122, 'Repeat', 'NO', 'YES','YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   122,    1,      1,     'TheInputConcept',   'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   122,    1,      1,            'HowOften',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   122,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 122, 'SAME_FEAT',  'TheOutputConcept',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 122,        'GE',  'HowOften',                          1,  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 122, 'SUBSET', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 
-- input concept is subset of output concept 
-- (output is also subset of input but we want only one direction)  

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 122, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);

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

INSERT INTO operator_t VALUES (123, 'Pivotize', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 123, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 123, 1, NULL,       'TheIndexAttributes',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 123, 1,    1,        'ThePivotAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 123, 0, NULL,     'TheGroupByAttributes',  'IN', 'FEA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 123, 1,    1,         'TheOutputConcept', 'OUT', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 123, 1, NULL,              'IndexValues',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 123, 1,    1,      'AggregationOperator',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 123, 0,    1,               'NullOrZero',  'IN',   'V', NULL);


INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'IN',   'TheIndexAttributes',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'IN',    'ThePivotAttribute',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'IN', 'TheGroupByAttributes',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'IN', 'TheGroupByAttributes', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'CREATE_BY', 'ThePivotAttribute', 'IndexValues', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'OUT_TYPE',  'ThePivotAttribute', 'NUMERIC', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'ONE_OF','AggregationOperator', 'NONE SUM AVG MIN MAX COUNT', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'ONE_OF','NullOrZero', 'Null Zero', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'COORD', 'IndexValues', 'TheIndexAttributes', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 123, 'USE_VALS', 'IndexValues', 'TheIndexAttributes', NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 123, 'REL_N_1', 'TheInputConcept',    'TheOutputConcept',   NULL, NULL);
-- an n:1 relationship from input to output exists (if there are any group-by attributes)
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 123, 'REL_N_K', 'TheGroupByAttributes', NULL, NULL, NULL);
-- the keys on the "many-side" are given by the GroupBy attributes 
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 123, 'REL_1_K',  'TheGroupByAttributes', NULL, NULL, NULL);
-- the keys on the "one-side" are given by the GroupBy attributes

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 123, 'SZ_BY_VL', 'TheGroupByAttributes', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 123, 'VF_BY_AGG','TheGroupByAttributes', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 123, 'VL_FROM', 'ThePivotAttribute', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 123, 'MM_FROM', 'ThePivotAttribute', NULL, NULL, NULL);
  
-------------------------------------------------------

INSERT INTO operator_t VALUES (124, 'PrepareForYale', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
 PARAM_ID, 124, 1,    1,    'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
 PARAM_ID, 124, 0,    1,    'QueryFilePrefix',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
 PARAM_ID, 124, 1,    1, 'ExperimentFileName',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
 PARAM_ID, 124, 0,    1,           'TheLabel',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
 PARAM_ID, 124, 0,    1,      'ThePrimaryKey',  'IN',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 124, 'IN',      'TheLabel', 'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 124, 'IN', 'ThePrimaryKey', 'TheInputConcept', NULL, NULL);

-- no conditions
-- no assertions

-------------------------------------------------------
INSERT INTO operator_t VALUES (125, 'RemoveDuplicates', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,   125,    1,      1,    'TheInputConcept',    'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,   125,    1,      1,    'TheOutputConcept',  'OUT', 'CON', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 125, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 125, 'SUBSET', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is subset of input

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

INSERT INTO operator_t VALUES (126, 'Binarify', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 126, 1,    1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 126, 1,    1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 126, 1,    1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 126, 1,    1,         'TargetValue',  'IN',   'V', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 126, 'IS_LOOPED',   'TargetValue',               NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 126, 'IS_LOOPED',   'TheOutputAttribute',        NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 126,        'IN',   'TheTargetAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 126,        'IN',   'TheOutputAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 126,      'TYPE',   'TheOutputAttribute',  'BINARY',              NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 126,  'USE_VALS',   'TargetValue', 'TheTargetAttribute', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 126,  'CR_SUFFIX', 'TheTargetAttribute',  'Flag',           NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 126, 'GE',       'TheOutputAttribute', '0', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 126, 'LE',       'TheOutputAttribute', '1', NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 126, 'NOT_NULL', 'TheOutputAttribute', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 126, 'MIN_FROM', 'TheOutputAttribute', '0', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 126, 'MAX_FROM', 'TheOutputAttribute', '1', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 126, 'VL_BY_LIST', 'TheOutputAttribute', '0 1', NULL, NULL);
  
-------------------------------------------------------

INSERT INTO operator_t VALUES (127, 'ReversePivotize', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 127, 1,    1,          'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 127, 1, NULL,    'ThePivotizedAttributes', 'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 127, 0, 1,              'TheKeyAttribute', 'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 127, 1,    1,         'TheOutputConcept', 'OUT', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 127, 1, NULL,              'IndexValues',  'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 127, 1, 1,        'OutputPivotAttribute', 'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 127, 1, NULL,    'OutputIndexAttributes', 'OUT',  'BA', NULL);


INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'IN',   'ThePivotizedAttributes',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'IN',          'TheKeyAttribute',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'IN',          'TheKeyAttribute', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'IN',     'OutputPivotAttribute', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'IN',    'OutputIndexAttributes', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'ALL_EXCEPT', 'ThePivotizedAttributes', 'TheOutputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'COORD',      'IndexValues', 'ThePivotizedAttributes', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'SAME_TYPE', 'OutputPivotAttribute', 'ThePivotizedAttributes', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'TYPE',     'OutputIndexAttributes', 'NOMINAL', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 127, 'TYPE',     'IndexValues', 'NOMINAL', NULL, NULL);
  

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 127, 'REL_N_1', 'TheOutputConcept',    'TheInputConcept',   NULL, NULL);
-- an n:1 relationship from output to input exists (if there is a key attribute)
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 127, 'REL_N_K', 'TheKeyAttribute', NULL, NULL, NULL);
-- the key on the "many-side" is given by the Key attribute 
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 127, 'REL_1_K',  'TheKeyAttribute', NULL, NULL, NULL);
-- the key on the "one-side" is given by the Key attribute

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 127, 'MM_COMB', 'ThePivotizedAttributes', 'OutputPivotAttribute', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 127, 'VL_COMB', 'ThePivotizedAttributes', 'OutputPivotAttribute', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 127, 'VL_BY_LIST', 'OutputIndexAttributes', 'IndexValues', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 127, 'SZ_MULT_NO', 'ThePivotizedAttributes', NULL, NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 127, 'VF_MULT_NO', 'TheKeyAttribute', 'ThePivotizedAttributes', NULL, NULL);
  
-------------------------------------------------------

INSERT INTO operator_t VALUES (128, 'MergeAttributes', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 128, 1,    1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 128, 1,    1,  'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 128, 1,    1,    'AttributeToMerge',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 128, 1,    1,  'TheOutputAttribute', 'OUT',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 128, 1,    1,     'ClashResolvation', 'IN',   'V', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 128,        'IN',   'TheTargetAttribute',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 128,        'IN',     'AttributeToMerge',  'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 128,        'IN',   'TheOutputAttribute',  'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 128,      'TYPE',   'TheOutputAttribute',  'NOMINAL',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 128,      'TYPE',   'TheTargetAttribute',  'NOMINAL',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 128,      'TYPE',     'AttributeToMerge',  'NOMINAL',      NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 128,    'ONE_OF',     'ClashResolvation', 'Priority ValueCombination',  NULL, NULL);

-- no conditions
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 128, 'MM_COMB', 'TheTargetAttribute, AttributeToMerge', 'TheOutputAttribute', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 128, 'VL_COMB', 'TheTargetAttribute, AttributeToMerge', 'TheOutputAttribute', NULL, NULL);

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

INSERT INTO operator_t VALUES (129, 'MaterializeWithPKs', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID,	129,	1,	1,     'TheInputConcept',	'IN',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	129,	0,	1,	     'TableName',	'IN',	  'V',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	129,	1,	1,    'TheOutputConcept',      'OUT',	'CON',	NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID,	129,	1,   NULL,          'PrimaryKey',       'IN',	 'BA',	NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 129, 'SAME_FEAT', 'TheOutputConcept', 'TheInputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 129, 'IN',        'PrimaryKey',       'TheInputConcept',  NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 129, 'SUBSET', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 129, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 

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

INSERT INTO operator_t VALUES (130, 'ReverseFeatureConstruction', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 130, 1,    1,           'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 130, 1,    1,        'TheTargetAttribute',  'IN',  'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 130, 0,    1,        'OriginalOutputAttribute',   'IN',   'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 130, 1,    1,        'TheOutputAttribute', 'OUT',  'BA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 130,         'IN', 'TheTargetAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 130,         'IN', 'TheOutputAttribute',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 130,  'SAME_TYPE', 'TheOutputAttribute',  'TheTargetAttribute',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 130,  'TYPE',      'OriginalOutputAttribute',   'NOMINAL',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 130, 'IS_LOOPED',  'OriginalOutputAttribute',   NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 130, 'IS_LOOPED',  'TheTargetAttribute',  NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 130, 'IS_LOOPED',  'TheOutputAttribute',  NULL,                  NULL, NULL);

-- no operator group for this operator!

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 130, 'VL_FROM', 'OriginalOutputAttribute', 'TheOutputAttribute', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 130, 'VF_FROM', 'OriginalOutputAttribute', 'TheOutputAttribute', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 130, 'MV_FROM', 'OriginalOutputAttribute', 'TheOutputAttribute', NULL, NULL);
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 130, 'MM_FROM', 'OriginalOutputAttribute', 'TheOutputAttribute', NULL, NULL);
  
-------------------------------------------------------

INSERT INTO operator_t VALUES (131, 'CreateManyToManyRelation', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 1,    1,     'TheFromConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 1,    1,       'TheToConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 1,    1,      'TheCrossTable',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 1, NULL,     'FromConceptKeys',  'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 1, NULL,     'CrossToFromConceptKeys',  'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 1, NULL,     'ToConceptKeys',  'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 1, NULL,     'CrossToToConceptKeys',  'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 0, 1,     'NameForCrossTable',  'IN', 'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 131, 1, 1, 'TheRelation', 'OUT', 'REL', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'IN',     'FromConceptKeys',    'TheFromConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'IN',     'ToConceptKeys',    'TheToConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'IN',     'CrossToFromConceptKeys',  'TheCrossTable',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'IN',     'CrossToToConceptKeys',    'TheCrossTable',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'COORD',  'CrossToFromConceptKeys',  'FromConceptKeys', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'COORD',  'CrossToToConceptKeys',     'ToConceptKeys', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'FROMCON', 'TheRelation', 'TheFromConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'TOCON',   'TheRelation', 'TheToConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'CROSSCON',   'TheRelation', 'TheCrossTable', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'FROMKEY', 'TheRelation', 'FromConceptKeys', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'TOKEY',   'TheRelation', 'ToConceptKeys', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'CR_FROMKEY', 'TheRelation', 'CrossToFromConceptKeys', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 131, 'CR_TOKEY',   'TheRelation', 'CrossToToConceptKeys', NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 131, 'NOT_NULL', 'FromConceptKeys',  NULL, NULL, NULL);
-- INSERT INTO op_cond_t VALUES (
--  COND_ID, 131, 'UNIQUE',   'FromConceptKeys',  NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 131, 'NOT_NULL', 'ToConceptKeys',  NULL, NULL, NULL);
-- INSERT INTO op_cond_t VALUES (
--   COND_ID, 131, 'UNIQUE',   'ToConceptKeys',  NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 131, 'NOT_NULL', 'CrossToFromConceptKeys',  NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 131, 'NOT_NULL', 'CrossToToConceptKeys',  NULL, NULL, NULL);
  
-------------------------------------------------------

INSERT INTO operator_t VALUES (132, 'CreateOneToManyRelation', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 132, 1,    1,     'TheFromConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 132, 1,    1,       'TheToConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 132, 1, NULL,     'FromConceptKeys',  'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 132, 1, NULL,     'ToConceptKeys',  'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 132, 1, 1, 'TheRelation', 'OUT', 'REL', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 132, 'IN',     'FromConceptKeys',   'TheFromConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 132, 'IN',     'ToConceptKeys',       'TheToConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 132, 'COORD',  'FromConceptKeys',    'ToConceptKeys',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 132, 'FROMCON', 'TheRelation', 'TheFromConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 132, 'TOCON',   'TheRelation', 'TheToConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 132, 'FROMKEY', 'TheRelation', 'FromConceptKeys', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 132, 'TOKEY',   'TheRelation', 'ToConceptKeys', NULL, NULL);

INSERT INTO op_cond_t VALUES (
  COND_ID, 132, 'NOT_NULL', 'FromConceptKeys',  NULL, NULL, NULL);
-- INSERT INTO op_cond_t VALUES (
--   COND_ID, 132, 'UNIQUE',   'FromConceptKeys',  NULL, NULL, NULL);
INSERT INTO op_cond_t VALUES (
  COND_ID, 132, 'NOT_NULL', 'ToConceptKeys',  NULL, NULL, NULL);
-- INSERT INTO op_cond_t VALUES (
--   COND_ID, 132, 'UNIQUE',   'ToConceptKeys',  NULL, NULL, NULL);
  
-------------------------------------------------------

INSERT INTO operator_t VALUES (133, 'FeatureConstructionByRelation', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 133, 1,   1,         'TheRelation',  'IN', 'REL', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 133, 1,   1,  'TheTargetAttribute',  'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 133, 1,   1,  'AggregationOperator', 'IN', 'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 133, 1,   1,   'TheOutputAttribute', 'OUT', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 133, 1,   1,   'TheOutputConcept',   'OUT', 'CON', NULL);
  
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 133, 'IS_LOOPED',   'TheTargetAttribute',     NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 133, 'IS_LOOPED',   'TheOutputAttribute',     NULL,  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 133, 'IS_LOOPED',  'AggregationOperator',     NULL,  NULL, NULL);
  
-- the target attribute is IN the FromConcept of the input relation:
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 133, 'IN_RELFROM', 'TheTargetAttribute',  'TheRelation',  NULL, NULL);
  
-- features of the output concept are taken from the ToConcept of the input relation:
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 133, 'FEAT_RTO',   'TheRelation',   'TheOutputConcept',   NULL, NULL);
  
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 133, 'IN',   'TheOutputAttribute',  'TheOutputConcept',  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 133, 'ONE_OF', 'AggregationOperator', 'SUM COUNT VALUE_OF', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 133,   'TYPE',   'TheOutputAttribute',  'NUMERIC',     NULL, NULL);

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 133,  'PROJ_RELTO', 'TheRelation', 'TheOutputConcept', NULL, NULL); 
-- ToConcept of TheRelation is proj of output concept

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 133, 'NOT_NULL', 'TheOutputAttribute', NULL, NULL, NULL);
  
-------------------------------------------------------

INSERT INTO operator_t VALUES (134, 'AttributeDerivation', 'YES', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 134, 1,   1,     'TheInputConcept',  'IN', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 134, 1,   1,          'ClassName',  'IN', 'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 134, 1,   1, 'TypeOfOutputAttribute',  'IN', 'V', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 134, 0,   NULL,   'TheTargetAttributes', 'IN', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 134, 1,   1,   'TheOutputAttribute', 'OUT', 'BA', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 134, 1,   1,  'TheOutputConcept',   'OUT', 'CON', NULL);
  
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134, 'SAME_FEAT', 'TheOutputConcept',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134,       'IN',  'TheOutputAttribute',  'TheOutputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134,       'IN',  'TheTargetAttributes',  'TheInputConcept',     NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134, 'IS_LOOPED',  'TypeOfOutputAttribute',  NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134, 'IS_LOOPED',  'ClassName',          NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134, 'IS_LOOPED',  'TheTargetAttributes',  NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134, 'IS_LOOPED',  'TheOutputAttribute',  NULL,                  NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134,      'TYPE',  'ClassName',          'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134,      'TYPE',  'TypeOfOutputAttribute',   'NOMINAL',             NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134,      'TYPE',  'TheOutputAttribute',  'TypeOfOutputAttribute',   NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 134, 'ONE_OF',  'TypeOfOutputAttribute',  'NOMINAL NUMERIC TIME BINARY',       NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 134, 'PROJ', 'TheInputConcept', 'TheOutputConcept', NULL, NULL); 
-- input is proj of output

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 134, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
INSERT INTO operator_t VALUES (135, 'RemoveFeatures', 'NO', 'NO', 'YES', NULL);

INSERT INTO op_params_t VALUES (
  PARAM_ID, 135, 1,    1,       'TheInputConcept',     'IN',  'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 135, 1,    1,       'TheOutputConcept',    'OUT', 'CON', NULL);
INSERT INTO op_params_t VALUES (
  PARAM_ID, 135, 1, NULL,       'FeaturesToRemove',    'IN',  'FEA', NULL);

INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 135, 'IN',         'FeaturesToRemove', 'TheInputConcept', NULL, NULL);
INSERT INTO op_constr_t VALUES (
  CONSTR_ID, 135, 'ALL_EXCEPT', 'FeaturesToRemove', 'TheOutputConcept', NULL, NULL);

-- no conditions

INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 135, 'PROJ', 'TheOutputConcept', 'TheInputConcept', NULL, NULL); 
-- output is proj of input

-- assertions for estimation of statistics:
INSERT INTO op_assert_t VALUES (
  ASSERT_ID, 135, 'NO_CHANGE', 'TheInputConcept', 'TheOutputConcept', NULL, NULL);
  
-------------------------------------------------------
----                Operator Groups                ----
-------------------------------------------------------

-- Top level groups:
INSERT INTO op_group_t VALUES (10, NULL, NULL, 'Feature Construction');
INSERT INTO op_group_t VALUES (11, NULL, NULL, 'Data Reduction');
INSERT INTO op_group_t VALUES (12, NULL, NULL, 'Propositionalisation');
INSERT INTO op_group_t VALUES (13, NULL, NULL, 'Data Cleaning');
INSERT INTO op_group_t VALUES (14, NULL, NULL, 'Changing Organisation');
INSERT INTO op_group_t VALUES (15, NULL, NULL, 'Time Series Preparation');
INSERT INTO op_group_t VALUES (16, NULL, NULL, 'Pseudo-Parallelism');
INSERT INTO op_group_t VALUES (17, NULL, NULL, 'Data Mining Step');
INSERT INTO op_group_t VALUES (18, NULL, NULL, 'Creating Relations');
INSERT INTO op_group_t VALUES (19, NULL, NULL, 'Evaluation');
INSERT INTO op_group_t VALUES (20, NULL, NULL, 'Miscellaneous');

-- Second level groups:
INSERT INTO op_group_t VALUES (21, 13, NULL, 'Handle Missing Values');
INSERT INTO op_group_t VALUES (22, 10, NULL, 'Discretisation');
INSERT INTO op_group_t VALUES (23, 10, NULL, 'Grouping');
INSERT INTO op_group_t VALUES (24, 10, NULL, 'Scaling');
INSERT INTO op_group_t VALUES (25, 11, NULL, 'Feature Selection');


-- Missing value operators:
INSERT INTO op_group_t VALUES (DOCU_ID, 21, 46,  'Assign a default');
INSERT INTO op_group_t VALUES (DOCU_ID, 21, 47,  'Assign modal');
INSERT INTO op_group_t VALUES (DOCU_ID, 21, 48,  'Assign median');
INSERT INTO op_group_t VALUES (DOCU_ID, 21, 49,  'Assign average');
INSERT INTO op_group_t VALUES (DOCU_ID, 21, 50,  'Assign stochastic');
INSERT INTO op_group_t VALUES (DOCU_ID, 21, 53,  'Learn with regression SVM');
INSERT INTO op_group_t VALUES (DOCU_ID, 21, 38,  'Delete incomplete records');

-- Row selection and aggregation:
INSERT INTO op_group_t VALUES (DOCU_ID, 11, 39,  'Row Selection - Query');
INSERT INTO op_group_t VALUES (DOCU_ID, 11, 37,  'Row Selection - Random Sampling');
INSERT INTO op_group_t VALUES (DOCU_ID, 11, 125, 'Remove duplicate rows');
INSERT INTO op_group_t VALUES (DOCU_ID, 11, 77,  'SpecifiedStatistics');

-- Pseudo-parallel processing:
INSERT INTO op_group_t VALUES (DOCU_ID, 16, 40,  'Segmentation - Stratified');
INSERT INTO op_group_t VALUES (DOCU_ID, 16, 42,  'Segmentation - Partitioning');
INSERT INTO op_group_t VALUES (DOCU_ID, 16, 74,  'Undo a Segmentation');
INSERT INTO op_group_t VALUES (DOCU_ID, 16, 122, 'Clone Columnset');

-- Time Operators:
INSERT INTO op_group_t VALUES (DOCU_ID, 15, 67, 'Windowing');
INSERT INTO op_group_t VALUES (DOCU_ID, 15, 68, 'Signal To Symbol');
INSERT INTO op_group_t VALUES (DOCU_ID, 15, 70, 'Moving function');
INSERT INTO op_group_t VALUES (DOCU_ID, 15, 71, 'Weighted moving function');
INSERT INTO op_group_t VALUES (DOCU_ID, 15, 72, 'Exponential moving function');

-- Propositionalisation:
INSERT INTO op_group_t VALUES (DOCU_ID, 12, 34,  'MultiRelationalFeatureConstruction');
INSERT INTO op_group_t VALUES (DOCU_ID, 12, 117, 'Union');
INSERT INTO op_group_t VALUES (DOCU_ID, 12, 91,  'UnionByKey');
INSERT INTO op_group_t VALUES (DOCU_ID, 12, 76,  'JoinByKey');

-- Feature Selection
INSERT INTO op_group_t VALUES (DOCU_ID, 25, 43,  'FeatureSelectionByAttributes');
INSERT INTO op_group_t VALUES (DOCU_ID, 25, 135, 'RemoveFeatures');
INSERT INTO op_group_t VALUES (DOCU_ID, 25, 88,  'FeatureSelectionWithSVM');
INSERT INTO op_group_t VALUES (DOCU_ID, 25, 110, 'SimpleForwardFeatureSelectionGivenNoOfAttributes');
INSERT INTO op_group_t VALUES (DOCU_ID, 25, 111, 'SimpleBackwardFeatureSelectionGivenNoOfAttributes');
INSERT INTO op_group_t VALUES (DOCU_ID, 25, 112, 'FloatingForwardFeatureSelectionGivenNoOfAttributes');
INSERT INTO op_group_t VALUES (DOCU_ID, 25, 113, 'FloatingBackwardFeatureSelectionGivenNoOfAttributes');
INSERT INTO op_group_t VALUES (DOCU_ID, 25, 114, 'UserDefinedFeatureSelection');

-- Feature Construction
INSERT INTO op_group_t VALUES (DOCU_ID, 10, 90,  'GenericFeatureConstruction');
INSERT INTO op_group_t VALUES (DOCU_ID, 10, 119, 'DateToNumeric');
INSERT INTO op_group_t VALUES (DOCU_ID, 10, 128, 'MergeAttributes');
INSERT INTO op_group_t VALUES (DOCU_ID, 10, 133, 'FeatureConstructionByRelation');
INSERT INTO op_group_t VALUES (DOCU_ID, 10, 134, 'AttributeDerivation');
INSERT INTO op_group_t VALUES (DOCU_ID, 10, 115, 'FeatureConstructionWithTFIDF');

---- Scaling
INSERT INTO op_group_t VALUES (DOCU_ID, 24, 44,  'LinearScaling');
INSERT INTO op_group_t VALUES (DOCU_ID, 24, 45,  'LogScaling');

---- Grouping
INSERT INTO op_group_t VALUES (DOCU_ID, 23, 101, 'GroupingGivenMinCardinality');
INSERT INTO op_group_t VALUES (DOCU_ID, 23, 102, 'GroupingGivenNoOfGroups');
INSERT INTO op_group_t VALUES (DOCU_ID, 23, 103, 'UserDefinedGrouping');
INSERT INTO op_group_t VALUES (DOCU_ID, 23, 104, 'UserDefinedGroupingWithDefaultValue');
INSERT INTO op_group_t VALUES (DOCU_ID, 23, 108, 'ErrorBasedGroupingGivenMinCardinality');
INSERT INTO op_group_t VALUES (DOCU_ID, 23, 109, 'ErrorBasedGroupingGivenNoOfGroups');
INSERT INTO op_group_t VALUES (DOCU_ID, 23, 107, 'ImplicitErrorBasedGrouping');

---- Discretization
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 92,  'TimeIntervalManualDiscretization');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 93,  'NumericalIntervalManualDiscretization');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 95,  'EquidistantDiscretizationGivenWidth');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 96,  'EquidistantDiscretizationGivenNoOfIntervals');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 97,  'EquifrequentDiscretizationGivenCardinality');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 98,  'EquifrequentDiscretizationGivenNoOfIntervals');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 99,  'UserDefinedDiscretization');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 100, 'ImplicitErrorBasedDiscretization');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 105, 'ErrorBasedDiscretizationGivenMinCardinality');
INSERT INTO op_group_t VALUES (DOCU_ID, 22, 106, 'ErrorBasedDiscretizationGivenNoOfIntervals');

-- Misc
INSERT INTO op_group_t VALUES (DOCU_ID, 20, 118, 'Materialize');
INSERT INTO op_group_t VALUES (DOCU_ID, 20, 129, 'MaterializeWithPKs');
-- INSERT INTO op_group_t VALUES (DOCU_ID, 20, 130, 'MaterializeRelation');
INSERT INTO op_group_t VALUES (DOCU_ID, 20, 120, 'Apply a Yale model');
INSERT INTO op_group_t VALUES (DOCU_ID, 20, 121, 'Create a primary key');
INSERT INTO op_group_t VALUES (DOCU_ID, 20, 124, 'Prepare a Yale experiment');

-- Changing organisation
INSERT INTO op_group_t VALUES (DOCU_ID, 14, 123, 'Pivotize');
INSERT INTO op_group_t VALUES (DOCU_ID, 14, 127, 'ReversePivotize');
INSERT INTO op_group_t VALUES (DOCU_ID, 14, 126, 'Binarify');

-- Data Mining Step
INSERT INTO op_group_t VALUES (DOCU_ID, 17, 84,  'Apriori');
INSERT INTO op_group_t VALUES (DOCU_ID, 17, 89,  'SupportVectorMachineForClassification');
INSERT INTO op_group_t VALUES (DOCU_ID, 17, 63,  'SupportVectorMachineForRegression');

-- Evaluation
INSERT INTO op_group_t VALUES (DOCU_ID, 19, 73,  'ComputeSVMError');
INSERT INTO op_group_t VALUES (DOCU_ID, 19, 116, 'EvaluateAdvantageOfTFIDFTransformation');

-- Relations
INSERT INTO op_group_t VALUES (DOCU_ID, 18, 131, 'CreateManyToManyRelation');
INSERT INTO op_group_t VALUES (DOCU_ID, 18, 132, 'CreateOneToManyRelation');

-- no operator group for op 130 'ReverseFeatureConstruction'!

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