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.

Hybrid B+ Tree and HNSW index for efficient k-NN search with scalar filtering using probabilistic optimization

QRLIT: Quantum Reinforcement Learning for Database Index Tuning

This project simulates a database management system using a B+ Tree to efficiently store and manage data. It demonstrates key database concepts such as table management, indexing, and basic tree operations like insertion, searching, and deletion. The B+ Tree structure enables fast data access, making it ideal for indexing in databases.

Mini Relational Database Management System built in C++ with buffer management, B+ Tree indexing, schema operations, selection, projection, and join.

A practical, engineering-focused course on databases—from queries to storage internals.

Quick-commerce backend simulation in C featuring B-Tree indexing, dirty-flag caching, order processing, delivery routing, and file persistence.

A simple URL Shortener API built with Spring Boot and MySQL that helps shorten long URLs.

Laravel API performance audit and optimization including N+1 query fixes, Redis caching, database indexing, pagination, and query optimization.

Scalable URL shortening service built with Python, Redis & PostgreSQL. Handles 10K+ req/sec using consistent hashing, LRU caching (80% query reduction), and optimized indexing (sub-10ms latency). Deployed on AWS with auto-scaling and load balancing for 99.9% uptime.

This Dyte SDE-1 Assignment require the development of a robust log ingestor system and a user-friendly query interface. The goal is to efficiently handle large volumes of log data and provide a simple yet powerful interface for querying based on various parameters.

대용량 트래픽 가정 이커머스 백엔드 성능 병목 개선 (상품 10만·주문 5만). Java 17 + Spring Boot 3.5 + MySQL + Redis, 쿠폰 동시성 락·복합 인덱스·쿼리 튜닝을 v1~v4 단계별 측정

SQL Server performance tuning lab demonstrating execution plan analysis, indexing strategies, and logical read optimization using a 500k-row dataset.

Example for Database indexing using MySQL and Node JS application

A C-based multi-level database indexing simulator implementing Replacement Selection Sort, Natural Merge Sort, and direct binary file management.

LearnSphere AI is an AI-powered learning platform that generates personalized roadmaps, quizzes, and recommendations. It tracks progress, analytics, and learning goals while offering resources, notes, and social features to create a complete, data-driven learning experience.

A database-backed search tool that indexes files from a local directory tree and enables keyword search across filenames and HTML content.

Full-stack data analytics platform built with Python, Streamlit, and MySQL, integrating 2M+ Chicago open-data records with relational database design, ETL pipelines, geospatial analytics, and interactive SQL-driven dashboards.

A group project, where I designed RDBMS aspects such as ER design, database population, DDL, DML, and where I co-developed the Flask app