Examples in this Quickstart use the
sample database, which is an ad-hoc decision support database
derived from the TPC
Benchmark™ H (TPC-H) specification. For an overview
tpch schema, refer to the
Logical Database Design section of the
The following instructions describe how to generate
tpch sample data using the
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