It is the project for the Database Design course at ZJU. It is a mini database system like MySQL, but it’s built by ourselves.
It’s available on Github: https://github.com/LeeLeeYeah/MiniSQL
It implemented the following notion in Database Design:
- Buffer Manager (Cache, with clock replacement algorithms)
- Record Manager (Organization of records in a table)
- Index Manager (B+ tree)
- Catalog Manager (Maintain catalog information)
In terms of functions, we implemented the following queries:
- Create Table
- Select, including *, from, where, and, or, parentheses, order by, join
- Build Index
- Show tables
- Show indexes
Our team got full marks for this project, and I got 100 from this course. HAHAHAHAHA..