Balsa is a learned SQL query optimizer. It tailor optimizes your SQL queries to find the best execution plans for your hardware and engine.

Neural Relation Understanding: neural cardinality estimators for tabular data

State-of-the-art neural cardinality estimators for join queries

Instructional materials (course files) for the BBT3104 course (Advanced Database Systems) and the MIT8107 course (Advanced Database Systems). Topic: Query Optimization. Based on the IMDb dataset using PostgreSQL and the Join Order Benchmark (JOB).

A pytorch implementation for FACE: A Normalizing Flow based Cardinality Estimator

An advanced distributed knowledge fabric for intelligent document processing, featuring multi-document agents, optimized query handling, and semantic understanding.

Saturn accelerates the training of large-scale deep learning models with a novel joint optimization approach.

Practical Web DataBase Design Book

Scalable Join Cardinality Estimaitor

Sub-optimal Join Order Indicator

Simpli-Squared is a statistics-free join ordering algorithm Without Cardinality Estimates.

Spanning Tree-based Query Plan Enumeration

Why did i do this?

Olympics Dashboard is a database management project which aims at providing a platform about how the Olympics has evolved over time, participation, and performance rate based on gender, different countries, different sport and sports events. A lot of data is generated and collected each year at the Olympics which calls for a method to bring out …

An extremely minimal DB that can be used for educational purposes and rapid prototyping - Fork created by P20074,P20199,P20220

This repository presents research on SQL query optimization, exploring how different indexing strategies and PostgreSQL configurations impact query performance. The project, which earned second place at TCCD Research Day, provides insights into improving database efficiency.

Joiner is a research project for sql join order tuning using reinforcement learning algorithm.

Optimized PostgreSQL queries on a computer science publications dataset. Created tables, ingested CSVs, and wrote queries to analyze conferences, authors, and publication trends. Improved performance by designing indexes, refining join/filter logic, and evaluating execution plans with EXPLAIN, demonstrating query tuning and indexing strategies.

Case Study for a data engineering job application at a company

🪂 Parachute: Single-Pass Bi-Directional Information Passing (VLDB'25)