TPC-H数据导入PG数据库

最新推荐文章于 2024-06-03 14:15:28 发布

置顶

flying-piggy

最新推荐文章于 2024-06-03 14:15:28 发布

阅读量2.4k

点赞数 3

分类专栏： DataBase 文章标签： TPCH PG 数据库数据

本文链接：https://blog.csdn.net/zhu4674548/article/details/54755522

版权

本文介绍TPC-H Benckark装载到PG的方法

0. What is TPCH

TPC- H 主要目的是评价特定查询的决策支持能力，强调服务器在数据挖掘、分析处理方面的能力。查询是决策支持应用的最主要应用之一，数据仓库中的复杂查询可以分成两种类型：一种是预先知道的查询，如定期的业务报表；另一种则是事先未知的查询，称为动态查询（Ad-Hoc Query）。

通俗的讲，TPC-H就是当一家数据库开发商开发了一个新的数据库系统，采用TPC-H作为测试基准，来测试衡量数据库操作系统查询决策支持方面的能力。

The TPC Benchmark™H (TPC-H) is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications. The queries and the data populating the database have been chosen to have broad industry-wide relevance. This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.
– [ TPC-H website]

1. How to generate TPC-H Data

download tpc-h-tool.zip, TPC-H网站下载数据生成工具 dbgen

zhuqingping@ubuntu:~/Study/BenchMark/TPCH$ unzip tpc-h-tool.zip
zhuqingping@ubuntu:~/Study/BenchMark/TPCH$ cd tpch_2_17_0/
zhuqingping@ubuntu:~/Study/BenchMark/TPCH/tpch_2_17_0$ ls
dbgen  dev-tools  ref_data
zhuqingping@ubuntu:~/Study/BenchMark/TPCH/tpch_2_17_0$ cd dbgen/
zhuqingping@ubuntu:~/Study/BenchMark/TPCH/tpch_2_17_0/dbgen$ ls
answers     build.c          dists.dss  dsstypes.h      permute.h      queries    rnd.h         tests     tpch.vcproj
bcd2.c      check_answers    driver.c   HISTORY         PORTING.NOTES  README     rng64.c       text.c    update_release.sh
bcd2.h      column_split.sh  dss.ddl    load_stub.c     print.c        reference  rng64.h       tpcd.h    variants
bm_utils.c  config.h         dss.h      makefile.suite  qgen.c         release.h  shared.h      tpch.dsw  varsub.c
BUGS        dbgen.dsp        dss.ri     permute.c       qgen.vcproj    rnd.c      speed_seed.c  tpch.sln
zhuqingping@ubuntu:~/Study/BenchMark/TPCH/tpch_2_17_0/dbgen$ mv makefile.suite makefile
zhuqingping@ubuntu:~/Study/BenchMark/TPCH/tpch_2_17_0/dbgen$ vi makefile
100 ################
101 ## CHANGE NAME OF ANSI COMPILER HERE
102 ################
103 CC      = gcc
104 # Current values for DATABASE are: INFORMIX, DB2, TDAT (Teradata)
105 #                                  SQLSERVER, SYBASE, ORACLE, VECTORWISE
106 # Current values for MACHINE are:  ATT, DOS, HP, IBM, ICL, MVS, 
107 #                                  SGI, SUN, U2200, VMS, LINUX, WIN32 
108 # Current values for WORKLOAD are:  TPCH
109 DATABASE=ORACLE 
110 MACHINE = LINUX
111 WORKLOAD = TP