tpch_testdb

test tpch data for experiment

Current data:

120k tpch no skew data

Supported database:

mysql/mariadb
sqlite3

structure

scripts for importing scripts
tbl/tpch120k_tbl for raw tbl tpch 120k data
db
- *.sql: dumps from databases
- *.db: for sqlite3 databse

Usage

MySQL

Directly import *_mysql_dump.sql in db folder.

SQLite3

Directly use *_sqlite3.db in db folder.
Import *_sqlite3_dump.sql in a SQLite database prompt.

Other

TPCH Database Schema

Please read the import script in scripts folder.

Data Distribution of TPCH Database

Please read DistTest.sql in scripts folder. (Originally from TPC-H toolkit.)