Skip navigation links

Oracle Data Mining Java API Reference
11g Release 2 (11.2)

E12219-03


oracle.dmt.jdm.transform
Interface OraExpressionTransform

All Superinterfaces:
OraTransformation

public interface OraExpressionTransform
extends OraTransformation

OraExpressionTransform is used to specify per attribute SQL expressions for tranformation and optional reverse transformation of the data. For example, to specify data transformation for age attribute as a logarithm function with base 10 and the transformed attribute must be renamed as log_age, call the following method:

addAttributeExpression("age", "log(10, age) as log_age", "power(10, log_age)")

Here the first parameter "age" is input attribute that you wanted to transform, the second parameter "log(10, age) as log_age" is the SQL expression to specify the transformation and renaming of the input attribute and the third parameter "power(10, log_age) as age" is the SQL experssion to specify optinal reverse transformation to get back to the original data.

Since:
OJDM 11.1.0

Nested Class Summary
static interface OraExpressionTransform.OraExpressionElement
          OraExpressionElement is used to encapsulate the per attribute expression inverse expression details.

 

Method Summary
 void addAttributeExpression(java.lang.String inputAttr, java.lang.String expression, java.lang.String inverseExpression)
          Defines the expression involving the attribute specified in inputAttr with corresponding optional inverseExpression.
 void addAttributeExpression(java.lang.String inputAttr, java.lang.String expression, java.lang.String inverseExpression, java.lang.String attrSpec)
          Defines the expression involving the attribute specified in inputAttr with corresponding optional inverseExpression and attrSpec.
 java.util.Map getAttributeExpressionMap()
          Returns a map of the overridden attributes that contains the key as the input attribute name and the value as the OraExpressionElement instance.
 void removeAttributeExpression(java.lang.String inputAttrName)
          Removes the specified attribute's OraExpressionElement from the settings.

 

Methods inherited from interface oracle.dmt.jdm.transform.OraTransformation
getExcludeColumnList, getTransformInputData, getTransformOutputData, isOutputView, setExcludeColumnList, setTransformInputData, setTransformOutputData

 

Method Detail

addAttributeExpression

public void addAttributeExpression(java.lang.String inputAttr,
                                   java.lang.String expression,
                                   java.lang.String inverseExpression)
Defines the expression involving the attribute specified in inputAttr with corresponding optional inverseExpression.
Parameters:
inputAttr -
expression -
inverseExpression -

addAttributeExpression

public void addAttributeExpression(java.lang.String inputAttr,
                                   java.lang.String expression,
                                   java.lang.String inverseExpression,
                                   java.lang.String attrSpec)
Defines the expression involving the attribute specified in inputAttr with corresponding optional inverseExpression and attrSpec. The attrSpec field is used to specify additional information and actions for an attribute. You can specify the value NOPREP for attribute_spec.
Parameters:
inputAttr -
expression -
inverseExpression -
attrSpec -
Since:
11.1.0.7

getAttributeExpressionMap

public java.util.Map getAttributeExpressionMap()
Returns a map of the overridden attributes that contains the key as the input attribute name and the value as the OraExpressionElement instance.
Returns:
Map

removeAttributeExpression

public void removeAttributeExpression(java.lang.String inputAttrName)
Removes the specified attribute's OraExpressionElement from the settings.
Parameters:
inputAttrName -

Skip navigation links

Oracle Data Mining Java API Reference
11g Release 2 (11.2)

E12219-03


Copyright © 2005, 2011 Oracle. All rights reserved.