query-optimization | Topic | Ecosyste.ms: Repos

postgrespro/pg_pathman

Partitioning tool for PostgreSQL

Language: C - Size: 4.58 MB - Last synced at: 1 day ago - Pushed at: 9 days ago - Stars: 588 - Forks: 67

bvanhoekelen/performance

⏱ PHP performance tool analyser your script on time, memory usage and db query. Support Laravel and Composer for web, web console and command line interfaces.

Language: PHP - Size: 6.17 MB - Last synced at: 4 days ago - Pushed at: about 1 year ago - Stars: 523 - Forks: 36

kirillshevch/query_track

Find time-consuming database queries for ActiveRecord-based Rails Apps

Language: Ruby - Size: 326 KB - Last synced at: 19 days ago - Pushed at: over 1 year ago - Stars: 301 - Forks: 13

hbutani/spark-druid-olap 📦

Sparkline BI Accelerator provides fast ad-hoc query capability over Logical Cubes. This has been folded into our SNAP Platform(http://bit.ly/2oBJSpP) an Integrated BI platform on Apache Spark.

Language: Scala - Size: 127 MB - Last synced at: over 1 year ago - Pushed at: almost 7 years ago - Stars: 286 - Forks: 96

Releem is a MySQL performance monitoring tool that automates analysis, performance issue detection, configuration tuning, query optimization and schema control to save you time and improve MySQL performance.

Language: Go - Size: 71.4 MB - Last synced at: 4 days ago - Pushed at: 5 days ago - Stars: 268 - Forks: 30

tpetry/laravel-mysql-explain

Get Visual MySQL EXPLAIN plans with Laravel that are understandable for humans

Language: PHP - Size: 38.1 KB - Last synced at: 8 days ago - Pushed at: 4 months ago - Stars: 260 - Forks: 7

kanmaytacker/fundamentals

A collection of tutorials on computer fundamentals

Language: Java - Size: 129 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 219 - Forks: 305

zhangysh1995/awesome-database-testing

数据库测试资料 This repo is a collection of resources on testing database systems

Size: 75.2 KB - Last synced at: about 1 month ago - Pushed at: almost 2 years ago - Stars: 168 - Forks: 19

zio/zio-query

Add efficient pipelining, batching, and caching to any data source

Language: Scala - Size: 915 KB - Last synced at: 3 days ago - Pushed at: 3 months ago - Stars: 152 - Forks: 22

balsa-project/balsa

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

Language: Python - Size: 29.1 MB - Last synced at: about 2 months ago - Pushed at: almost 3 years ago - Stars: 139 - Forks: 26

tableau/query-graphs

A visualizer for queries - Hyper, Postgres, Tableau

Language: TypeScript - Size: 21.4 MB - Last synced at: 17 days ago - Pushed at: 4 months ago - Stars: 94 - Forks: 28

eugene-khyst/spring-data-examples 📦

Spring Data JPA, Spring Data JDBC, and Spring Data R2DBC examples and a comprehensive guide to JPA fetching and locking strategies.

Language: Java - Size: 3.46 MB - Last synced at: almost 2 years ago - Pushed at: almost 3 years ago - Stars: 93 - Forks: 41

naru-project/naru

Neural Relation Understanding: neural cardinality estimators for tabular data

Language: Python - Size: 54.7 KB - Last synced at: over 2 years ago - Pushed at: about 4 years ago - Stars: 76 - Forks: 25

eugene-khyst/postgresql-performance-essentials

PostgreSQL performance essentials in 1 hour

Size: 71.3 KB - Last synced at: about 1 month ago - Pushed at: almost 3 years ago - Stars: 62 - Forks: 14

neurocard/neurocard

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

Language: Python - Size: 52.2 MB - Last synced at: over 2 years ago - Pushed at: over 4 years ago - Stars: 51 - Forks: 18

jmanhype/DSPy-Multi-Document-Agents

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

Language: Python - Size: 135 KB - Last synced at: 3 days ago - Pushed at: 10 months ago - Stars: 33 - Forks: 3

derhuerst/pev2-cli

Run the PostgreSQL Explain Visualizer 2 (pev2) from the command line.

Language: JavaScript - Size: 66.4 KB - Last synced at: 7 days ago - Pushed at: about 1 month ago - Stars: 26 - Forks: 1

tuannh982/query-planner-guide

build your own query planner

Language: Scala - Size: 3.39 MB - Last synced at: 2 months ago - Pushed at: 7 months ago - Stars: 26 - Forks: 1

knagrecha/saturn

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

Language: Python - Size: 107 KB - Last synced at: 9 days ago - Pushed at: over 1 year ago - Stars: 24 - Forks: 5

waltercai/pqo-opensource

Language: C - Size: 30.8 MB - Last synced at: over 2 years ago - Pushed at: almost 4 years ago - Stars: 20 - Forks: 5

socialblue/laravel-query-adviser

With Laravel Query Adviser you can get more insights into the SQL queries created by Eloquent models used in your app. It logs the queries used by your application and provides a helpful overview of the SQL queries. You can rerun the SQL query to analyze the database impact or copy the SQL query to your clipboard.

Language: Vue - Size: 5.54 MB - Last synced at: 14 days ago - Pushed at: 6 months ago - Stars: 19 - Forks: 1

harvard-cns/cheetah-release

Cheetah is a system that optimizes queries using programmable switches.

Language: C - Size: 53.7 KB - Last synced at: about 1 year ago - Pushed at: almost 5 years ago - Stars: 18 - Forks: 3

for0nething/FACE-A-Normalizing-Flow-based-Cardinality-Estimator

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

Language: Python - Size: 6.84 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 17 - Forks: 4

fukien/carrot

Autumn 2017. A simple implementation of relational database with query optimization as the course project of Principles and Design of Database System, Renmin University of China.

Language: C++ - Size: 20.7 MB - Last synced at: about 2 years ago - Pushed at: over 4 years ago - Stars: 17 - Forks: 6

tommenx/DDB

基于MySQL的分布式数据库

Language: C++ - Size: 16.6 MB - Last synced at: over 2 years ago - Pushed at: over 6 years ago - Stars: 16 - Forks: 0

zchoi/GLSCL

[TIP25] Code for "Text-Video Retrieval with Global-Local Semantic Consistent Learning"

Language: Python - Size: 5.41 MB - Last synced at: 29 days ago - Pushed at: 30 days ago - Stars: 13 - Forks: 0

AhmedSobhy01/query-optimization-research

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.

Language: Python - Size: 6.53 MB - Last synced at: 2 months ago - Pushed at: 6 months ago - Stars: 10 - Forks: 1

karam-mustafa/laravel-query-helper

Laravel package helps you to execute more effective databases queries, delete, update, insert, and optimize your database queries.

Language: PHP - Size: 148 KB - Last synced at: 2 months ago - Pushed at: over 3 years ago - Stars: 10 - Forks: 5

hezuojiao/Joiner

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

Language: Python - Size: 180 KB - Last synced at: over 1 year ago - Pushed at: over 6 years ago - Stars: 9 - Forks: 1

yizenov/compass_query_optimizer

The COMPASS Query Optimizer

Language: C++ - Size: 7.02 MB - Last synced at: 12 months ago - Pushed at: about 1 year ago - Stars: 8 - Forks: 2

mu-majid/sql-postgres-lab

Using PostgresSQL to store and fetch data, tune queries, and design efficient database structures!

Language: JavaScript - Size: 11.5 MB - Last synced at: over 2 years ago - Pushed at: about 4 years ago - Stars: 8 - Forks: 1

nicolasmelo1/PyQuery

Why did i do this?

Language: Python - Size: 24.4 KB - Last synced at: 3 days ago - Pushed at: almost 4 years ago - Stars: 7 - Forks: 1

queensbamlab/Xu

Automated Query Expansion using High Dimensional Clustering

Language: C++ - Size: 56.6 KB - Last synced at: 13 days ago - Pushed at: over 6 years ago - Stars: 6 - Forks: 2

EmilyShepherd/Query-Optimiser

Small project which estimates the cost of, and attempts to optimise, physical SQL query plans

Language: Java - Size: 121 KB - Last synced at: about 1 year ago - Pushed at: over 9 years ago - Stars: 6 - Forks: 2

gabocic/twcollector

Get your MySQL/MariaDB slow queries prioritized and optimized by Tuning Wizard with these tools

Language: Perl - Size: 195 KB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 5 - Forks: 0

Etshawy1/Database-Tuning

💻🛠 Database Tuning, Optimization & performance analysis.

Language: JavaScript - Size: 5.64 MB - Last synced at: about 2 years ago - Pushed at: over 3 years ago - Stars: 5 - Forks: 1

OnizukaLab/Scardina

Scalable Join Cardinality Estimaitor

Language: Python - Size: 384 KB - Last synced at: about 1 year ago - Pushed at: over 1 year ago - Stars: 4 - Forks: 2

Asoke26/Simpli-Squared

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

Language: Python - Size: 171 KB - Last synced at: 12 months ago - Pushed at: almost 4 years ago - Stars: 4 - Forks: 0

Vrroom/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.

Language: C - Size: 274 MB - Last synced at: about 2 years ago - Pushed at: about 4 years ago - Stars: 4 - Forks: 2

Sushmashreeps10/Full-stack-development2025

Database Assessments 📊 A collection of database assessments covering SQL queries, normalization, indexing, transactions and performance optimization. Perfect for practice & skill improvement! 🚀

Language: Java - Size: 5.23 MB - Last synced at: 3 days ago - Pushed at: 2 months ago - Stars: 3 - Forks: 0

nidhiupman568/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 💬. 🚀

Size: 64.5 KB - Last synced at: 3 months ago - Pushed at: 11 months ago - Stars: 3 - Forks: 0

abdallahalseddek/Javeats-Lites

Restaurant mangement system provides a powerful foundation for managing the various aspects of restaurant operations

Language: Java - Size: 45.9 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 3 - Forks: 5

PawSQL/pawsql.github.io.bk

PawSQL optimizes your SQL queries by rewriting your SQL queries, recommending optimal indexes in three steps.

Language: HTML - Size: 10.5 MB - Last synced at: almost 2 years ago - Pushed at: over 2 years ago - Stars: 3 - Forks: 1

mohamadjavadx/FTS-Android-Implementation

full text search implementation on Android with Couchbase

Language: Kotlin - Size: 131 KB - Last synced at: almost 2 years ago - Pushed at: about 3 years ago - Stars: 3 - Forks: 1

evgenabramov/MusicServiceDatabase

🎼 Проект по моделированию и реализации базы данных музыкального стримингового сервиса

Size: 11.3 MB - Last synced at: over 1 year ago - Pushed at: about 5 years ago - Stars: 3 - Forks: 2

Cyberoctane29/CUO-On-Site-Internship--Retail-Store-Database-Evaluation-and-Optimization

This repository showcases my internship project at CUO, focused on evaluating and optimizing a 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.

Language: Jupyter Notebook - Size: 8.24 MB - Last synced at: 10 days ago - Pushed at: 11 days ago - Stars: 2 - Forks: 0

TangSiyang2001/RookieDB

A personal implementation of Berkley's CS186.

Language: Java - Size: 688 KB - Last synced at: 3 months ago - Pushed at: about 2 years ago - Stars: 2 - Forks: 0

AshirwadPradhan/tpsql

Asynchronous execution of parallely executing SQL query

Language: Python - Size: 570 KB - Last synced at: 3 months ago - Pushed at: over 2 years ago - Stars: 2 - Forks: 0

jaregauri/olympics_dashboard

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 more meaning from the data. A visualization-based approach has been taken in this project in that direction. A dashboard is proposed based on a historical dataset on the modern Olympic Games, including all the Games from Athens 1896 to Rio 2016.

Language: Python - Size: 3.89 MB - Last synced at: over 2 years ago - Pushed at: over 3 years ago - Stars: 2 - Forks: 1

KonstantinosPaschopoulos/Radix-Hash-Join

Implementation of the Radix Hash Join (RHJ) algorithm

Language: C - Size: 207 KB - Last synced at: over 1 year ago - Pushed at: about 6 years ago - Stars: 2 - Forks: 0

ZhengtongYan/query-optimizer-lib Fork of itrummer/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, ...).

