Differences

This shows you the differences between two versions of the page.

Link to this comparison view

public:tpc-ds_benchmark [2012/12/14 16:25]
kohofer created
public:tpc-ds_benchmark [2019/01/16 10:03]
Line 1: Line 1:
-====== TPC-DS Benchmark How To Guide ====== 
  
-Commands: 
- 
-Create Oracle user tpcds 
- 
-  SQL> create user tpcds with password '​ffgfh';​ 
- 
-Generate load data 
- 
-  * mkdir /tmp/tpc 
-  * dsdgen -scale 1 -dir /tmp/tpc 
- 
-Load data 
- 
-  * su - oracle 
-  * mkdir tpcds 
- 
-Create control file: 
- 
-  * vi web_site.ctl 
- 
-<​code>​ 
-load data 
-infile '/​tmp/​tpc/​web_site.dat'​ 
-into table web_site 
-fields terminated by '​|'​ 
-( WEB_SITE_SK,​ WEB_SITE_ID,​ WEB_REC_START_DATE date "​YYYY-MM-DD",​ WEB_REC_END_DATE date "​YYYY-MM-DD",​ WEB_NAME, WE 
-B_OPEN_DATE_SK,​ WEB_CLOSE_DATE_SK,​ WEB_CLASS, WEB_MANAGER,​ WEB_MKT_ID, WEB_MKT_CLASS,​ WEB_MKT_DESC,​ WEB_MARKET_MAN 
-AGER, WEB_COMPANY_ID,​ WEB_COMPANY_NAME,​ WEB_STREET_NUMBER,​ WEB_STREET_NAME,​ WEB_STREET_TYPE,​ WEB_SUITE_NUMBER,​ WEB 
-_CITY, WEB_COUNTY, WEB_STATE, WEB_ZIP, WEB_COUNTRY,​ WEB_GMT_OFFSET,​ WEB_TAX_PERCENTAGE ) 
-</​code>​ 
- 
-Import the data using Oracle Loader 
- 
-  * sqlldr tpcds/​tpcds_1234 control=web_site.ctl 
- 
- 
-===== Links ===== 
- 
- 
-[[http://​www.tpc.org/​tpcds/​default.asp]]\\ 
-[[http://​agni.csa.iisc.ernet.in/​CASL/​tpcds]]\\ 
-[[http://​www.orafaq.com/​wiki/​SQL*Loader_FAQ]] 
/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