oracle.dmt.odm.data
Class TransactionalDataSpecification

java.lang.Object
  |
  +--oracle.dmt.odm.MiningObject
        |
        +--oracle.dmt.odm.data.PhysicalDataSpecification
              |
              +--oracle.dmt.odm.data.TransactionalDataSpecification

All Implemented Interfaces:

java.io.Serializable

public class TransactionalDataSpecification

extends PhysicalDataSpecification

An instance of TransactionalDataSpecification instructs the DMS to treat associated data as transactional, i.e., a given case is stored in multiple records in a table with column roles: sequenceID, attributeName, and value.

Here is a customer profile table in NonTransactional format:

ID	Name	City	Income
1	John	Boston	45000
2	Andy	Chicago	55000
3	Peter	Orlando	65000

Here is the same table in Transactional format:

SeqId	AttributeName	Value
1	Name	John
1	City	Boston
1	Income	45000
2	Name	Andy
2	City	Chicago
2	Income	55000
3	Name	Peter
3	City	Orlando
3	Income	65000

Since:

9.0.1

See Also:

Serialized Form

Constructor Summary

TransactionalDataSpecification(java.lang.String seqId, java.lang.String attrName, java.lang.String value)
Deprecated. As of 9.2.0, replaced by TransactionalDataSpecification(seqId, attrName, value, LocationAccessData)

TransactionalDataSpecification(java.lang.String seqId, java.lang.String attrName, java.lang.String value, LocationAccessData lad)
Creates an instance of TransactionalDataSpecification with the specified identifier attributes.

Method Summary

Attribute	getAttributeAttribute() Returns an attribute to be used as attribute identifier.
Attribute	getGroupAttribute() Deprecated. As of 9.2.0, group identifier is not supported.
Attribute	getSequenceAttribute() Returns an attribute to be used as sequence identifier.
Attribute	getValueAttribute() Returns an attribute to be used as value identifier.
static TransactionalDataSpecification	restore(Connection dmsConn, java.lang.String pdsName) Restores the user-specified TransactionalDataSpecification object from the DMS.
void	setGroupAttribute(Attribute groupIdIdAttribute) Deprecated. As of 9.2.0, group identifier is not supported.
void	validate() Validates this instance of TransactionalDataSpecification.

Methods inherited from class oracle.dmt.odm.data.PhysicalDataSpecification

getFormat, getLocationAccessData, getName, remove, rename, store

Methods inherited from class java.lang.Object

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

Constructor Detail

TransactionalDataSpecification

public TransactionalDataSpecification(java.lang.String seqId,
                                      java.lang.String attrName,
                                      java.lang.String value)
                               throws InvalidArgumentException,
ODMException

Deprecated. As of 9.2.0, replaced by TransactionalDataSpecification(seqId, attrName, value, LocationAccessData)

Creates an instance of TransactionalDataSpecification with the specified identifier attributes.

Parameters:

seqId - The column name for sequence identifier

attrName - The column name for attribute identifier

value - The column name value identifier

Throws:

InvalidArgumentException - when seqId or attrName is null.

ODMException - when either seqId or attrName is empty or exceed 30 bytes in length.

TransactionalDataSpecification

public TransactionalDataSpecification(java.lang.String seqId,
                                      java.lang.String attrName,
                                      java.lang.String value,
LocationAccessData lad)
                               throws InvalidArgumentException,
ODMException

Creates an instance of TransactionalDataSpecification with the specified identifier attributes.

Parameters:

seqId - The column name for sequence identifier

attrName - The column name for attribute identifier

value - The column name value identifier

lad - The location information of the data

Throws:

InvalidArgumentException - when seqId or attrName is null.

ODMException - when either seqId or attrName is empty or exceed 30 bytes in length.

Since:

9.2.0

Method Detail

validate

public void validate()
              throws MiningObjectException

Validates this instance of TransactionalDataSpecification.

Throws:

MiningObjectException -

• when sequence identifier or attribute identifier is null,
• when sequence identifier is not of int data type,
• when attribute identifier is not of String data type, or
• when value identifier is not of int data type.

getSequenceAttribute

public Attribute getSequenceAttribute()

Returns an attribute to be used as sequence identifier.

Returns:

Attribute - An attribute used as sequence identifier

getAttributeAttribute

public Attribute getAttributeAttribute()

Returns an attribute to be used as attribute identifier.

Returns:

Attribute - An attribute used as attribute identifier

getValueAttribute

public Attribute getValueAttribute()

Returns an attribute to be used as value identifier.

Returns:

Attribute - An attribute used as value identifier

setGroupAttribute

public void setGroupAttribute(Attribute groupIdIdAttribute)

Deprecated. As of 9.2.0, group identifier is not supported.

Set an attribute as the group identifier.

Parameters:

groupIdIdAttribute - An attribute to be used as group identifier

getGroupAttribute

public Attribute getGroupAttribute()

Deprecated. As of 9.2.0, group identifier is not supported.

Returns an attribute to be used for the group identifier.

Returns:

Attribute - An attribute used as group identifier

restore

public static TransactionalDataSpecification restore(Connection dmsConn,
                                                     java.lang.String pdsName)
                                                                  throws InvalidArgumentException,
MiningObjectException,
ODMException,
                                                                         java.sql.SQLException

Restores the user-specified TransactionalDataSpecification object from the DMS.

Parameters:

dmsConn - Data mining server connection

pdsName - Name of the TransactionalDataSpecification

Returns:

TransactionalDataSpecification - restored TransactionalDataSpecification

Throws:

InvalidArgumentException - is thrown
- when the dmsConn or pdsName is null

MiningObjectException - is thrown
- when the restore fails

ODMException - is thrown
- when there is an internal failure

SQLException - is thrown
- when there is a failure in JDBC calls

InvalidArgumentException

MiningObjectException

ODMException

java.sql.SQLException