org.apache.derbyTesting.system.oe.run

Class Populate

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.junit.JDBCPerfTestCase

org.apache.derbyTesting.system.oe.run.Populate

All Implemented Interfaces:

junit.framework.Test

public class Populate
extends JDBCPerfTestCase

Driver to do the load phase for the Order Entry benchmark. This class takes in following arguments currently: Usage: java org.apache.derbyTesting.system.oe.run.Populate options Options:

1. -scale warehouse scaling factor. Takes a short value. If not specified defaults to 1
2. -createConstraintsBeforeLoad create constraints before initial load of data, takes a boolean value. If not specified, defaults to true
3. -doChecks check consistency of data, takes a boolean value. If not specified, defaults to true
4. -loaderThreads Number of threads to populate tables, defaults to number of cores
5. -help prints usage

To load database with scale of 2, to load constraints after the population, and to not do any checks, the command to run the test is as follows:
java org.apache.derbyTesting.system.oe.run.Populate -scale 2 -doChecks false -createConstraintsBeforeLoad false
This class uses the junit performance framework in Derby and the tests the performance of the following operations.

1. create schema with or without constraints (configurable)
2. populate the schema
3. Check the cardinality of the tables.

Field Summary

Fields

Modifier and Type	Field and Description
private static boolean	createConstraintsBeforeLoad flag to indicate if we should create constraints before loading data
private static boolean	doChecks flag to indicate if we should perform consistency, cardinality checks after the load
(package private) static int	loaderThreads Number of threads to load the data.
(package private) static short	scale Warehouse scale factor

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
Populate(java.lang.String name) Create a test case with the given name.

Method Summary

Modifier and Type	Method and Description
static void	main(java.lang.String[] args) Run OE load
(package private) static void	parseArgs(java.lang.String[] args) parse arguments.
private static void	printUsage()
static junit.framework.Test	suite() junit tests to do the OE load.
void	testCreateDB()
void	testLoad() test the initial database load

Methods inherited from class org.apache.derbyTesting.junit.JDBCPerfTestCase

runBareOverridable, runTest

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, setName, setUp, toString

Methods inherited from class java.lang.Object

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

Field Detail

scale

static short scale

Warehouse scale factor

loaderThreads

static int loaderThreads

Number of threads to load the data.

createConstraintsBeforeLoad

private static boolean createConstraintsBeforeLoad

flag to indicate if we should create constraints before loading data

doChecks

private static boolean doChecks

flag to indicate if we should perform consistency, cardinality checks after the load

Constructor Detail

Populate

public Populate(java.lang.String name)

Create a test case with the given name.

Parameters:

name - of the test case.

Method Detail

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception

Run OE load

Parameters:

args - supply arguments for benchmark.

Throws:

java.lang.Exception

parseArgs

static void parseArgs(java.lang.String[] args)

parse arguments.

Parameters:

args - arguments to parse

printUsage

private static void printUsage()

suite

public static junit.framework.Test suite()

junit tests to do the OE load.

Returns:

the tests to run

testCreateDB

public void testCreateDB()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testLoad

public void testLoad()
              throws java.lang.Exception

test the initial database load

Throws:

java.lang.Exception