Skip to content

Latest commit

 

History

History
57 lines (37 loc) · 1.65 KB

README.md

File metadata and controls

57 lines (37 loc) · 1.65 KB

CustomeSQLDatabase

Overview

This project is a prototype of a lightweight Database Management System (DBMS) implemented in Java. It provides a console-based interface for SQL query execution, features two-factor user authentication, and manages transactions with ACID properties. Data is stored persistently in a custom text format.

Features

  • SQL Query Support: Handles CREATE, SELECT, and INSERT SQL commands.
  • Two-Factor Authentication: Implements user authentication with ID, password, and a CAPTCHA.
  • Transaction Management: ACID-compliant transactions supporting BEGIN TRANSACTION, COMMIT, and ROLLBACK.
  • Persistent Storage: Stores data in a custom text format with user-defined delimiters.

Requirements

  • Java Development Kit (JDK) - any version is acceptable
  • Standard Java libraries (no third-party libraries used)

Getting Started

  1. Clone the Repository

    git clone https://github.com/Keval-Gandevia/CustomSQLDatabase.git

  2. Navigate to the Project Directory

    cd CustomSQLDatabase

  3. Compile the Code

    javac -d bin src/*.java

  4. Compile the Code

    java -cp bin Main

Usage

  1. Register
    Users must register first with their email, password, and CAPTCHA. Registration data is saved in an authentication file (.txt).

  2. Login
    Authenticate with your registered email, password, and CAPTCHA.

  3. Execute SQL Queries
    Enter SQL commands to create tables, insert data, and select records.

  4. Manage Transactions
    Use BEGIN TRANSACTION, COMMIT, and ROLLBACK commands to handle transactions.