/*
* $Id: README.txt,v 1.4 2006/08/07 17:36:46 jms Exp $
*/
1. Goal
This document summarizes the steps required to validate the data set generated
by DBGEN, relative to the reference data published by the TPC.
2. Pre-Requesites
Toolset executable: This readme file is included as part of the toolset
distributed by the TPC. The DBGEN and QGEN executables must be built from
the same distribution.
Reference Data Set(s): For each permissible scale factor, the TPC has
produced a separate zip file that defines the reference point for the base
data set, the update data set, and the output of QGEN. These must be
downloaded separately from the TPC web site.
3. Validation Process
a. Setup
The commands that are included in this distribution assume that they are
being executed from <DBGEN>/reference, where <DBGEN> is directory into which
the DBGEN distribution was unpacked. If that is not the case for your
environemnt, the paths to executables and associated files will need to be
edited to match your directory structure.
b. Base Data Validation
The base data set is produced using cmd_base_sf<n> where <n> is the scale
factor to be generated. The resulting files will be produced in the current
working directory. The generated files will be of the form <name>.tbl.<nnn>,
where <name> will is the name of one of the tables in the TPCH schema, and
<nnn> identifies a particular data generation step.
The file set produced by genbaserefdata.sh should match the <name>.tbl.<nnn>
files found in the reference data set for the same scale factor.
c. Update Data Validation
The update data set is produced using cmd_update_sf<n> where <n> is the scale
factor to be generated. The resulting files will be produced in the current
working directory. The generated files will be of the form
<name>.tbl.u<mmm>.<nnn> and delete.u<nnn>.<mmm>, where <name> will is the
name of one of the tables in the TPCH schema, and <mmm> and <nnn> identify
a particular data generation step.
For each file produced by DBGEN, the first 100 lines of the file should
match the delete.tbl.u<nnn>.<mmm> and <name>.tbl.u<nnn>.<mmm> files found in the
reference data set. Where the files from the reference data set contain
fewer than 100 lines, the file should match in their entriety.
d. QGEN Parameter Generation
The qgen paramter sets are produced using the cmd_qgen_sf<n> files, where
<n> matches the scale factor being validated. The resulting files will
be produced in the current working directory. The generated files will be of
the form subparam_<nnn>, where <nnn> identifies a particular qgen subsituttion
set.
The file set produced by cmd_qgen_<sf> script should match the subparam.<nnn>
files found in the reference data set.
/*********************
* Revision History
* ===================
* $Log: README.txt,v $
* Revision 1.4 2006/08/07 17:36:46 jms
* typo corrections
*
* Revision 1.3 2006/03/30 22:12:36 jms
* reduce to simple scripts
*
没有合适的资源?快使用搜索试试~ 我知道了~
TPC-H-Tools 2.18.0_rc2
共2000个文件
1:120个
64:73个
32:73个
需积分: 5 47 下载量 41 浏览量
2019-03-03
12:48:03
上传
评论
收藏 24.69MB ZIP 举报
温馨提示
TPC-H-Tools 2.18.0_rc2含dbgen,dev-tools,ref_data三个文件夹,EULA.txt,specification.docx和specification.pdf.
资源推荐
资源详情
资源评论
收起资源包目录
TPC-H-Tools 2.18.0_rc2 (2000个子文件)
lineitem.tbl.1 40KB
customer.tbl.1 16KB
customer.tbl.1 16KB
customer.tbl.1 16KB
customer.tbl.1 16KB
customer.tbl.1 16KB
customer.tbl.1 16KB
customer.tbl.1 16KB
customer.tbl.1 16KB
partsupp.tbl.1 15KB
partsupp.tbl.1 15KB
partsupp.tbl.1 15KB
partsupp.tbl.1 15KB
partsupp.tbl.1 15KB
partsupp.tbl.1 14KB
partsupp.tbl.1 14KB
partsupp.tbl.1 14KB
lineitem.tbl.u150.1 14KB
lineitem.tbl.u150.1 14KB
lineitem.tbl.u75.1 14KB
lineitem.tbl.u150.1 14KB
supplier.tbl.1 13KB
supplier.tbl.1 13KB
supplier.tbl.1 13KB
supplier.tbl.1 13KB
supplier.tbl.1 13KB
supplier.tbl.1 13KB
supplier.tbl.1 13KB
supplier.tbl.1 13KB
lineitem.tbl.u150.1 13KB
lineitem.tbl.u75.1 13KB
lineitem.tbl.u75.1 13KB
lineitem.tbl.u150.1 13KB
lineitem.tbl.u150.1 13KB
lineitem.tbl.u75.1 13KB
lineitem.tbl.u75.1 13KB
lineitem.tbl.u75.1 13KB
lineitem.tbl.u1.1 13KB
lineitem.tbl.u75.1 13KB
lineitem.tbl.u1.1 13KB
lineitem.tbl.u150.1 13KB
lineitem.tbl.u1.1 13KB
lineitem.tbl.u1.1 12KB
lineitem.tbl.u1.1 12KB
lineitem.tbl.u1.1 12KB
lineitem.tbl.u1.1 12KB
lineitem.tbl.1 12KB
lineitem.tbl.1 12KB
orders.tbl.u75.1 12KB
lineitem.tbl.1 12KB
orders.tbl.u150.1 12KB
orders.tbl.u150.1 12KB
lineitem.tbl.1 12KB
orders.tbl.u75.1 12KB
lineitem.tbl.1 12KB
orders.tbl.u150.1 12KB
orders.tbl.u75.1 12KB
orders.tbl.u150.1 12KB
lineitem.tbl.1 12KB
orders.tbl.u150.1 12KB
orders.tbl.u150.1 12KB
orders.tbl.u75.1 12KB
orders.tbl.u75.1 12KB
orders.tbl.1 12KB
orders.tbl.1 12KB
orders.tbl.1 12KB
orders.tbl.u75.1 11KB
orders.tbl.u1.1 11KB
orders.tbl.1 11KB
orders.tbl.u1.1 11KB
lineitem.tbl.1 11KB
orders.tbl.1 11KB
orders.tbl.u1.1 11KB
part.tbl.1 11KB
part.tbl.1 11KB
part.tbl.1 11KB
part.tbl.1 11KB
part.tbl.1 11KB
part.tbl.1 11KB
part.tbl.1 11KB
part.tbl.1 11KB
orders.tbl.1 11KB
orders.tbl.u1.1 11KB
orders.tbl.1 11KB
orders.tbl.u1.1 11KB
orders.tbl.u75.1 11KB
orders.tbl.u150.1 11KB
orders.tbl.1 11KB
orders.tbl.u1.1 11KB
orders.tbl.u1.1 11KB
lineitem.tbl.u75.1 8KB
lineitem.tbl.u150.1 7KB
lineitem.tbl.u1.1 6KB
orders.tbl.u150.1 2KB
orders.tbl.u75.1 2KB
orders.tbl.u1.1 2KB
delete.u75.1 1KB
delete.u150.1 1KB
delete.u75.1 1KB
delete.u150.1 1KB
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
iteapoy
- 粉丝: 1299
- 资源: 11
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功