Currently supporting the following operations:
- create table {tableName}
- {dataType} {fieldName} (to add attributes to the created table; example, string name)
- insert into {tableName} {values} (values must be in this format: (a, b, c), i.e., comma-separated and within parenthesis, following the order of the field names)
- select * from {tableName} (display all the rows in the table chosen)
- join {table1Name} {table2Name} where {condition}
Modifiable buffer size to reduce the number of records loaded into RAM at once
In the test folder, query files are present which are read and converted to intermediate code (.query.code files).
Change the queryFileName
variable in cs21b059_parser.java
to a query file of your choice.
cs21b059.query
creates two tables with random values.
joinTables.query
performs a join operation on the two created tables with a specifed condition.
Clone the repo to your local machine and run the bash file by going to the root directory and typing ./runDBEngine.sh
in the terminal.