org.apache.derbyTesting.system.oe.client

Interface Load

All Known Implementing Classes:

SimpleInsert, ThreadInsert

public interface Load

Interface for a client to populate the database. Various implementations can be provided, e.g. via SQL, via VTI, via import etc An implementation for Load must be able to do the following

1. Use the setupLoad to perform any necessary initialization for the load phase
2. Load data into all the tables

DECIMAL values are represented as String objects to allow Order Entry to be run on J2ME/CDC/Foundation which does not support BigDecimal.

Field Summary

Fields

Modifier and Type	Field and Description
static int	CUSTOMER_COUNT_W
static short	DISTRICT_COUNT_W Cardinality constants These numbers are factored by W, the number of Warehouses, to illustrate the database scaling.
static int	HISTORY_COUNT_W
static int	ITEM_COUNT
static int	NEWORDERS_BREAKPOINT
static int	NEWORDERS_COUNT_W
static int	ORDERLINE_COUNT_WV
static int	ORDERS_COUNT_W
static int	STOCK_COUNT_W

Method Summary

Modifier and Type	Method and Description
void	populateAllTables() Follow the initial database population requirements in Section 4.3.3 and populate all the required tables.
void	setSeed(long seed) Set the seed for the random number generator used to populate the data.
void	setThreadCount(int threadCount) Set the number of total threads the loader is allowed to use to load data.
void	setupLoad(java.sql.Connection conn, short scale) Perform the necessary setup before database population.

Field Detail

DISTRICT_COUNT_W

static final short DISTRICT_COUNT_W

Cardinality constants These numbers are factored by W, the number of Warehouses, to illustrate the database scaling. see section 1.2.1 of TPC-C specification

See Also:

Constant Field Values

CUSTOMER_COUNT_W

static final int CUSTOMER_COUNT_W

See Also:

Constant Field Values

ITEM_COUNT

static final int ITEM_COUNT

See Also:

Constant Field Values

NEWORDERS_COUNT_W

static final int NEWORDERS_COUNT_W

See Also:

Constant Field Values

HISTORY_COUNT_W

static final int HISTORY_COUNT_W

See Also:

Constant Field Values

STOCK_COUNT_W

static final int STOCK_COUNT_W

See Also:

Constant Field Values

ORDERS_COUNT_W

static final int ORDERS_COUNT_W

See Also:

Constant Field Values

ORDERLINE_COUNT_WV

static final int ORDERLINE_COUNT_WV

See Also:

Constant Field Values

NEWORDERS_BREAKPOINT

static final int NEWORDERS_BREAKPOINT

See Also:

Constant Field Values

Method Detail

setSeed

void setSeed(long seed)

Set the seed for the random number generator used to populate the data. Useful for testing to ensure consistent repeatable runs. If not set, defaults a value based upon current time. Must be called before setupLoad to have an effect.

Parameters:

seed -

setupLoad

void setupLoad(java.sql.Connection conn,
               short scale)
        throws java.lang.Exception

Perform the necessary setup before database population.

Parameters:

conn - - database connection

scale - - scale of the database. The WAREHOUSE table is used as the base unit of scaling.

Throws:

java.lang.Exception

setThreadCount

void setThreadCount(int threadCount)

Set the number of total threads the loader is allowed to use to load data. If an implementation does not support multiple threads then the passed in value will be ignored.

Parameters:

threadCount - Number of threads to use if loading supports multiple threading.

populateAllTables

void populateAllTables()
                throws java.lang.Exception

Follow the initial database population requirements in Section 4.3.3 and populate all the required tables. BE CAREFUL to use the correct starting identifiers for the data in the tables. In the specification, identifiers start at 1 (one), e.g. 1-10 for a district and is not zero based.

Throws:

java.sql.SQLException

java.lang.Exception