WorkDictionary (BioLexicon ETL process documentation)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

eu.bootstrep.ManageDictionary
Class WorkDictionary

java.lang.Object
  eu.bootstrep.ManageDictionary.WorkDictionary

public class WorkDictionary
extends java.lang.Object
extends java.lang.Object

This class contains methods to access the dictionary frame.
This method is mainly used to model the TheElement bean.

Field Summary
`(package private) DbMethods`	`DB` An instance of DbMethods Class.
`(package private) Variables`	`LOV` An instance of Variables Class.
`(package private) Logger`	`xmlLog` An instance of Logger Class.

Constructor Summary
`WorkDictionary()` Creates a new instance of WorkDictionary

Method Summary
`java.lang.String`	`createColumnList(PropertyBean PB, MainBean MB, MessageBean mesBn, ListBean LB, TableBean tabBn, java.lang.String xmlName, java.lang.Boolean standard, java.lang.Integer type)` This method creates a list of columns for a staging table to load.
`java.lang.String`	`createInsertInto(PropertyBean PB, MainBean MB, MessageBean mesBn, ListBean LB, TableBean tabBn, java.lang.String xmlName, java.lang.String fatName, java.lang.Integer deep, java.lang.Boolean standard)` This method creates a list of columns for a staging table to load.
`java.lang.String[][]`	`getBitMap(PropertyBean PB, MainBean MB, MessageBean mesBn, ListBean LB, TableBean tabBn, java.lang.String xmlName, java.lang.Integer deep)` This method extracts from the WORK_BITMAP_ID_TABLE the following information: xmlName: XML input element xmlAtt: XML element attribute carrying the identifier prefix: the prefix of the identifier.
`java.lang.String[][]`	`getGranFatBitMap(PropertyBean PB, MainBean MB, MessageBean mesBn, ListBean LB, TableBean tabBn, java.lang.String xmlName, java.lang.String fatName, java.lang.Integer deep)` This method extracts from the WORK_BITMAP_ID_TABLE AND WORK_HAS_MULTIID tables the following information: xmlName: XML input element xmlAtt: XML element attribute carrying the identifier prefix: the prefix of the identifier.
`java.lang.String`	`getTable2Load(PropertyBean PB, MainBean MB, MessageBean mesBn, ListBean LB, TableBean tabBn, java.lang.String xmlName, java.lang.String fatName, java.lang.Integer deep, java.lang.Boolean standard)` This method retrieves staging table to load.

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Field Detail

LOV

Variables LOV

An instance of Variables Class.

DB

DbMethods DB

An instance of DbMethods Class.

xmlLog

Logger xmlLog

An instance of Logger Class.

Constructor Detail

WorkDictionary

public WorkDictionary()

Creates a new instance of WorkDictionary

Method Detail

getBitMap

public java.lang.String[][] getBitMap(PropertyBean PB,
                                      MainBean MB,
                                      MessageBean mesBn,
                                      ListBean LB,
                                      TableBean tabBn,
                                      java.lang.String xmlName,
                                      java.lang.Integer deep)

This method extracts from the WORK_BITMAP_ID_TABLE the following information:

xmlName: XML input element
xmlAtt: XML element attribute carrying the identifier
prefix: the prefix of the identifier. For instance LM_ for lemmas, LE_ for lexical entries...
position: the position of element attribute carrying the identifier. For example the <Entry entryId="ENTRY01" baseForm="BASENAME" type="PREFERRED" / > element has entryId attribute as identifier in position 0.

If an element has more than one attribute, then records in table WORK_BITMAP_ID_TABLE are more than one. The methods returns a string matrix which is a snapshot of the WORK_BITMAP_ID_TABLE table for xmlName

Parameters:: PB - The PropertyBean; MB - The MainBean; mesBn - The MessageBean; LB - The ListBean; tabBn - The TableBean; xmlName - The XML element as input; deep - The indentation of the input element
Returns:: A snapshot of the WORK_BITMAP_ID_TABLE as string matrix

getGranFatBitMap

