<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="19. TPC C Benchmark Kit" />
<meta name="dc.subject" content="19. TPC C Benchmark Kit" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="tpcc.html" title="Chapter Contents" />
<link rel="prev" href="tpccprocs.html" title="TPC C Procedures" />
<link rel="next" href="storedprocs.html" title="Stored Procedures" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>19. TPC C Benchmark Kit</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="ddlstmt" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>19. TPC C Benchmark Kit</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="tpcc.html">Chapter Contents</a> | <a class="link" href="tpccprocs.html" title="TPC C Procedures">Prev</a> | <a class="link" href="storedprocs.html" title="Stored Procedures">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div class="selected">
<a href="tpcc.html">TPC C Benchmark Kit</a>
</div>
<br />
<div>
<a href="tpcctestdb.html">Building the Test Database</a>
</div>
<div>
<a href="tpccusingtestprg.html">Using the Test Program</a>
</div>
<div>
<a href="tpcctuningparams4users.html">Tuning Parameters and Number of Users</a>
</div>
<div>
<a href="omissionsexcp.html">Omissions, Exceptions from the Definition</a>
</div>
<div>
<a href="sampleconf.html">Sample Configuration</a>
</div>
<div>
<a href="otherfactors.html">Other Factors</a>
</div>
<div>
<a href="tpccprocs.html">TPC C Procedures</a>
</div>
<div class="selected">
<a href="ddlstmt.html">DDL Statements</a>
</div>
<div>
<a href="storedprocs.html">Stored Procedures</a>
</div>
<br />
</div>
<div id="text">
<a name="ddlstmt" />
<h2>19.8. DDL Statements</h2>
<div>
<pre class="programlisting">
--
-- tpccddk.sql
--
-- Implementation of the TPC C Benchmark transactions as stored procedures.
--
-- These are for use with the tpcc test driver (tpcc) in the Virtuoso sample
-- directory. See TPCC.DOC in the virtuoso documentation bundle for comments
-- and instructions.
--
-- This file is part of the OpenLink Software Virtuoso Open-Source (VOS)
-- project.
--
-- Copyright (C) 1998-2010 OpenLink Software
--
-- This project is free software; you can redistribute it and/or modify it
-- under the terms of the GNU General Public License as published by the
-- Free Software Foundation; only version 2 of the License, dated June 1991.
--
-- This program is distributed in the hope that it will be useful, but
-- WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
-- General Public License for more details.
--
-- You should have received a copy of the GNU General Public License along
-- with this program; if not, write to the Free Software Foundation, Inc.,
-- 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
--
CREATE TABLE WAREHOUSE (
W_ID INTEGER,
W_NAME CHARACTER (10),
W_STREET_1 CHARACTER (20),
W_STREET_2 CHARACTER (20),
W_CITY CHARACTER (20),
W_STATE CHARACTER (2),
W_ZIP CHARACTER (9),
W_TAX NUMERIC,
W_YTD NUMERIC,
PRIMARY KEY (W_ID)
);
CREATE TABLE DISTRICT (
D_ID INTEGER,
D_W_ID INTEGER,
D_NAME CHARACTER (10),
D_STREET_1 CHARACTER (20),
D_STREET_2 CHARACTER (20),
D_CITY CHARACTER (20),
D_STATE CHARACTER (2),
D_ZIP CHARACTER (9),
D_TAX NUMERIC,
D_YTD NUMERIC,
D_NEXT_O_ID INTEGER,
PRIMARY KEY (D_W_ID, D_ID)
);
CREATE TABLE CUSTOMER (
C_ID INTEGER,
C_D_ID INTEGER,
C_W_ID INTEGER,
C_FIRST CHARACTER (16),
C_MIDDLE CHARACTER (2),
C_LAST VARCHAR,
C_STREET_1 CHARACTER (20),
C_STREET_2 CHARACTER (20),
C_CITY CHARACTER (20),
C_STATE CHARACTER (2),
C_ZIP CHARACTER (9),
C_PHONE CHARACTER (16),
C_SINCE VARCHAR,
C_CREDIT CHARACTER (2),
C_CREDIT_LIM NUMERIC,
C_DISCOUNT NUMERIC,
C_BALANCE NUMERIC,
C_YTD_PAYMENT NUMERIC,
C_CNT_PAYMENT NUMERIC,
C_CNT_DELIVERY NUMERIC,
C_DATA_1 CHARACTER (250),
C_DATA_2 CHARACTER (250),
PRIMARY KEY (C_W_ID, C_D_ID, C_ID)
);
CREATE INDEX C_BY_LAST ON CUSTOMER (C_W_ID, C_D_ID, C_LAST, C_FIRST);
CREATE TABLE HISTORY (
H_C_ID INTEGER,
H_C_D_ID INTEGER,
H_C_W_ID INTEGER,
H_D_ID INTEGER,
H_W_ID INTEGER,
H_DATE DATE,
H_AMOUNT NUMERIC,
H_DATA CHARACTER (24),
PRIMARY KEY (H_DATE, H_C_ID)
);
CREATE TABLE NEW_ORDER (
NO_O_ID INTEGER,
NO_D_ID INTEGER,
NO_W_ID INTEGER,
PRIMARY KEY (NO_W_ID, NO_D_ID, NO_O_ID)
);
CREATE TABLE ORDERS (
O_ID INTEGER,
O_D_ID INTEGER,
O_W_ID INTEGER,
O_C_ID INTEGER,
O_ENTRY_D DATE,
O_CARRIER_ID INTEGER,
O_OL_CNT INTEGER,
O_ALL_LOCAL NUMERIC,
PRIMARY KEY (O_W_ID, O_D_ID, O_ID)
);
CREATE INDEX O_BY_C_ID ON ORDERS (O_W_ID, O_D_ID, O_C_ID, O_ID)
CREATE TABLE ORDER_LINE (
OL_O_ID INTEGER,
OL_D_ID INTEGER,
OL_W_ID INTEGER,
OL_NUMBER INTEGER,
OL_I_ID INTEGER,
OL_SUPPLY_W_ID INTEGER,
OL_DELIVERY_D DATE,
OL_QUANTITY NUMERIC,
OL_AMOUNT NUMERIC,
OL_DIST_INFO CHARACTER (24),
PRIMARY KEY (OL_W_ID, OL_D_ID, OL_O_ID, OL_NUMBER)
);
CREATE TABLE ITEM (
I_ID INTEGER,
I_IM_ID INTEGER,
I_NAME CHARACTER (24),
I_PRICE NUMERIC,
I_DATA CHARACTER (50),
PRIMARY KEY (I_ID)
);
CREATE TABLE STOCK (
S_I_ID INTEGER,
S_W_ID INTEGER,
S_QUANTITY NUMERIC,
S_DIST_01 CHARACTER (24),
S_DIST_02 CHARACTER (24),
S_DIST_03 CHARACTER (24),
S_DIST_04 CHARACTER (24),
S_DIST_05 CHARACTER (24),
S_DIST_06 CHARACTER (24),
S_DIST_07 CHARACTER (24),
S_DIST_08 CHARACTER (24),
S_DIST_09 CHARACTER (24),
S_DIST_10 CHARACTER (24),
S_YTD NUMERIC,
S_CNT_ORDER NUMERIC,
S_CNT_REMOTE NUMERIC,
S_DATA CHARACTER (50),
PRIMARY KEY (S_I_ID, S_W_ID)
);
</pre>
</div>
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="tpccprocs.html" title="TPC C Procedures">Previous</a>
<br />TPC C Procedures</td>
<td align="center" width="34%">
<a href="tpcc.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="storedprocs.html" title="Stored Procedures">Next</a>
<br />Stored Procedures</td>
</tr>
</table>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
80
