This is a small shell script that generates an SQLite3 database following the TPC-H standard. It uses the official tpch-dbgen tool to generate the data, and then imports it into an sqlite database.

If you don’t want to generate the database yourself, you can download it from the realeases section of this github repo.

• TPC-H.db. This is a conforming TPC-H database with a scale factor of 1. The database file size is 1.17 GB.
• TPC-H-small.db. This database does not conform to the standard, as it has a scale factor of 0.01, but it is much smaller: 11.6 MB.

Clone this repository and its submodule. Then just run make from the root directory of this repo. Be sure to have sqlite3 and a C compiler installed.

git clone --recursive [email protected]:lovasoa/TPCH-sqlite.git
cd TPCH-sqlite
make

This generates an SQLite3 database under the name TPC-H.db.

By default, the database is generated with a scale factor of 1. You can set a different scale factor (SF) with

SCALE_FACTOR=10 make