public java.lang.String[][] getGranFatBitMap(PropertyBean PB,
                                             MainBean MB,
                                             MessageBean mesBn,
                                             ListBean LB,
                                             TableBean tabBn,
                                             java.lang.String xmlName,
                                             java.lang.String fatName,
                                             java.lang.Integer deep)

This method extracts from the WORK_BITMAP_ID_TABLE AND WORK_HAS_MULTIID tables the following information:

xmlName: XML input element
xmlAtt: XML element attribute carrying the identifier
prefix: the prefix of the identifier. For instance LM_ for lemmas, LE_ for lexical entries...
position: the position of element attribute carrying the identifier.

This method is executed when data categories are managed. Data categories have bitMap=0, thus the identifier(s) are extracted from granparent elements. For instance, <DC / > may belong to different elements, <Wordform / >, <Variant / >...Both of these elements are children of <Entry / >. This method manages this taxonomy as follows:

select the parent-child relationship in the WORK_HAS_MULTIID table and retrieves granparent element
select information for granparent element from WORK_BITMAP_ID_TABLE

Parameters:: PB - The PropertyBean; MB - The MainBean; mesBn - The MessageBean; LB - The ListBean; tabBn - The TableBean; xmlName - The XML input element; fatName - The XML input parent element; deep - The indentation of XML input element
Returns:: A snapshot of the WORK_BITMAP_ID_TABLE as string matrix

getTable2Load

public java.lang.String getTable2Load(PropertyBean PB,
                                      MainBean MB,
                                      MessageBean mesBn,
                                      ListBean LB,
                                      TableBean tabBn,
                                      java.lang.String xmlName,
                                      java.lang.String fatName,
                                      java.lang.Integer deep,
                                      java.lang.Boolean standard)

This method retrieves staging table to load.
standard input parameter selects standard staging tables, from WORK_LIST_TABLES or from WORK_REL_FILES for correspondence staging tables.

Parameters:: PB - The PropertyBean; MB - The MainBean; mesBn - The MessageBean; LB - The ListBean; tabBn - The TableBean; xmlName - The XML input element; fatName - The XML input parent element; deep - The indentation of input element; standard - true-> standard tables ; false -> correspondence tables
Returns:: The table

createColumnList

public java.lang.String createColumnList(PropertyBean PB,
                                         MainBean MB,
                                         MessageBean mesBn,
                                         ListBean LB,
                                         TableBean tabBn,
                                         java.lang.String xmlName,
                                         java.lang.Boolean standard,
                                         java.lang.Integer type)

This method creates a list of columns for a staging table to load.
standard input parameter selects standard staging tables, from WORK_MAP_COLUMNS or from WORK_REL_COLUMNS for correspondence staging tables.
type different from 0 selects the DICT table. DICT table is used to load tables out from dictionary based methods.
This method extract the following information:

column name

Please note that this method is executed only with type different from 0

Parameters:: PB - The PropertyBean; MB - The MainBean; mesBn - The MessageBean; LB - The ListBean; tabBn - The TableBean; xmlName - The XML input element; standard - true-> standard tables ; false -> correspondence tables; type - When type parameter is 0, standard selects one of the two possible dictionary tables. If type different from 0, then DICT table is selected
Returns:: The list of columns formatted as a string: col1, col2....

createInsertInto

public java.lang.String createInsertInto(PropertyBean PB,
                                         MainBean MB,
                                         MessageBean mesBn,
                                         ListBean LB,
                                         TableBean tabBn,
                                         java.lang.String xmlName,
                                         java.lang.String fatName,
                                         java.lang.Integer deep,
                                         java.lang.Boolean standard)

This method creates a list of columns for a staging table to load.
standard input parameter selects standard staging tables, from WORK_MAP_COLUMNS or from WORK_REL_COLUMNS for correspondence staging tables.
This method is close to the createColumnList, but the return value is different.

This method extract the following information:

column name

Parameters:: PB - The PropertyBean; MB - The MainBean; mesBn - The MessageBean; LB - The ListBean; tabBn - The TableBean; xmlName - The XML input element; fatName - The XML input parent element; standard - true-> standard tables ; false -> correspondence tables
Returns:: The list of columns formatted as string : (col1,..col2...)