1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
/*
*
* Derby - Class org.apache.derbyTesting.system.oe.client.Load
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
* either express or implied. See the License for the specific
* language governing permissions and limitations under the License.
*/
package org.apache.derbyTesting.system.oe.client;
import java.sql.Connection;
import java.sql.SQLException;
/**
* 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
* <OL>
* <LI> Use the setupLoad to perform any necessary initialization for the load
* phase
* <LI> Load data into all the tables
* </OL>
* <P>
* DECIMAL values are represented as String objects to allow Order Entry to be
* run on J2ME/CDC/Foundation which does not support BigDecimal.
*/
public interface Load {
/**
* 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
*/
public static final short DISTRICT_COUNT_W = 10;
public static final int CUSTOMER_COUNT_W = 3000 * DISTRICT_COUNT_W;
public static final int ITEM_COUNT = 100000;
public static final int NEWORDERS_COUNT_W = (CUSTOMER_COUNT_W * 9) / 30;
// 1 per customer initially
public static final int HISTORY_COUNT_W = CUSTOMER_COUNT_W;
public static final int STOCK_COUNT_W = ITEM_COUNT;
public static final int ORDERS_COUNT_W = CUSTOMER_COUNT_W;
// 5 to 15 , per order. so average 10
public static final int ORDERLINE_COUNT_WV = ORDERS_COUNT_W * 10;
public static final int NEWORDERS_BREAKPOINT =
(ORDERS_COUNT_W - NEWORDERS_COUNT_W)/ DISTRICT_COUNT_W;
/**
* 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.
* @param seed
*/
public void setSeed(long seed);
/**
* Perform the necessary setup before database population.
* @param conn - database connection
* @param scale - scale of the database. The WAREHOUSE table is
* used as the base unit of scaling.
* @throws Exception
*/
public void setupLoad(Connection conn, short scale) throws Exception;
/**
* 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.
*
* @param threadCount Number of threads to use if loading supports
* multiple threading.
*/
public void setThreadCount(int threadCount);
/**
* 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 SQLException
*/
public void populateAllTables() throws Exception;
}
|
