database-indexing

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.

Lehman-Yao B-link tree concurrent index enabling lock-free read operations across dynamic node splits with high-key right links.

Lehman-Yao B-link tree concurrent index enabling lock-free read operations across dynamic node splits with high-key right links.

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

High-performance PHP + MySQL DataTables server-side example tested with 100,000 rows. Includes indexing strategies, deferred joins, cached COUNT(*), deep pagination optimization, search optimization, PDO and measurable performance benchmarks.

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.

Offline index advisor for MySQL / MyBatis: slow query log in, index recommendations and migration SQL out. Deterministic rules, no API key needed.

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

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

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.

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

E-commerce analytics dashboard with real-time generated fake activity

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

In-memory B-Tree indexing engine in Java with exact, range, and accent-insensitive prefix search, JUnit regression tests, and Gradle-based builds.

Production-grade SQL analytical engine modeling customer lifecycle, Month-over-Month (MoM) cohort retention, RFM window segmentation, repurchase latency, and query optimization via explain analyze.

PostgreSQL query planner study on ~600k time-series rows - composite indexing, selectivity, and EXPLAIN ANALYZE.

MongoDB-to-Cassandra data engineering project covering JSON import, aggregation queries, CSV export, CQL table design and secondary indexing.

Advanced SQL analytics on 20.6K Spotify/YouTube tracks (PostgreSQL): schema design, data-quality cleaning, 15 queries from aggregation to window functions & CTEs, plus EXPLAIN ANALYZE query optimization with B-tree indexing.