SillQL - SQL Clone
C++
Project details
Description
- Implemented an Relational Database Shell for data storage and retrieval in C++ 14 that supports efficient basic SQL queries using Hash Tables, Red-Black Trees, and Comparators.
- Supported SQL commands include:
- CREATE
- INSERT
- REMOVE
- PRINT ALL
- PRINT WHERE
- DELETE (USING WHERE CLAUSE)
- REMOVE (table)
- JOIN (INNER JOIN)
- GENERATE (hash,bst index)
- # (COMMENT)
- QUIT (END)
- The learning goals of this project include:
- Selecting appropriate data structures for a given problem. Using the prior knowledge of Abstract Data Types (ADTs) chose the set of data structures which where most optimal for a set of tasks.
- Evaluated the runtime and storage tradeoffs for storing and accessing data contained in multiple data structures.
- Designed a range of algorithms to handle different situations.
- Evaluated different representations of the same data.
-
Start Date:
March 25th, 2024 -
End Date:
Apr 5th, 2024 -
Github:
Private -
Course:
EECS281 -
Course Topic:
Adv. DSA
7+
Years of Coding Experience
25
Completed CS Projects
3+