v1 (9/18/2022)

Execution

To execute our application, run the command below with the input folder following the structure shown below and the destination folder, which will have the results of all the queries made, each in their own file corresponding to the line numbers in queries.sql.

java -jar [jar-file-name] [absolute-or-relative-path-of-inputs] [absolute-or-relative-path-of-outputs]

Inputs

The input folder must be in this structure (shown below).

└── input folder
    ├── queries.sql (contains all the queries, each line corresponds to an output file)
    └── db
        ├── schema.txt (describes the structure of tables)
        └── data
            └── text files containing data (each file corresponds to a table)

SQL Support

• Integer data ONLY
• Scan Queries
• Select Queries
• Project Queries
• Join Queries with WHERE clause only
• Order By Queries
• Distinct Queries
• Aliasing

Methodology

Read files with data and store it to memory. While the data is in memory, our Java application will perform the above SQL queries on it.