[jira] Commented: (DERBY-2095) Add the ability to populate a database for the order entry toolkit based upon the TPC-C specification.

["Sunitha Kambhampati (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-2095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465574 ] 

Sunitha Kambhampati commented on DERBY-2095:
--------------------------------------------

I am attaching a patch (oe.load.p1.diff.txt) for review for the load(population) phase for the Order Entry benchmark.

0)Add interface for Load (oe\client\Load.java) so that the load framework is extensible to have different load 

implementations. 
1)Add the implementation to do the database population using simple insert sql statements per TPC-C specification
Note, this implementation is single threaded. But in future we can add support for  multiple worker threads to do the 

load phase. (oe\load\SimpleInsert.java)
2) Add cardinality checks for all the tables 
3) Add driver that includes performance tests for load phase. (oe\run\Load.java)
4) Add the framework to test the load for a scale of 1 to use it as a functional test. (oe\test\OETest and LoadTester)
5) Remove the earlier skeleton class that loaded only the schema (Load.java is deleted) and instead
Populate.java takes care of providing that functionality. 

svn stat:
A      java\testing\org\apache\derbyTesting\system\oe\load
A      java\testing\org\apache\derbyTesting\system\oe\load\SimpleInsert.java
M      java\testing\org\apache\derbyTesting\system\oe\test\OETest.java
A      java\testing\org\apache\derbyTesting\system\oe\test\LoadTester.java
D      java\testing\org\apache\derbyTesting\system\oe\run\Load.java
A      java\testing\org\apache\derbyTesting\system\oe\run\Populate.java
A      java\testing\org\apache\derbyTesting\system\oe\util
A      java\testing\org\apache\derbyTesting\system\oe\util\OERandom.java
A      java\testing\org\apache\derbyTesting\system\oe\client\Load.java


To run the benchmark:

By default, this test will load schema, create constraints before load, and populate database for a scale of 1 and then 

perform checks on the tables.

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

The test takes the following arguments:
/*
 * Populate class takes in following arguments currently:
 * Usage: java org.apache.derbyTesting.system.oe.run.Populate options
 * Options:
 * <OL>
 * <LI>-scale warehouse scaling factor. Takes a short value. If not specified defaults to 1
 * <LI>-createConstraintsBeforeLoad create constraints before initial load of data, takes a boolean value. If not 

specified, defaults to true
 * <LI>-doChecks check consistency of data, takes a boolean value. If not specified, defaults to true
 * <LI>-help prints usage
 * </OL>
 * 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:
 * <BR>
 * java org.apache.derbyTesting.system.oe.run.Populate -scale 2 -doChecks false -createConstraintsBeforeLoad false
 * <BR>
 */

I plan to add some consistency checks also in another later patch. 

Can someone please take a look at this. 

Thanks,
Sunitha.

> Add the ability to populate a database for the order entry toolkit based upon the TPC-C specification.
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2095
>                 URL: https://issues.apache.org/jira/browse/DERBY-2095
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Test
>            Reporter: Daniel John Debrunner
>         Assigned To: Sunitha Kambhampati
>            Priority: Minor
>         Attachments: oe.load.p1.diff.txt
>
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira