A group project of coding a relational database system implementing functions including insertion, deletion, indexing and non-nested standard SQL queries. Written in C++14, cross-platform compiling using CMake.
Developer: Database System Concept Course Team
I was responsible for the implementation of Catalog Manager and API Module.
The API Module provides APIs for the Interpreter to invoke. And the API module keeps the pointers of Record Manager/Index Manager and Catalog Manager for different function calls.
The Catalog Module tracks the catalog information of the database. In implementation, it keeps a pointer to indexManager, to ensure the data consistency across modules. Also it keeps two hash tables for the information of tables and indexes for fast indexing.
In our performance test, this miniSQL DB is able to complete 100k insertions queries in 13s.
For Source Code, Check: https://github.com/747745124/miniSQL