This method translates an EmbeddedQuery object into Java code
when the EmbeddedQuery corresponds to a query whose result is
assigned to a variable declared in the LET clause of the context
transformation.
a HashMap containing the names of the tables for which this attribute
is actually a backtracking explaining attribute and also the
correspoding attribute.
beginLine and beginColumn describe the position of the first character
of this token; endLine and endColumn describe the position of the
last character of this token.
beginLine -
Variable in class ajax.wrappers.sqlParser.Token
beginLine and beginColumn describe the position of the first character
of this token; endLine and endColumn describe the position of the
last character of this token.
Catalog stores the schema of tables and the cleaning transformations
Each table schema is composed by the table name and the list
of attribute names and attribute types
endColumn -
Variable in class ajax.wrappers.sqlParser.Token
beginLine and beginColumn describe the position of the first character
of this token; endLine and endColumn describe the position of the
last character of this token.
endLine -
Variable in class ajax.wrappers.sqlParser.Token
beginLine and beginColumn describe the position of the first character
of this token; endLine and endColumn describe the position of the
last character of this token.
Given an algorithm name, this method looks for the corresponding
algorithm in the catalog and returns the corresponding algorithm object.
if not found it returns null.
Returns an Iterator through a list containg those FieldType objects
which correspond to the explaining attributes from this table which
go back to the table given as parameter into String tableName argument
Given a function name, this method looks for the corresponding
function in the catalog and returns the corresponding function object.
if not found it returns null.
Gets the input names of the transformation
including the inputs of the embedded selects
Contains a list of input names
It returns the names of the all inputs of the transformation,
Gets the ouput names of the transformation
Contains a list of output names
It returns the names of the all outputs of the transformation,
including the ones from embedded queries, from outer joins,
except the exception table name
Given a table name this method looks for the corresponding
table in the catalog and returns the corresponding table object.
if not found it returns null.
Given a transformation name, this method looks for the corresponding
transformation in the catalog and returns the corresponding object.
if not found it returns null.
Set the key fields of this transformation and defines also the
the exceptionOutput object associated to this transformation.
we are supposing that the key field of each view component
is presented in the key of the Unionview transformation.
isLetOptimizableDE()
Checks if the LET clause allows the match to be optimized by
getting rid of the exact duplicates before executing the approximate match
If it is optimizable, returns a list of T_REFERENCE expressions with the names of
the columns used for the optimization
isLetToSQL()
Checks if the LET clause:
- contains an IF statement or a CORRELATED query
- if it is a variable declaration and the type returned by the expression
assigned is a ComposedType
Says if this table is the result of an output of a transformation or
corresponds to a table defined by the user and supplied as input of
the cleaning program. returns true in the first case and false in the
second case.
Loads the contents of a file into a table using
Writes the control file used by sqlldr to load a file
into a table
The name of the table is given by the file name
Defines the output associated to the exception table.
the key of each input is placed in the schema of this exception table plus
an aditional field which contains the exception message.
Generates code for executing the body of the transformation
We are using the exception table of the context transformation
to store possible exceptions that may arise in the execution of
this transformation.
Interface used for accessing to base dirty data or transformation results
and storing transformation results
The result of a transformation or a set of dirty data is stored in a
storage unit that can be a relational table or a file.