query-execution

MySQL Simulator Pro is a fully interactive, browser-based MySQL database simulation environment that lets you write and execute real SQL queries — including SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, CREATE INDEX, JOINs, transactions (BEGIN/COMMIT/ROLLBACK), and even role-based access control (GRANT/REVOKE)🗄️👨🏿‍💻.

This project is a simple query processing engine built using relational algebra operators. It supports query evaluation using materialization, with operators such as Select, Project, and Join, and processes records from flat files in a paginated manner.

The system analyzes SQL queries and determines an efficient evaluation plan based on the available database schema, indexes, buffer size, and estimated operation costs. The goal is to simulate key aspects of a database query optimizer and demonstrate how different execution algorithms affect query performance.

A 100D vector database using minibase storage engine

High-performance C++ file-based database engine with SQL-like queries, indexing, execution plan analysis, and Streamlit AI interface.

A course about the foundations of database systems, focusing on basics such as the relational algebra and data model, schema normalization, query optimization, transactions, and other more advanced topics.

Small SQL query engine written from scratch in Go, with a volcano execution model, hash joins, aggregation, three-valued NULL semantics, and SQLite differential testing.

Research prototype for layered PostgreSQL representations and compact batch execution.