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 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)
- Interpreter
In terms of functions, we implemented the following queries:
- Table creation, deletion
- Insert
- Select, including *, from, where, and, or, parentheses, order by, join
- Delete
- Build Index
- Drop
- Show tables
- Show indexes
Our team got full marks for this project, and I got 100 from this course. HAHAHAHAHA..