uk.ac.ox.cs.diadem.oxpath.output.hierarchy.jdbc

Class HierarchyJDBCOutputHandler

java.lang.Object

uk.ac.ox.cs.diadem.oxpath.output.ACustomOutputHandler

uk.ac.ox.cs.diadem.oxpath.output.relation.RelationOutputHandler

uk.ac.ox.cs.diadem.oxpath.output.hierarchy.jdbc.HierarchyJDBCOutputHandler

All Implemented Interfaces:

IAbstractOutputHandler, IOutputHandler, ISerializable<RelationModel>, IWithAccumulativeOutput<RelationModel>

public class HierarchyJDBCOutputHandler
extends RelationOutputHandler
implements ISerializable<RelationModel>

Serialisation of the tree of entities from the OXPath result tree into one denormalised relation into the database.

Author:

Ruslan Fayzrakhmanov 18 Feb 2017

Nested Class Summary

Nested classes/interfaces inherited from class uk.ac.ox.cs.diadem.oxpath.output.relation.RelationOutputHandler

RelationOutputHandler.IFilter<T>

Field Summary

Fields

Modifier and Type	Field and Description
static char	ESCAPE_CHAR_DEFAULT
static char	PATH_SEPARATOR_DEFAULT
static char	VALUE_SEPARATOR_DEFAULT

Fields inherited from class uk.ac.ox.cs.diadem.oxpath.output.relation.RelationOutputHandler

EMPTY_ROW_FILTER, ID_LABEL_PART_DEFAULT, idLabelPart, includeId, includeRecordLabel

Fields inherited from class uk.ac.ox.cs.diadem.oxpath.output.ACustomOutputHandler

DEFAULT_WRAPPER_ID

Constructor Summary

Constructors

Constructor and Description
HierarchyJDBCOutputHandler(boolean allowMultipleValuesPerAttribute, String[][] entityRelPathList, boolean includeId, boolean includeRecordLabel, RelationOutputHandler.IFilter<String> valFilter, RelationOutputHandler.IFilter<List<List<String>>> rowFilter, char pathSeparator, char valueSeparator, char escapeChar, String driver, String dbUrl, String dbUser, String dbPsw, String schemaName, String tableName, boolean override, int batchSize)
HierarchyJDBCOutputHandler(boolean allowMultipleValuesPerAttribute, String[][] entityRelPathList, boolean includeId, boolean includeRecordLabel, RelationOutputHandler.IFilter<String> valFilter, RelationOutputHandler.IFilter<List<List<String>>> rowFilter, String driver, String dbUrl, String dbUser, String dbPsw, String schemaName, String tableName, boolean override, int batchSize)
HierarchyJDBCOutputHandler(String wrapperId, boolean allowMultipleValuesPerAttribute, String[][] entityRelPathList, boolean includeId, boolean includeRecordLabel, RelationOutputHandler.IFilter<String> valFilter, RelationOutputHandler.IFilter<List<List<String>>> rowFilter, char pathSeparator, char valueSeparator, char escapeChar, String driver, String dbUrl, String dbUser, String dbPsw, String schemaName, String tableName, boolean override, int batchSize)

Method Summary

Modifier and Type	Method and Description
void	serialize()

Methods inherited from class uk.ac.ox.cs.diadem.oxpath.output.relation.RelationOutputHandler

getAccumulativeOutput, processNodeImpl

Methods inherited from class uk.ac.ox.cs.diadem.oxpath.output.ACustomOutputHandler

getAllowMultipleValuesPerAttribute, getAttributesSeenPerTuple, getOuterExceptions, getOuterExceptionStackTracesAsString, getWrapperId, hasOuterException, isEndNodeReceived, logInfo, processNode, receiveOuterException

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface uk.ac.ox.cs.diadem.oxpath.output.IWithAccumulativeOutput

getAccumulativeOutput

Field Detail

PATH_SEPARATOR_DEFAULT

public static final char PATH_SEPARATOR_DEFAULT

See Also:

Constant Field Values

VALUE_SEPARATOR_DEFAULT

public static final char VALUE_SEPARATOR_DEFAULT

See Also:

Constant Field Values

ESCAPE_CHAR_DEFAULT

public static final char ESCAPE_CHAR_DEFAULT

See Also:

Constant Field Values

