Adaptive query optimization for PostgreSQL

PilotScope is a middleware to bridge the gaps of deploying AI4DB (Artificial Intelligence for Databases) algorithms into actual database systems.

A playground for experimenting ideas that may apply to Spark SQL/Catalyst

Slides and material for MySQL and MariaDB query optimization.

A Relational Optimizer and Executor

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

build your own query planner

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

The codebase for DBSim

Use JSON objects to generate PostgreSQL WHERE clause expressions.

Homework for Query Optimization - a TUM Computer Science Course

Database Systems Implementation @ NUS SoC

Implementation of a SQL Query Optimizer Application for Oracle Database using indexes and plans.

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…

A generic query engine for graph data, based on abstract syntax trees as input.

Query Optimizer

CS 562 - DBMS - Extended Multi-Feature Queries Optimizer

Spanning Tree-based Query Plan Enumeration

Code on paper: Eraser: Eliminating Performance Regression on Learned Query Optimizer