Skip to content

README.md

Latest commit

 

History

History
18 lines (12 loc) · 616 Bytes

README.md

File metadata and controls

18 lines (12 loc) · 616 Bytes

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.