MiniSQL

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)
  • Interpreter

In terms of functions, we implemented the following queries:

  • Create Table
  • 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..