TPC-DS Benchmark How To Guide

Commands:

Create Oracle user TPCDS

 SQL> CREATE USER "TPCDS" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED ON "USERS" ACCOUNT UNLOCK GRANT CREATE TABLE TO "TPCDS" GRANT "CONNECT" TO "TPCDS";

Get DSGen and unpack

Compile/build binaries

  • cp tools/Makefile.suite tools/Makefile
  • cat tools/Makefile | grep ^OS

| * Result should be: OS | = | LINUX |

  • cd tools
  • make

Generate load data

  • mkdir /tmp/tpc
  • ./dsdgen -scale 1 -dir /tmp/tpc

Import tables into Oracle

  • su - oracle
  • cd /tmp/dsgen/tools
  • sqlplus tpcds/* @tpcds.sql
  • sqlplus tpcds/* @tpcds_source.sql

Load data

  • su - oracle
  • mkdir tpc-ds
  • cd tpc-ds

Prepare control files:

  • vi call_center.ctl
call_center.ctl

  • vi catalog_page.ctl
catalog_page.ctl

  • vi catalog_returns.ctl
catalog_page.ctl

  • vi catalog_sales.ctl
catalog_sales.ctl

  • vi customer_address.ctl
customer_address.ctl

  • vi customer.ctl
customer.ctl

  • vi customer_demographics.ctl
customer_demographics.ctl

  • vi date_dim.ctl
date_dim.ctl

  • vi dbgen_version.ctl
dbgen_version.ctl

  • vi household_demographics.ctl
household_demographics.ctl

  • vi income_band.ctl
income_band.ctl

  • vi inventory.ctl
inventory.ctl

  • vi item.ctl
item.ctl

  • vi promotion.ctl
promotion.ctl

  • vi reason.ctl
reason.ctl

  • vi ship_mode.ctl
ship_mode.ctl

  • vi store.ctl
store.ctl

  • vi store_returns.ctl
store_returns.ctl

  • vi store_sales.ctl
store_sales.ctl

  • vi time_dim.ctl
time_dim.ctl

  • vi warehouse.ctl
warehouse.ctl

  • vi web_page.ctl
web_page.ctl

  • vi web_returns.ctl
web_returns.ctl

  • vi web_sales.ctl
web_sales.ctl

  • vi web_site.ctl
web_site.ctl

Import the data using Oracle Loader

  • sqlldr tpcds/* control=call_center.ctl
  • sqlldr tpcds/* control=catalog_page.ctl
  • sqlldr tpcds/* control=catalog_returns.ctl
  • sqlldr tpcds/* control=catalog_sales.ctl
  • sqlldr tpcds/* control=customer_address.ctl
  • sqlldr tpcds/* control=customer.ctl
  • sqlldr tpcds/* control=customer_demographics.ctl
  • sqlldr tpcds/* control=date_dim.ctl
  • sqlldr tpcds/* control=dbgen_version.ctl
  • sqlldr tpcds/* control=household_demographics.ctl
  • sqlldr tpcds/* control=income_band.ctl
  • sqlldr tpcds/* control=inventory.ctl
  • sqlldr tpcds/* control=item.ctl
  • sqlldr tpcds/* control=promotion.ctl
  • sqlldr tpcds/* control=reason.ctl
  • sqlldr tpcds/* control=ship_mode.ctl
  • sqlldr tpcds/* control=store.ctl
  • sqlldr tpcds/* control=store_returns.ctl
  • sqlldr tpcds/* control=store_sales.ctl
  • sqlldr tpcds/* control=time_dim.ctl
  • sqlldr tpcds/* control=warehouse.ctl
  • sqlldr tpcds/* control=web_page.ctl
  • sqlldr tpcds/* control=web_returns.ctl
  • sqlldr tpcds/* control=web_sales.ctl
  • sqlldr tpcds/* control=web_site.ctl
/var/www/wiki.inf.unibz.it/data/pages/public/tpc-ds_benchmark.txt · Last modified: 2019/01/16 10:03 (external edit)
CC Attribution-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0