Constructor Detail

HierarchyJDBCOutputHandler

public HierarchyJDBCOutputHandler(boolean allowMultipleValuesPerAttribute,
                                  String[][] entityRelPathList,
                                  boolean includeId,
                                  boolean includeRecordLabel,
                                  RelationOutputHandler.IFilter<String> valFilter,
                                  RelationOutputHandler.IFilter<List<List<String>>> rowFilter,
                                  String driver,
                                  String dbUrl,
                                  String dbUser,
                                  String dbPsw,
                                  String schemaName,
                                  String tableName,
                                  boolean override,
                                  int batchSize)

Parameters:

allowMultipleValuesPerAttribute - true: multiple values are allowed per attribute

entityRelPathList - array of paths of entities to be identified in the extraction tree

includeId - true: ids corresponding to entities are incorporated into the model

includeRecordLabel - true: the name of the record nesting attributes and child entities is included into the path name.

valFilter - a function for filtering values (can be null)

rowFilter - a function for filtering records (can be null)

driver - JDBC driver (class)

dbUrl - JDBC database URL

dbUser - database user

dbPsw - database password

schemaName - schema name

tableName - table name

override - true: able will be re-created

batchSize - minimal number of queries to be committed at once

HierarchyJDBCOutputHandler

public HierarchyJDBCOutputHandler(boolean allowMultipleValuesPerAttribute,
                                  String[][] entityRelPathList,
                                  boolean includeId,
                                  boolean includeRecordLabel,
                                  RelationOutputHandler.IFilter<String> valFilter,
                                  RelationOutputHandler.IFilter<List<List<String>>> rowFilter,
                                  char pathSeparator,
                                  char valueSeparator,
                                  char escapeChar,
                                  String driver,
                                  String dbUrl,
                                  String dbUser,
                                  String dbPsw,
                                  String schemaName,
                                  String tableName,
                                  boolean override,
                                  int batchSize)

Parameters:

allowMultipleValuesPerAttribute - true: multiple values are allowed per attribute

entityRelPathList - array of paths of entities to be identified in the extraction tree

includeId - true: ids corresponding to entities are incorporated into the model

includeRecordLabel - true: the name of the record nesting attributes and child entities is included into the path name.

valFilter - a function for filtering values (can be null)

rowFilter - a function for filtering records (can be null)

pathSeparator - character to join components of the path denoting the entity's attribute

valueSeparator - character to join values of the entity's attribute

escapeChar - escape character used in string join operation

driver - JDBC driver (class)

dbUrl - JDBC database URL

dbUser - database user

dbPsw - database password

schemaName - schema name

tableName - table name

override - true: able will be re-created

batchSize - minimal number of queries to be committed at once

HierarchyJDBCOutputHandler

public HierarchyJDBCOutputHandler(String wrapperId,
                                  boolean allowMultipleValuesPerAttribute,
                                  String[][] entityRelPathList,
                                  boolean includeId,
                                  boolean includeRecordLabel,
                                  RelationOutputHandler.IFilter<String> valFilter,
                                  RelationOutputHandler.IFilter<List<List<String>>> rowFilter,
                                  char pathSeparator,
                                  char valueSeparator,
                                  char escapeChar,
                                  String driver,
                                  String dbUrl,
                                  String dbUser,
                                  String dbPsw,
                                  String schemaName,
                                  String tableName,
                                  boolean override,
                                  int batchSize)

Parameters:

wrapperId -

allowMultipleValuesPerAttribute - true: multiple values are allowed per attribute

entityRelPathList - array of paths of entities to be identified in the extraction tree

includeId - true: ids corresponding to entities are incorporated into the model

includeRecordLabel - true: the name of the record nesting attributes and child entities is included into the path name.

valFilter - a function for filtering values (can be null)

rowFilter - a function for filtering records (can be null)

pathSeparator - character to join components of the path denoting the entity's attribute

valueSeparator - character to join values of the entity's attribute

escapeChar - escape character used in string join operation

driver - JDBC driver (class)

dbUrl - JDBC database URL

dbUser - database user

dbPsw - database password

schemaName - schema name

tableName - table name

override - true: able will be re-created

batchSize - minimal number of queries to be committed at once

Method Detail

serialize

public void serialize()

Specified by:

serialize in interface ISerializable<RelationModel>