oracle.pg.common

Class OracleConvertersUtilsBase

java.lang.Object

oracle.pg.common.OracleConvertersUtilsBase

Direct Known Subclasses:

OraclePropertyGraphUtilsBase

public class OracleConvertersUtilsBase
extends java.lang.Object

A set of utilities for converting data (CSV, Relational Tables) into property graph data.

Constructor Summary

Constructors

Constructor and Description
OracleConvertersUtilsBase()

Method Summary

Modifier and Type	Method and Description
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, boolean allowMultiline, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.io.OutputStream opeOS, DataConverterListener dcl, BackendConfig bc) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, long lOffsetVID, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, boolean allowMultiline, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, long lOffsetSVID, long lOffsetDVID, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, boolean allowMultiline, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, boolean bHasVertexLabelCol, java.lang.String vlColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, boolean allowMultiline, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl) This method converts given rdbms table to a ope file
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl, BackendConfig bc) Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lSVIDOffset, long lDVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl) Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lSVIDOffset, long lDVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl, BackendConfig bc) Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String schema, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl) Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String schema, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl, BackendConfig bc) Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String schema, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lSVIDOffset, long lDVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl) Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String schema, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lSVIDOffset, long lDVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl, BackendConfig bc) This method converts given rdbms table to a ope file
static void	convertRDBMSTable2OPV(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String vidColName, long lVIDOffset, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opvOS, DataConverterListener dcl) Converts the data from the specified relational table (from the default schema) into a set of vertices in Oracle Flat-File format (opv) and saves the data into the given output stream.
static void	convertRDBMSTable2OPV(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String vidColName, long lVIDOffset, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opvOS, DataConverterListener dcl, BackendConfig bc) Converts the data from the specified relational table into a set of vertices in Oracle Flat-File format (opv) and saves the data into the given output stream.
static void	convertRDBMSTable2OPV(java.sql.Connection conn, java.lang.String schema, java.lang.String rdbmsTableName, java.lang.String vidColName, long lVIDOffset, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opvOS, DataConverterListener dcl) Converts the data from the specified relational table into a set of vertices in Oracle Flat-File format (opv) and saves the data into the given output stream.
static void	convertRDBMSTable2OPV(java.sql.Connection conn, java.lang.String schema, java.lang.String rdbmsTableName, java.lang.String vidColName, long lVIDOffset, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opvOS, DataConverterListener dcl, BackendConfig bc) Converts given rdbms table to a opv file.

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleConvertersUtilsBase

public OracleConvertersUtilsBase()

Method Detail

convertCSV2OPE

