Author: Paul Motter

LAB 3: Cost-Based Query Optimization

Running

• run the main.py file.

Arguments

defaults are provided for all arguments.

• --r [path to relation json ] Default is "/inputs/relations.json"
• --s [path to statistics json ] Default is "./inputs/statistics.json"
• --q [path to query json] Default is "./queries/Q1.json"

Indexes

The index data structure used is linear hashing.

Indexes are currently made on Student.major, Student.sid, and Enroll.sid. This is defined in the loadIndexes function within the index.py file.