# minSQL

**Repository Path**: StreakyPork/min-sql

## Basic Information

- **Project Name**: minSQL
- **Description**: No description available
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-04-11
- **Last Updated**: 2021-04-12

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 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 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)
- MiniSQL.Interpreter
![](http://www.yejunli.com/wp-content/uploads/minisql1.jpg)

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
![](http://www.yejunli.com/wp-content/uploads/minisql2.jpg)

Our team got full marks for this project, and I got 100 from this course. HAHAHAHAHA..