|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--dke.smwp.db.DB_Table | +--dke.smwp.db.DB_Parameter
database handling for creating, initializing and deleting parameter relations.
used by following parameters:
Field Summary | |
private ConnectionPool |
_connectionPool
connection object handle |
Constructor Summary | |
DB_Parameter()
default constructor |
Method Summary | |
void |
createTable(java.lang.String table_name,
java.util.ArrayList columns,
java.util.ArrayList primaryKeys,
java.util.ArrayList foreignKeys)
create relation for ValueParameter (RV<>), or PredicateParameter (RP<>), or Fragmenation Relation (FR<>) |
void |
initializeDerived(FragmentationRelation fr,
FragmentationRelation fragBase_fr,
FragmentationRelation derivBase_fr)
initializes Fragmentation Relation fragBase_fr of Fragment Base Class and Fragmentation Relation
derivBase_fr of Derivation Base Class |
void |
initializePrimary(FragmentationRelation fr,
FragmentationRelation fr_base,
PredicateParameter param,
java.lang.String fragmentPredicate_pf)
initializes primary Fragmentation Relation fr which is based
upon base Fragmentation Relation fr_base and Predicate Parameter
param ;
the fragment selection predicate fragmentParameter_pf is
used as filter for fr ; |
void |
initializePrimary(FragmentationRelation fr,
FragmentationRelation fr_base,
ValueParameter param,
java.lang.String fragmentPredicate_pf)
initialize Fragmentation Relation fr (of Primary Fragment Class)
which is based upon base Fragmentation Relation fr_base and
Value Parameter param ;
the cartesian product from the relations fr_base and
is inserted into fr ;
the fragment selection predicate fragmentParameter_pf is
used as filter for fr ; |
void |
initializeTable(java.lang.String fc_table_name,
java.lang.String param_name,
java.lang.String rr_table_name,
java.lang.String rr_attr_name)
initialize ValueParameter relation (RV<>) (the value parameter relation contains exactly ONE column) |
void |
insertPredicateParameter(java.lang.String targetRelation,
java.lang.String labelValue,
java.lang.String predicateValue)
inserts initial data into the Predicate Parameter relation; |
Methods inherited from class dke.smwp.db.DB_Table |
columnExists, dropTable, getColumn, getColumns, getColumns, getForeignKeys, getPrimaryKeys, stingReplace, tableExists |
Methods inherited from class java.lang.Object |
|
Field Detail |
private ConnectionPool _connectionPool
Constructor Detail |
public DB_Parameter()
Method Detail |
public void createTable(java.lang.String table_name, java.util.ArrayList columns, java.util.ArrayList primaryKeys, java.util.ArrayList foreignKeys) throws java.sql.SQLException
table_name
- name of the table which is to be createdcolumns
- collection containing Column
objectsprimaryKeys
- collection containing column names which are primary keyforeignKeys
- collection containing ForeignKeyConstraint objectsjava.sql.SQLException
- fails to create tablepublic void initializeTable(java.lang.String fc_table_name, java.lang.String param_name, java.lang.String rr_table_name, java.lang.String rr_attr_name) throws java.sql.SQLException
fc_table_name
- source table from where data is fetchedparam_name
- column name from source tablerr_table_name
- target table in which data is insertedrr_attr_name
- column name from target tablejava.sql.SQLException
- failed to fetch meta-data; sql insert statement statement failedpublic void initializeDerived(FragmentationRelation fr, FragmentationRelation fragBase_fr, FragmentationRelation derivBase_fr) throws java.sql.SQLException
fragBase_fr
of Fragment Base Class and Fragmentation Relation
derivBase_fr
of Derivation Base Classfr
- target Fragmentation Relation
(which is to be initialized)fragBase_fr
- Fragmentation Relation from Fragmentation Base Class
(source relation)derivBase_fr
- Fragmentation Relation from Derivation Base Class
(source relation)java.sql.SQLException
- inserting initial data failedpublic void initializePrimary(FragmentationRelation fr, FragmentationRelation fr_base, PredicateParameter param, java.lang.String fragmentPredicate_pf) throws java.sql.SQLException
fr
which is based
upon base Fragmentation Relation fr_base
and Predicate Parameter
param
;
the fragment selection predicate fragmentParameter_pf
is
used as filter for fr
;
fr
- target Fragmentation Relation
(which is to be initialized)fr_base
- base Fragmentation Relation (source relation)param
- parameter added to fr_base
,
which results in fr
fragmentPredicate_pf
- fragment selection predicate, which is a filter
for target fragmentation relationjava.sql.SQLException
- fetching meta-data failed,
inserting initial data failedpublic void initializePrimary(FragmentationRelation fr, FragmentationRelation fr_base, ValueParameter param, java.lang.String fragmentPredicate_pf) throws java.sql.SQLException
fr
(of Primary Fragment Class)
which is based upon base Fragmentation Relation fr_base
and
Value Parameter param
;
the cartesian product from the relations fr_base
and
is inserted into fr
;
the fragment selection predicate fragmentParameter_pf
is
used as filter for fr
;
fr
- Fragmentation Relation which is to be initializedfr_base
- base Fragmentation Relation (source relation)param
- parameterfragmentPredicate_pf
- fragment selection parameter - filter for
initializing target fragmentation relationjava.sql.SQLException
- fetching meta-data failed,
inserting initial data failedpublic void insertPredicateParameter(java.lang.String targetRelation, java.lang.String labelValue, java.lang.String predicateValue) throws java.sql.SQLException
targetRelation
- relation in which the data is to be insertedlabelValue
- value of column label
predicateValue
- value of column predicate
java.sql.SQLException
- target relation is not Predicate Parameter relation;
insert script failed;
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |