Implementation of a Simple DBMS

This repository contains the source code for a simple database management system (DBMS), developed as a term project for the DB class. The system provides essential database functionalities and supports basic SQL-like operations.

Guide

Run simpledb.StartDB.py to start the project.

Features

The implemented DBMS includes the following features:

• Database Management

  • Create and change database.

• Table Management:

  • Create tables with defined schema.
  • Support for data types: int, float, varchar.

• Data Manipulation:

  • Insert, delete, and update records in tables.
  • Query data with simple conditions.

• Views:

  • Create and manage database views.

• Transaction Management:

  • Logging for transactions.
  • Rollback and recovery mechanisms.
  • Concurrency control for safe multi-transaction environments.

Todo:

• See #TODO in the project.