Examples in this guide and in the
Quickstart use the
database, which is an ad-hoc decision support database derived
from the TPC Benchmark™ H
(TPC-H) specification. For an overview of the
tpch schema, refer to the Logical
Database Design section of the
Quickstart describes how to create the
tpch schema and tables and load
tpch sample data. The following instructions
describe how to generate
tpch sample data using
dbgen utility. The instructions assume you
are on a Linux system that has
make libraries installed.
tpch sample data:
Download the TPC-H tools zip file from TPC Download Current.
Extract the zip file to a location on your system.
Change to the
dbgendirectory and make a copy of the makefile template.
$ cd 2.18.0/dbgen $ cp makefile.suite makefile
Configure the following settings in the makefile:
CC = gcc DATABASE= ORACLE MACHINE = LINUX WORKLOAD = TPCH
Run make to build the
Issue the following
dbgencommand to generate a 1GB set of data files for the
$ ./dbgen -s 1
The operation may take a few minutes. When finished, the following data files appear in the working directory, one for each table in the
$ ls -1 *.tbl customer.tbl lineitem.tbl nation.tbl orders.tbl partsupp.tbl part.tbl region.tbl supplier.tbl