Size: 130 KB - Last synced at: almost 2 years ago - Pushed at: over 8 years ago - Stars: 2 - Forks: 0

johansolbakken/benchmark

A repository for benchmarking Optimistic Order-Preserving Hash Join (OOHJ) in MySQL using the Join Order Benchmark (JOB). Part of a Master’s thesis project, it includes scripts for setting up the database, running SQL queries, and evaluating performance.

Language: Ruby - Size: 132 MB - Last synced at: 5 days ago - Pushed at: 5 days ago - Stars: 1 - Forks: 0

madhurimarawat/Data-Warehousing

This repository contains practical examples of data warehousing concepts, including star schema and ETL processes, all implemented using MySQL.

Language: Jupyter Notebook - Size: 10.5 MB - Last synced at: 6 days ago - Pushed at: about 2 months ago - Stars: 1 - Forks: 0

berksudan/Data-Engineering-Case-Study-with-SQL-Optimization-and-Python-Data-Integration

Case Study for a data engineering job application at a company

Language: Python - Size: 2.09 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

Md-Emon-Hasan/Vector-Database

Designed to store and retrieve high-dimensional data, such as embeddings, efficiently. It enables fast similarity searches by leveraging techniques.

Language: Jupyter Notebook - Size: 9.19 MB - Last synced at: 2 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

