com.rapidminer.example.table
Class IndexCachedDatabaseExampleTable

java.lang.Object
  com.rapidminer.example.table.AbstractExampleTable
      com.rapidminer.example.table.IndexCachedDatabaseExampleTable

All Implemented Interfaces:

ExampleTable, java.io.Serializable

public class IndexCachedDatabaseExampleTable
extends AbstractExampleTable

This class is another data supplier for example sets. For performance reasons one should use a MemoryExampleTable if the data is small enough for the main memory.

Author:

Ingo Mierswa ingomierswa Exp $

See Also:

Serialized Form

Field Summary

static int	DEFAULT_BATCH_SIZE
static java.lang.String	INDEX_COLUMN_NAME
static java.lang.String	MAPPING_TABLE_NAME_PREFIX

Constructor Summary

IndexCachedDatabaseExampleTable(DatabaseHandler databaseHandler, java.lang.String tableName, int dataManagementType, boolean dropMappingTable, LoggingHandler logging)

Method Summary

protected void	createRMPrimaryKeyIndex(DatabaseHandler databaseHandler, java.lang.String tableName, java.lang.String openQuote, java.lang.String closeQuote) Subclasses might want to override this method if they do not support auto_increment.
DataRow	getDataRow(int index) Returns the i-th data row.
DataRowReader	getDataRowReader() Returns an Iterator for example data given as DataRow objects.
int	size() Returns the number of examples.

Methods inherited from class com.rapidminer.example.table.AbstractExampleTable

addAttribute, addAttributes, createExampleSet, createExampleSet, createExampleSet, createExampleSet, createExampleSet, createExampleSet, findAttribute, getAttribute, getAttributeCount, getAttributes, getNumberOfAttributes, removeAttribute, removeAttribute, toDataString, toString

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_BATCH_SIZE

public static final int DEFAULT_BATCH_SIZE

See Also:

Constant Field Values

INDEX_COLUMN_NAME

public static final java.lang.String INDEX_COLUMN_NAME

See Also:

Constant Field Values

MAPPING_TABLE_NAME_PREFIX

public static final java.lang.String MAPPING_TABLE_NAME_PREFIX

See Also:

Constant Field Values

Constructor Detail

IndexCachedDatabaseExampleTable

public IndexCachedDatabaseExampleTable(DatabaseHandler databaseHandler,
                                       java.lang.String tableName,
                                       int dataManagementType,
                                       boolean dropMappingTable,
                                       LoggingHandler logging)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

createRMPrimaryKeyIndex

protected void createRMPrimaryKeyIndex(DatabaseHandler databaseHandler,
                                       java.lang.String tableName,
                                       java.lang.String openQuote,
                                       java.lang.String closeQuote)
                                throws java.sql.SQLException

Subclasses might want to override this method if they do not support auto_increment.

Throws:

java.sql.SQLException

getDataRow

public DataRow getDataRow(int index)

Description copied from interface: ExampleTable

Returns the i-th data row. Calling methods cannot rely on the efficiency of this method. Memory based example tables should return the data row in O(1).

getDataRowReader

public DataRowReader getDataRowReader()

Description copied from interface: ExampleTable

Returns an Iterator for example data given as DataRow objects. This should be used in all cases where iteration is desired. Since ExampleTable.getDataRow(int) does not ensure to work in an efficient way the usage of this method is preferred (instead using for-loops).

size

public int size()

Description copied from interface: ExampleTable

Returns the number of examples.