This repository provides PostgreSQL scripts for generating TPC-H benchmark data, creating database tables, running join experiments, and visualizing data histograms. It's useful for users working with TPC-H data in PostgreSQL for academic, research, or performance analysis.
This module includes scripts to generate TPC-H benchmark data and create the appropriate PostgreSQL tables.
The relavant files are located at ./TPC-H_DataGen.
Scripts to run various SQL joins across TPC-H tables to measure query performance and retrieve meaningful insights from the data.
The relavant files are located at ./Join_Experiment.
This module provides scripts to create histograms for data distribution analysis of specific TPC-H tables.
The relavant files are located at ./Data_Histogram.