top of page

MiniSQL

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

bottom of page