TPC-H-Optimization-Project

Lab project of 2020 spring Intro2Database course.

Lab Report (still developing)

性能调优报告_1700017815_张旻昊_1700017802_耿思博_1700017828_胡时京.docx

Data preparation

Create all tables:

Execute create_tables.sql in SQL Server

Load data using Python APIs:

python load_data.py

SQL-Server-styled TPC-H queries:

Execute all_tpch_queries.sql in SQL Server

Optimization codes

All included in per_query_optization/ directory.

The optimization of each query grouped into a .sql file, utilizing techniques including indices, table partition & indexed views.

Add_group.sql performs the operations to add file groups for partitioned data to be saved.