kiranmayi5/SQL-Database-Projects

A collection of projects focused on demonstrating expertise in SQL, database design, and data analysis.

Size: 108 KB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

yizenov/l1-error

Sub-optimal Join Order Indicator

Language: Python - Size: 2.4 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 1 - Forks: 0

vbj420/AI-POWERED-TICKET-FILTERING-SYSTEM

AI-driven solution that allows users to filter and retrieve tickets based on natural language queries. This system interprets and translates user inputs into technical filter criteria, providing an intuitive, user-friendly interface for effective ticket management.

Language: Python - Size: 0 Bytes - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 1 - Forks: 0

georgegkonis/spark-decentralized-query-processing

Project for the academic course "Decentralized Data Technologies"

Language: Jupyter Notebook - Size: 245 KB - Last synced at: 2 months ago - Pushed at: 8 months ago - Stars: 1 - Forks: 0

abdallahalseddek/Practical-Web-Database-Design

Practical Web DataBase Design Book

Language: Python - Size: 2.24 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

Udrasht/SimpleRA

Data-Systems-Project || simplified relational database management system supporting only integer tables and matrices. Supports two-phase merge sort, buffer management and aggregate queries.

Language: C++ - Size: 8.44 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

nightvisi0n/pg-formatter-ts

Format PostgreSQL SQL with ease using this TypeScript library, which provides a convenient API wrapping the `pgFormatter` CLI tool

