【IT168 技术】
1.首先从MonetDB官方网站下载安装包,根据安装说明安装MonetDB.
2.从TPC-H.org 下载DBGEN and QGEN程序以及参考输入集。
3.在linux上安装DBGEN和QGEN程序,解压开tpch_20100211.tar.gz
4.解压开压缩包后,需要根据自己的平台,生成makefile文件。我的Makefile文件如下:
Revision 1.2 2004/02/18 14:05:53 jms
# porting changes for LINUX and 64 bit RNG
#
# Revision 1.1.1.1 2003/04/03 18:54:21 jms
# recreation after CVS crash
# Revision 1.1.1.1 2003/04/03 18:54:21 jms
# initial checkin
################
## CHANGE NAME OF ANSI COMPILER HERE
################
CC =gcc
# Current values for DATABASE are: INFORMIX, DB2, TDAT (Teradata)
# SQLSERVER, SYBASE
# Current values for MACHINE are: ATT, DOS, HP, IBM, ICL, MVS,
# SGI, SUN, U2200, VMS, LINUX, WIN32
# Current values for WORKLOAD are: TPCH
DATABASE=TDAT
MACHINE = LINUX
WORKLOAD = TPCH
#
# add -EDTERABYTE if orderkey will execeed 32 bits (SF >= 300)
.....(下边没有变动)
# porting changes for LINUX and 64 bit RNG
#
# Revision 1.1.1.1 2003/04/03 18:54:21 jms
# recreation after CVS crash
# Revision 1.1.1.1 2003/04/03 18:54:21 jms
# initial checkin
################
## CHANGE NAME OF ANSI COMPILER HERE
################
CC =gcc
# Current values for DATABASE are: INFORMIX, DB2, TDAT (Teradata)
# SQLSERVER, SYBASE
# Current values for MACHINE are: ATT, DOS, HP, IBM, ICL, MVS,
# SGI, SUN, U2200, VMS, LINUX, WIN32
# Current values for WORKLOAD are: TPCH
DATABASE=TDAT
MACHINE = LINUX
WORKLOAD = TPCH
#
# add -EDTERABYTE if orderkey will execeed 32 bits (SF >= 300)
.....(下边没有变动)
5.运行DBgen –s 1 生成scale factor为1的数据集,此时在当前目录下生成8个.tbl文件。