query-optimization
There are 236 repositories under query-optimization topic.
Database-Tuning
💻🛠 Database Tuning, Optimization & performance analysis.
Simpli-Squared
Simpli-Squared is a statistics-free join ordering algorithm Without Cardinality Estimates.
MusicServiceDatabase
🎼 Проект по моделированию и реализации базы данных музыкального стримингового сервиса
wp-performance
The main task of this plugin is to increase the security of the site and improve the performance of the site by disabling completely unnecessary hooks and also optimizing SQL queries
Xu
Automated Query Expansion using High Dimensional Clustering
Query-Optimiser
Small project which estimates the cost of, and attempts to optimise, physical SQL query plans
api
🔍 AI-Enhanced MySQL Full-Text Search Engine | Semantic search, query optimization & real-time analytics for MySQL databases | Zero-migration setup.
DPconv
🚀 DPconv: Super-Polynomially Faster Join Ordering (SIGMOD'25 Honorable Mention)
Full-stack-development2025
Database Assessments 📊 A collection of database assessments covering SQL queries, normalization, indexing, transactions and performance optimization. Perfect for practice & skill improvement! 🚀
FTS-Android-Implementation
full text search implementation on Android with Couchbase
parallel-qo-postgres
(not) Parellel Query Optimizer for Postgres. In this fork of Postgres, we replace the original query optimizer with a parallelized query optimizer based on the work of Trummer et al.
PriSM
[BSc Thesis] PriSM: Prior-Guided Search Methods for Query Efficient Black-Box Adversarial Attacks
Database-Project
🗃️ MySQL-based relational database project focused on Ethiopian Airlines' booking system. Features include student discount logic and optimized queries.
MY-SQL-PROBLEM-SOLVED
🌟Welcome to a curated 📚 collection 📚 of solved 🛠️ MySQL 💾 interview 💬 problems ❓ from LeetCode 💡. 📊🔍 This section 📚 showcases 🔍 key questions ❓ and their solutions 💡, providing 📊 a valuable 🛠️ resource 📚 for anyone 💬 preparing 🛠️ for SQL 💾 interviews 💬. 🚀
l1-error
Sub-optimal Join Order Indicator
RookieDB
A personal implementation of Berkley's CS186.
database-systems-projects
Contains code for the Minibase project
KustoGraphAssistant
A Model Context Protocol (MCP) server that provides comprehensive guidance and best practices for creating and managing Kusto graph models in Azure Data Explorer.
sql-sherlock
PostgreSQL-powered SQL quality analyzer that detects anti‑patterns, suggests safe rewrites, and scores queries.
advanced-postgresql-practical-labs
In this course, master PostgreSQL through hands-on labs covering relationships, advanced data types, indexing, transactions, views, permissions, queries, triggers, backups, partitioning, full-text search, and more.
Data-Warehousing
This repository contains practical examples of data warehousing concepts, including star schema and ETL processes, all implemented using MySQL.
CUO-On-Site-Internship--Retail-Store-Database-Evaluation-and-Optimization
This repository showcases my internship project at CUO, focused on querying and analysing a music retail store database. Key tasks included analyzing the schema, improving query performance, ensuring data integrity, and implementing security measures. This project enhanced my understanding of database management in a business setting.
virny-flow
A design space for responsible model development that combines evaluation protocol definition, multi-objective Bayesian optimization, cost-aware multi-armed bandits, query optimization, and distributed parallelism.
QueryGPT
This repository contains a Python application that uses the Langchain library to optimize database queries.
query-optimizer-lib
Contains implementations of various algorithms for database query optimization. The algorithms cover multiple problem variants (e.g., traditional and multi-objective query optimization) and offer different tradeoffs between optimality guarantees and optimization time (e.g., fast randomized algorithms, approximation schemes, exhaustive algorithms, parallel algorithms, ...).
sparql-optimization
A research paper published in EDBT-2021 titled as "Optimizing SPARQL Queries using Shape Statistics"
tpsql
Asynchronous execution of parallely executing SQL query
Radix-Hash-Join
Implementation of the Radix Hash Join (RHJ) algorithm
ZipGraph
⚡ Blazing-fast graph processing engine in Rust with ML-powered optimization. 50-200x faster than Python/JS. Self-tuning algorithms, real-time anomaly detection, and sub-10ms queries on million-node graphs. 🚀🧠
Data-Cleaning-and-EDA
A complete SQL-based project analyzing global company layoffs between 2020 and 2023. Includes data cleaning, duplication handling, date standardization, and exploratory analysis to uncover key trends by country, sector, and year — all done using MySQL.
SQL-Portfolio-105-Problems
Hands-on SQL portfolio of 105 real-world problems showcasing analytical precision, performance tuning, and query mastery.
Brazilian_Ecommerce_data_analysis
Analysis of Brazilian E-commerce data exploring customer behavior, sales trends, payment methods, and business insights through data visualization and analytics.
Log-Ingestor
Log Ingestor is a scalable DBMS project designed to manage large volumes of log data generated by distributed servers. It uses database sharding to store logs server-wise, maintaining uniform log formats per server and improving query efficiency. This design simplifies log retrieval, speeds up debugging, and supports security compliance.
Conversational
Personal Website using an Intelligent and Hybrid Chat and Voice Bot catered specifically for my resume and professional work.
fspann-query-system
We’re building a secure search engine for high-dimensional data, like images or audio. Normally, finding the ‘nearest neighbors’ in huge datasets is already hard because the vectors are large and the dataset can be billions of points. We add another challenge: the data is encrypted, so the system must be forward-secure.