Language: TypeScript - Size: 205 KB - Last synced at: 13 days ago - Pushed at: about 2 years ago - Stars: 1 - Forks: 0

mantask/thesis-wrapper

An experimental setup for my master thesis "Optimizing web extraction queries for robustness"

Language: HTML - Size: 552 KB - Last synced at: about 2 years ago - Pushed at: almost 3 years ago - Stars: 1 - Forks: 0

jmdha/P6 📦

Query estimation for SQL queries

Language: C# - Size: 3.51 MB - Last synced at: 11 months ago - Pushed at: about 3 years ago - Stars: 1 - Forks: 1

P0bbn/1033-2020

A web-app hosted on AWS using a MySQL back-end database queried using dynamically generated, user-defined, complex SQL queries. Front-end user-interface designed using BootStrap.

Language: Jupyter Notebook - Size: 66.1 MB - Last synced at: 11 months ago - Pushed at: about 3 years ago - Stars: 1 - Forks: 0

skth5199/query-optimiser

Query Optimiser built for SJDB

Language: Java - Size: 42 KB - Last synced at: about 2 years ago - Pushed at: about 3 years ago - Stars: 1 - Forks: 0

thu-west/FBRW

Implementation of our paper "An Efficient Approximate Algorithm for Single-Source Discounted Hitting Time Query" (DASFAA2020)

Language: C++ - Size: 64.5 KB - Last synced at: over 2 years ago - Pushed at: almost 4 years ago - Stars: 1 - Forks: 0

motapinto/sql-query-optimization

SQL: Query optimization

Size: 10.9 MB - Last synced at: 3 months ago - Pushed at: about 4 years ago - Stars: 1 - Forks: 1

asolimando/xqueryprojector

XQuery query processing optimization based on XML projection

Language: HTML - Size: 15.3 MB - Last synced at: about 15 hours ago - Pushed at: over 7 years ago - Stars: 1 - Forks: 0