public static final void convertCSV2OPE(java.io.InputStream inCSV,
                                        java.lang.String eidColName,
                                        long lOffsetEID,
                                        java.lang.String svidColName,
                                        java.lang.String dvidColName,
                                        boolean hasEdgeLabelCol,
                                        java.lang.String elColName,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        char delimiterChar,
                                        char quotationChar,
                                        long lOffsetLines,
                                        java.text.DateFormat dateFormat,
                                        boolean allowMultiline,
                                        java.io.OutputStream opeOS,
                                        DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

allowMultiline - Whether or not fields from can contain multiple lines, i.e. contain newline character.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static final void convertCSV2OPE(java.io.InputStream inCSV,
                                        java.lang.String eidColName,
                                        long lOffsetEID,
                                        java.lang.String svidColName,
                                        java.lang.String dvidColName,
                                        boolean hasEdgeLabelCol,
                                        java.lang.String elColName,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        char delimiterChar,
                                        char quotationChar,
                                        long lOffsetLines,
                                        java.text.DateFormat dateFormat,
                                        java.io.OutputStream opeOS,
                                        DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static final void convertCSV2OPE(java.io.InputStream inCSV,
                                        java.lang.String eidColName,
                                        long lOffsetEID,
                                        java.lang.String svidColName,
                                        java.lang.String dvidColName,
                                        boolean hasEdgeLabelCol,
                                        java.lang.String elColName,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        long lOffsetLines,
                                        java.text.DateFormat dateFormat,
                                        java.io.OutputStream opeOS,
                                        DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static final void convertCSV2OPE(java.io.InputStream inCSV,
                                        java.lang.String eidColName,
                                        long lOffsetEID,
                                        java.lang.String svidColName,
                                        java.lang.String dvidColName,
                                        boolean hasEdgeLabelCol,
                                        java.lang.String elColName,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        long lOffsetLines,
                                        java.io.OutputStream opeOS,
                                        DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static final void convertCSV2OPE(java.io.InputStream inCSV,
                                        java.lang.String eidColName,
                                        long lOffsetEID,
                                        java.lang.String svidColName,
                                        java.lang.String dvidColName,
                                        boolean hasEdgeLabelCol,
                                        java.lang.String elColName,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        long lOffsetLines,
                                        java.io.OutputStream opeOS,
                                        DataConverterListener dcl,
                                        BackendConfig bc)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static final void convertCSV2OPE(java.io.InputStream inCSV,
                                        java.lang.String eidColName,
                                        long lOffsetEID,
                                        java.lang.String svidColName,
                                        java.lang.String dvidColName,
                                        long lOffsetVID,
                                        boolean hasEdgeLabelCol,
                                        java.lang.String elColName,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        char delimiterChar,
                                        char quotationChar,
                                        long lOffsetLines,
                                        java.text.DateFormat dateFormat,
                                        boolean allowMultiline,
                                        java.io.OutputStream opeOS,
                                        DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each SVID and DVID will have a value of (lOffsetVID + SVID or lOffsetVID + DVID).

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

allowMultiline - Whether or not fields from can contain multiple lines, i.e. contain newline character.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static final void convertCSV2OPE(java.io.InputStream inCSV,
                                        java.lang.String eidColName,
                                        long lOffsetEID,
                                        java.lang.String svidColName,
                                        java.lang.String dvidColName,
                                        long lOffsetSVID,
                                        long lOffsetDVID,
                                        boolean hasEdgeLabelCol,
                                        java.lang.String elColName,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        char delimiterChar,
                                        char quotationChar,
                                        long lOffsetLines,
                                        java.text.DateFormat dateFormat,
                                        boolean allowMultiline,
                                        java.io.OutputStream opeOS,
                                        DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetSVID - the offset to the SVID. Each SVID will have a value of (lOffsetSVID + SVID).

lOffsetDVID - the offset to the DVID. Each DVID will have a value of (lOffsetDVID + DVID).

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

allowMultiline - Whether or not fields from can contain multiple lines, i.e. contain newline character.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static void convertCSV2OPV(java.io.InputStream inCSV,
                                  java.lang.String vidColName,
                                  boolean bHasVertexLabelCol,
                                  java.lang.String vlColName,
                                  long lOffsetVID,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  java.io.OutputStream opvOS,
                                  DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasVertexLabelCol - if true, read from vlColName and treat the values as vertex labels. If false, use vlColName as a constant for all vertex labels

vlColName - the column name that will be used as vertex label

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static final void convertCSV2OPV(java.io.InputStream inCSV,
                                        java.lang.String vidColName,
                                        long lOffsetVID,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        char delimiterChar,
                                        char quotationChar,
                                        long lOffsetLines,
                                        java.text.DateFormat dateFormat,
                                        boolean allowMultiline,
                                        java.io.OutputStream opvOS,
                                        DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

allowMultiline - Whether or not fields from can contain multiple lines, i.e. contain newline character.

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static final void convertCSV2OPV(java.io.InputStream inCSV,
                                        java.lang.String vidColName,
                                        long lOffsetVID,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        char delimiterChar,
                                        char quotationChar,
                                        long lOffsetLines,
                                        java.text.DateFormat dateFormat,
                                        java.io.OutputStream opvOS,
                                        DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static final void convertCSV2OPV(java.io.InputStream inCSV,
                                        java.lang.String vidColName,
                                        long lOffsetVID,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        long lOffsetLines,
                                        java.text.DateFormat dateFormat,
                                        java.io.OutputStream opvOS,
                                        DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static final void convertCSV2OPV(java.io.InputStream inCSV,
                                        java.lang.String vidColName,
                                        long lOffsetVID,
                                        ColumnToAttrMapping[] ctams,
                                        int dop,
                                        long lOffsetLines,
                                        java.io.OutputStream opvOS,
                                        DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertRDBMSTable2OPE

public static final void convertRDBMSTable2OPE(java.sql.Connection conn,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String eidColName,
                                               long lEIDOffset,
                                               java.lang.String svidColName,
                                               java.lang.String dvidColName,
                                               long lVIDOffset,
                                               boolean bHasEdgeLabelCol,
                                               java.lang.String elColName,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opeOS,
                                               DataConverterListener dcl)

This method converts given rdbms table to a ope file

Parameters:

conn - an connection instance to Oracle relational database

rdbmsTableName - the name of RDBMS table to be converted

eidColName - the column in given RDBMS table to be treated as eid, can be NULL when eidColName is not null and of type integer/long: use (column value + lEIDOffset) as eid when eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as eid when eidColName is null: use (rownum + lEIDOffset) as eid

lEIDOffset - the offset to the eid

svidColName - the column in given RDBMS table to be treated as svid, can not be NULL when svidColName is of type integer/long: use (column value + lVIDOffset) as svid when svidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as svid

dvidColName - the column in given RDBMS table to be treated as dvid, can not be NULL when eidColName is of type integer/long: use (column value + lVIDOffset) as dvid when eidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as dvid

lVIDOffset - the offset to the VID. Each SVID and DVID will have a value of (lVIDOffset + SVID or lVIDOffset + DVID).

bHasEdgeLabelCol - a boolean flag represents if the given rdbms table has a column for edge labels if true, use (value of column elColName) as edge label if false, use elColName as a constant for all edge labels

elColName -

ctams - an array of ColumnToAttrMapping objects; each ColumnToAttrMapping object defines a mapping from a column in rdbms table to an attribute of certain type in ope

dop - degree of parallelism

opeOS - ope output stream to be written to

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

convertRDBMSTable2OPE

public static final void convertRDBMSTable2OPE(java.sql.Connection conn,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String eidColName,
                                               long lEIDOffset,
                                               java.lang.String svidColName,
                                               java.lang.String dvidColName,
                                               long lVIDOffset,
                                               boolean bHasEdgeLabelCol,
                                               java.lang.String elColName,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opeOS,
                                               DataConverterListener dcl,
                                               BackendConfig bc)

Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

schema - the owner of the relational table to convert to graph data.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

eidColName - the column from the table to be treated as Edge ID (EID column in Flat-file).

When eidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as edge ID

When eidColName is null: use (rownum + lEIDOffset) as edge ID

lEIDOffset - the offset to use for edge IDs. This parameter is useful to avoid overlaps with existing edges.

svidColName - the column from the table to be treated as Source Vertex ID. (SVID column in Flat-file). Note that this parameter cannot be NULL

When svidColName is of type integer/long: use (column value + lVIDOffset) as Source Vertex ID

When svidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as Source Vertex ID.

dvidColName - the column from the table to be treated as Destination Vertex ID (DVID column in Flat-file). Note that this parameter cannot be NULL

When dvidColName is of type integer/long: use (column value + lVIDOffset) as Destination Vertex ID

When dvidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as Destination Vertex ID

bHasEdgeLabelCol - a boolean flag represents if a table column will be used for edge labels if true, use the column specified in parameter elColName as edge label if false, use the value of elColName as a constant for all edge labels

elColName - the column from the table to be treated as Edge Label (EL column in Flat-file)

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to an edge property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the edge data in Oracle Flat-file format (ope) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

bc - a BackendConfig specifying the constraints to use for labels and property key/value size.

convertRDBMSTable2OPE

public static final void convertRDBMSTable2OPE(java.sql.Connection conn,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String eidColName,
                                               long lEIDOffset,
                                               java.lang.String svidColName,
                                               java.lang.String dvidColName,
                                               long lSVIDOffset,
                                               long lDVIDOffset,
                                               boolean bHasEdgeLabelCol,
                                               java.lang.String elColName,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opeOS,
                                               DataConverterListener dcl)

Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

eidColName - the column from the table to be treated as Edge ID (EID column in Flat-file).

When eidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as edge ID

When eidColName is null: use (rownum + lEIDOffset) as edge ID

lEIDOffset - the offset to use for edge IDs. This parameter is useful to avoid overlaps with existing edges.

svidColName - the column from the table to be treated as Source Vertex ID. (SVID column in Flat-file). Note that this parameter cannot be NULL

When svidColName is of type integer/long: use (column value + lSVIDOffset) as Source Vertex ID

When svidColName is not of type integer/long: use (hash(column value) + lSVIDOffset) as Source Vertex ID.

dvidColName - the column from the table to be treated as Destination Vertex ID (DVID column in Flat-file). Note that this parameter cannot be NULL

When dvidColName is of type integer/long: use (column value + lDVIDOffset) as Destination Vertex ID

When dvidColName is not of type integer/long: use (hash(column value) + lDVIDOffset) as Destination Vertex ID

lSVIDOffset - the offset to use for Source Vertex IDs. This parameter is useful to map Source Vertex IDs with vertices generated using convertRDBMSTable2OPV.

lDVIDOffset - the offset to use for Destination Vertex IDs. This parameter is useful to map Destination Vertex IDs with vertices generated using convertRDBMSTable2OPV.

bHasEdgeLabelCol - a boolean flag represents if a table column will be used for edge labels if true, use the column specified in parameter elColName as edge label if false, use the value of elColName as a constant for all edge labels

elColName - the column from the table to be treated as Edge Label (EL column in Flat-file)

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to an edge property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the edge data in Oracle Flat-file format (ope) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

convertRDBMSTable2OPE

public static final void convertRDBMSTable2OPE(java.sql.Connection conn,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String eidColName,
                                               long lEIDOffset,
                                               java.lang.String svidColName,
                                               java.lang.String dvidColName,
                                               long lSVIDOffset,
                                               long lDVIDOffset,
                                               boolean bHasEdgeLabelCol,
                                               java.lang.String elColName,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opeOS,
                                               DataConverterListener dcl,
                                               BackendConfig bc)

Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

schema - the owner of the relational table to convert to graph data.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

eidColName - the column from the table to be treated as Edge ID (EID column in Flat-file).

When eidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as edge ID

When eidColName is null: use (rownum + lEIDOffset) as edge ID

lEIDOffset - the offset to use for edge IDs. This parameter is useful to avoid overlaps with existing edges.

svidColName - the column from the table to be treated as Source Vertex ID. (SVID column in Flat-file). Note that this parameter cannot be NULL

When svidColName is of type integer/long: use (column value + lSVIDOffset) as Source Vertex ID

When svidColName is not of type integer/long: use (hash(column value) + lSVIDOffset) as Source Vertex ID.

dvidColName - the column from the table to be treated as Destination Vertex ID (DVID column in Flat-file). Note that this parameter cannot be NULL

When dvidColName is of type integer/long: use (column value + lDVIDOffset) as Destination Vertex ID

When dvidColName is not of type integer/long: use (hash(column value) + lDVIDOffset) as Destination Vertex ID

lSVIDOffset - the offset to use for Source Vertex IDs. This parameter is useful to map Source Vertex IDs with vertices generated using convertRDBMSTable2OPV.

lDVIDOffset - the offset to use for Destination Vertex IDs. This parameter is useful to map Destination Vertex IDs with vertices generated using convertRDBMSTable2OPV.

bHasEdgeLabelCol - a boolean flag represents if a table column will be used for edge labels if true, use the column specified in parameter elColName as edge label if false, use the value of elColName as a constant for all edge labels

elColName - the column from the table to be treated as Edge Label (EL column in Flat-file)

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to an edge property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the edge data in Oracle Flat-file format (ope) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

bc - a BackendConfig specifying the constraints to use for labels and property key/value size.

convertRDBMSTable2OPE

public static final void convertRDBMSTable2OPE(java.sql.Connection conn,
                                               java.lang.String schema,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String eidColName,
                                               long lEIDOffset,
                                               java.lang.String svidColName,
                                               java.lang.String dvidColName,
                                               long lVIDOffset,
                                               boolean bHasEdgeLabelCol,
                                               java.lang.String elColName,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opeOS,
                                               DataConverterListener dcl)

Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

schema - the owner of the relational table to convert to graph data.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

eidColName - the column from the table to be treated as Edge ID (EID column in Flat-file).

When eidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as edge ID

When eidColName is null: use (rownum + lEIDOffset) as edge ID

lEIDOffset - the offset to use for edge IDs. This parameter is useful to avoid overlaps with existing edges.

svidColName - the column from the table to be treated as Source Vertex ID. (SVID column in Flat-file). Note that this parameter cannot be NULL

When svidColName is of type integer/long: use (column value + lVIDOffset) as Source Vertex ID

When svidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as Source Vertex ID

dvidColName - the column from the table to be treated as Destination Vertex ID (DVID column in Flat-file). Note that this parameter cannot be NULL

When dvidColName is of type integer/long: use (column value + lVIDOffset) as Destination Vertex ID

When dvidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as Destination Vertex ID

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to an edge property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the edge data in Oracle Flat-file format (ope) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

convertRDBMSTable2OPE

public static final void convertRDBMSTable2OPE(java.sql.Connection conn,
                                               java.lang.String schema,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String eidColName,
                                               long lEIDOffset,
                                               java.lang.String svidColName,
                                               java.lang.String dvidColName,
                                               long lVIDOffset,
                                               boolean bHasEdgeLabelCol,
                                               java.lang.String elColName,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opeOS,
                                               DataConverterListener dcl,
                                               BackendConfig bc)

Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

schema - the owner of the relational table to convert to graph data.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

eidColName - the column from the table to be treated as Edge ID (EID column in Flat-file).

When eidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as edge ID

When eidColName is null: use (rownum + lEIDOffset) as edge ID

lEIDOffset - the offset to use for edge IDs. This parameter is useful to avoid overlaps with existing edges.

svidColName - the column from the table to be treated as Source Vertex ID. (SVID column in Flat-file). Note that this parameter cannot be NULL

When svidColName is of type integer/long: use (column value + lVIDOffset) as Source Vertex ID

When svidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as Source Vertex ID.

dvidColName - the column from the table to be treated as Destination Vertex ID (DVID column in Flat-file). Note that this parameter cannot be NULL

When dvidColName is of type integer/long: use (column value + lVIDOffset) as Destination Vertex ID

When dvidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as Destination Vertex ID

lVIDOffset - the offset to use for Source/Destination Vertex IDs. This parameter is useful to map Source/Destination Vertex IDs with vertices generated using convertRDBMSTable2OPV.

bHasEdgeLabelCol - a boolean flag represents if a table column will be used for edge labels if true, use the column specified in parameter elColName as edge label if false, use the value of elColName as a constant for all edge labels

elColName - the column from the table to be treated as Edge Label (EL column in Flat-file)

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to an edge property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the edge data in Oracle Flat-file format (ope) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

bc - a BackendConfig specifying the constraints to use for labels and property key/value size.

convertRDBMSTable2OPE

public static final void convertRDBMSTable2OPE(java.sql.Connection conn,
                                               java.lang.String schema,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String eidColName,
                                               long lEIDOffset,
                                               java.lang.String svidColName,
                                               java.lang.String dvidColName,
                                               long lSVIDOffset,
                                               long lDVIDOffset,
                                               boolean bHasEdgeLabelCol,
                                               java.lang.String elColName,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opeOS,
                                               DataConverterListener dcl)

Converts the data from the specified relational table (from the default schema) into a set of edges in Oracle Flat-File format (ope) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

schema - the owner of the relational table to convert to graph data.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

eidColName - the column from the table to be treated as Edge ID (EID column in Flat-file).

When eidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as edge ID

When eidColName is null: use (rownum + lEIDOffset) as edge ID

lEIDOffset - the offset to use for edge IDs. This parameter is useful to avoid overlaps with existing edges.

svidColName - the column from the table to be treated as Source Vertex ID. (SVID column in Flat-file). Note that this parameter cannot be NULL

When svidColName is of type integer/long: use (column value + lSVIDOffset) as Source Vertex ID

When svidColName is not of type integer/long: use (hash(column value) + lSVIDOffset) as Source Vertex ID.

dvidColName - the column from the table to be treated as Destination Vertex ID (DVID column in Flat-file). Note that this parameter cannot be NULL

When dvidColName is of type integer/long: use (column value + lDVIDOffset) as Destination Vertex ID

When dvidColName is not of type integer/long: use (hash(column value) + lDVIDOffset) as Destination Vertex ID

lSVIDOffset - the offset to use for Source Vertex IDs. This parameter is useful to map Source Vertex IDs with vertices generated using convertRDBMSTable2OPV.

lDVIDOffset - the offset to use for Destination Vertex IDs. This parameter is useful to map Destination Vertex IDs with vertices generated using convertRDBMSTable2OPV.

bHasEdgeLabelCol - a boolean flag represents if a table column will be used for edge labels if true, use the column specified in parameter elColName as edge label if false, use the value of elColName as a constant for all edge labels

elColName - the column from the table to be treated as Edge Label (EL column in Flat-file)

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to an edge property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the edge data in Oracle Flat-file format (ope) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

convertRDBMSTable2OPE

public static final void convertRDBMSTable2OPE(java.sql.Connection conn,
                                               java.lang.String schema,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String eidColName,
                                               long lEIDOffset,
                                               java.lang.String svidColName,
                                               java.lang.String dvidColName,
                                               long lSVIDOffset,
                                               long lDVIDOffset,
                                               boolean bHasEdgeLabelCol,
                                               java.lang.String elColName,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opeOS,
                                               DataConverterListener dcl,
                                               BackendConfig bc)

This method converts given rdbms table to a ope file

Parameters:

conn - an connection instance to Oracle relational database

rdbmsTableName - the name of RDBMS table to be converted

eidColName - the column in given RDBMS table to be treated as eid, can be NULL when eidColName is not null and of type integer/long: use (column value + lEIDOffset) as eid when eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as eid when eidColName is null: use (rownum + lEIDOffset) as eid

lEIDOffset - the offset to the eid

svidColName - the column in given RDBMS table to be treated as svid, can not be NULL when svidColName is of type integer/long: use (column value + lVIDOffset) as svid when svidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as svid

dvidColName - the column in given RDBMS table to be treated as dvid, can not be NULL when eidColName is of type integer/long: use (column value + lVIDOffset) as dvid when eidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as dvid

lSVIDOffset - the offset to the SVID. Each SVID will have a value of (lSVIDOffset + SVID).

lDVIDOffset - the offset to the DVID. Each DVID will have a value of (lDVIDOffset + DVID).

bHasEdgeLabelCol - a boolean flag represents if the given rdbms table has a column for edge labels if true, use (value of column elColName) as edge label if false, use elColName as a constant for all edge labels

elColName -

ctams - an array of ColumnToAttrMapping objects; each ColumnToAttrMapping object defines a mapping from a column in rdbms table to an attribute of certain type in ope

dop - degree of parallelism

opeOS - ope output stream to be written to

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

bc -

convertRDBMSTable2OPV

public static final void convertRDBMSTable2OPV(java.sql.Connection conn,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String vidColName,
                                               long lVIDOffset,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opvOS,
                                               DataConverterListener dcl)

Converts the data from the specified relational table (from the default schema) into a set of vertices in Oracle Flat-File format (opv) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

vidColName - the column from the table to be treated as Vertex ID (VID column in Flat-file).

When vidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When vidColName is not null and not of type integer/long: use (hash(column value) + lVIDOffset) as vertex ID

When vidColName is null: use (rownum + lVIDOffset) as Vertex ID

lVIDOffset - the offset to use for vertices IDs. This parameter is useful to avoid overlaps with existing vertices.

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to a vertex property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the vertices data in Oracle Flat-file format (opv) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

convertRDBMSTable2OPV

public static final void convertRDBMSTable2OPV(java.sql.Connection conn,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String vidColName,
                                               long lVIDOffset,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opvOS,
                                               DataConverterListener dcl,
                                               BackendConfig bc)

Converts the data from the specified relational table into a set of vertices in Oracle Flat-File format (opv) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

vidColName - the column from the table to be treated as Vertex ID (VID column in Flat-file).

When vidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When vidColName is not null and not of type integer/long: use (hash(column value) + lVIDOffset) as vertex ID

When vidColName is null: use (rownum + lVIDOffset) as Vertex ID

lVIDOffset - the offset to use for vertices IDs. This parameter is useful to avoid overlaps with existing vertices.

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to a vertex property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the vertices data in Oracle Flat-file format (opv) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

bc - a BackendConfig specifying the constraints to use for labels and property key/value size.

convertRDBMSTable2OPV

public static final void convertRDBMSTable2OPV(java.sql.Connection conn,
                                               java.lang.String schema,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String vidColName,
                                               long lVIDOffset,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opvOS,
                                               DataConverterListener dcl)

Converts the data from the specified relational table into a set of vertices in Oracle Flat-File format (opv) and saves the data into the given output stream.

Parameters:

conn - a connection instance to the relational database where the data to convert is stored.

rdbmsTableName - the name of the relational table to be converted. Note that the table name must not include the owner of the table.

vidColName - the column from the table to be treated as Vertex ID (VID column in Flat-file).

When vidColName is not null and of type integer/long: use (column value + lVIDOffset) as vertex ID

When vidColName is not null and not of type integer/long: use (hash(column value) + lVIDOffset) as vertex ID

When vidColName is null: use (rownum + lVIDOffset) as Vertex ID

lVIDOffset - the offset to use for vertices IDs. This parameter is useful to avoid overlaps with existing vertices.

ctams - an array of ColumnToAttrMapping objects; where each ColumnToAttrMapping object defines a Column-Property mapping. This way a given column in the table is converted to a vertex property.

dop - degree of parallelism used when processing the data.

opvOS - an OutputStream where the vertices data in Oracle Flat-file format (opv) will be stored.

dcl - a DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

bc - a BackendConfig specifying the constraints to use for labels and property key/value size.

convertRDBMSTable2OPV

public static final void convertRDBMSTable2OPV(java.sql.Connection conn,
                                               java.lang.String schema,
                                               java.lang.String rdbmsTableName,
                                               java.lang.String vidColName,
                                               long lVIDOffset,
                                               ColumnToAttrMapping[] ctams,
                                               int dop,
                                               java.io.OutputStream opvOS,
                                               DataConverterListener dcl,
                                               BackendConfig bc)

Converts given rdbms table to a opv file.

Parameters:

conn - an connection instance to Oracle relational database

rdbmsTableName - the name of RDBMS table to be converted

vidColName - the column in given RDBMS table to be treated as vid when vidColName is not null and of type integer/long: use (column value + lVIDOffset) as vid when vidColName is not null and not of type integer/long: use (hash(column value) + lVIDOffset) as vid when vidColName is null: use (rownum + lVIDOffset) as vid

lVIDOffset - the offset to the vid

ctams - an array of ColumnToAttrMapping objects; each ColumnToAttrMapping object defines a mapping from a column in rdbms table to an attribute of certain type in opv

dop - degree of parallelism

opvOS - opv output stream to be written to

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.