org.apache.derbyTesting.system.oe.direct

Class SimpleNonStandardOperations

java.lang.Object

org.apache.derbyTesting.system.oe.direct.StatementHelper

org.apache.derbyTesting.system.oe.direct.SimpleNonStandardOperations

public class SimpleNonStandardOperations
extends StatementHelper

Collection of simple transactions that can be executed against an order-entry database. These are not part of any standard TPC-C specification but are useful for running specific performance tests against Derby. Since they are not standard operations there is no ability to display the information. Any data selected by a query is always fetched by processing all the rows and all the columns using getXXX.

Field Summary

Fields

Modifier and Type	Field and Description
private Address	address
private Customer	customer
private OERandom	rand

Fields inherited from class org.apache.derbyTesting.system.oe.direct.StatementHelper

conn

Constructor Summary

Constructors

Constructor and Description
SimpleNonStandardOperations(java.sql.Connection conn, int isolation)

Method Summary

Modifier and Type	Method and Description
void	customerAddressChange(int scale) Execute customerAddressChange() with random parameters.
void	customerAddressChange(short w, short d, int c) Update a customers address with a new random value.
void	customerInquiry(int scale) Execute customerInquiry() with random parameters.
void	customerInquiry(short w, short d, int c) Lookup a customer's information (name, address, balance) fetching it by the identifier.
static SimpleNonStandardOperations	noReset(java.sql.Connection conn, int isolation) Return an SimpleNonStandardOperations implementation based upon SimpleNonStandardOperations with a single difference.

Methods inherited from class org.apache.derbyTesting.system.oe.direct.StatementHelper

close, getAddress, getAddress, prepareStatement, reset

Methods inherited from class java.lang.Object

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

Field Detail

customer

private final Customer customer

address

private final Address address

rand

private final OERandom rand

Constructor Detail

SimpleNonStandardOperations

public SimpleNonStandardOperations(java.sql.Connection conn,
                                   int isolation)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

noReset

public static SimpleNonStandardOperations noReset(java.sql.Connection conn,
                                                  int isolation)
                                           throws java.sql.SQLException

Return an SimpleNonStandardOperations implementation based upon SimpleNonStandardOperations with a single difference. In this implementation the reset() executed after each PreparedStatement execute does nothing. Sees if there is any performance impact of explicitly closing each ResultSet and clearing the parameters.

Each ResultSet will be closed implicitly either at commit time or at the next execution of the same PreparedStatement object.

Throws:

java.sql.SQLException

customerInquiry

public void customerInquiry(int scale)
                     throws java.sql.SQLException

Execute customerInquiry() with random parameters.

Throws:

java.sql.SQLException

customerInquiry

public void customerInquiry(short w,
                            short d,
                            int c)
                     throws java.sql.SQLException

Lookup a customer's information (name, address, balance) fetching it by the identifier.
Primary key lookup against the CUSTOMER table (which of course can be arbitrarily large depending on the scale of the database. The cardinality of the CUSTOMER is 30,000 rows per warehouse, for example with a 20 warehouse system this test would perform a primary key lookup against 600,000 rows.

Parameters:

w - Warehouse for customer

d - District for customer

c - Customer identifier

Throws:

java.sql.SQLException

customerAddressChange

public void customerAddressChange(int scale)
                           throws java.sql.SQLException

Execute customerAddressChange() with random parameters.

Throws:

java.sql.SQLException

customerAddressChange

public void customerAddressChange(short w,
                                  short d,
                                  int c)
                           throws java.sql.SQLException

Update a customers address with a new random value. Update of a single row through a primary key.
Primary key update against the CUSTOMER table (which of course can be arbitrarily large depending on the scale of the database. The cardinality of the CUSTOMER is 30,000 rows per warehouse, for example with a 20 warehouse system this test would perform a primary key lookup against 600,000 rows.

Parameters:

w - Warehouse for customer

d - District for customer

c - Customer identifier

Throws:

java.sql.SQLException