KawulaSQL: Mini Database Management System Development

MEGA Project IF3140 - Database Systems 2024

Description

KawulaSQL is a Mini Database Management System (mDBMS) project designed for managing relational databases.

Components of KawulaSQL mDBMS

The mDBMS consists of the following components:

• Query Processor
• Concurrency Control Manager
• Query Optimizer
• Storage Manager
• Failure Recovery Manager

Setup and Usage

To get started, clone the project repository:

https://github.com/KawulaSQL/DBMS.git

Running the Program

Use the following command to run the program:

1. Update all submodules

git submodule update --init --recursive

2. Running the program

python main.py

Supported SQL Syntax

The mDBMS supports the following SQL commands:

• SELECT
• UPDATE
• FROM
• AS
• JOIN
• WHERE
• ORDER BY
• LIMIT
• BEGIN TRANSACTION
• COMMIT
• DELETE
• INSERT
• CREATE TABLE
• DROP TABLE

Contributors

The project is developed by the following team members:

Query Processor

NIM	Name
13522002	Ariel Herfrison
13522067	Randy Verdian
13522110	Marvin Scifo Y. Hutahaean
13522037	Farhan Nafis Rayhan

Concurrency Control Manager

NIM	Name
13522072	Ahmad Mudabbir Arif
13522036	Akbar Al Fattah
13522087	Shulha
13522042	Amalia Putri
13522111	Ivan Hendrawan Tan

Query Optimizer

NIM	Name
13522004	Eduardus Alvito Kristiadi
13521161	Ferindya Aulia Berlianty
13522108	Muhammad Neo Cicero Koda
13521031	Fahrian Afdholi
13522038	Francesco Michael Kusuma

Storage Manager

NIM	Name
13522076	Muhammad Syarafi Akmal
13522089	Abdul Rafi Radityo Hutomo
13522091	Raden Francisco Trianto B.
13522049	Vanson Kurnialim
13521028	M Zulfiansyah Bayu Pratama

Failure Recovery

NIM	Name
13522055	Benardo
13522012	Thea Josephine Halim
13522100	M. Hanief Fatkhan Nashrullah
13521026	Kartini Copa