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)🗄️👨🏿‍💻.

mysql sql database transactions rbac database-management relational-databases acid query-optimization indexes performance-profiling database-security sql-learning explain-plan sql-practice data-manipulation-language data-definition-language sql-simulator query-execution

• Updated Mar 5, 2026
• HTML

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.

database-management relational-algebra query-execution

• Updated Apr 11, 2025
• C++

Watch a SQL SELECT run one logical stage at a time, FROM and JOIN through WHERE, GROUP BY, HAVING, ORDER BY and LIMIT, with the real rows at each step and a plain-English narration of what changed. Runs on demo tables or your own CSV. Built with Claude Code.

visualization typescript sql database cs-education learn-sql sql-tutorial query-execution claude-code

• Updated Nov 8, 2026
• TypeScript

Storage and query-execution layers of a relational database in C++: buffer manager, slotted heap pages, heap files, relational operators and joins.

database cpp storage-engine dbms buffer-pool query-execution

• Updated Nov 12, 2026
• C++

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.

python json sql algorithms query-optimization database-systems b-plus-tree external-sorting hash-join sort-merge-join hash-indexes query-execution join-algorithms cost-based-optimization

• Updated Aug 22, 2026
• Python

A 100D vector database using minibase storage engine

database lsh-forest minibase lsh-algorithm vector-database query-execution

• Updated Jul 18, 2025
• Java

Disk-oriented relational DBMS in C++17: buffer pool with LRU-K, concurrent B+ tree index, Volcano query execution with hash join, and MVCC concurrency control. Built on CMU 15-445 BusTub. Code private per course policy; design write-up in README.

database cpp storage-engine mvcc dbms concurrency cpp17 buffer-pool b-plus-tree query-execution

• Updated Nov 7, 2026

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

python cmake sql cplusplus algorithms cpp indexing data-structures sql-parser database-management performance-analysis query-optimization hash-table database-engine database-systems natural-language-to-sql query-processing streamlit file-based-database query-execution

• Updated Sep 22, 2026
• C++

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.

sql storage-engine recovery deadlock-detection concurrency-control aries buffer-pool write-ahead-logging transactional-database 2q query-execution multiple-granularity-locking

• Updated Aug 11, 2026
• Go

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.

go golang sql compiler sql-parser query-engine volcano hash-join query-planner query-execution

• Updated Aug 24, 2026
• Go

Research prototype for layered PostgreSQL representations and compact batch execution.

postgresql columnar-storage partitioning htap vectorized-execution query-execution database-research

• Updated Oct 3, 2026
• C