Query Plan Optimization: Disjunction Split-Up

In our previous blog post, we showed how optimizations of the Logical Query Plan…

Jun 14, 2017

Benchmark-driven Query Optimization

A few weeks have gone by since we started our master project “Query Plan Optimizations”. In our previous post we introduced the next version of Hyrise, a research database developed at the Hasso Plattner Institute. By now we have focused on setting up a benchmark…

Marcel Weisgut in Hyrise

Aug 14, 2019

Query Plan Optimization: Sub-Plan Memoization

In the previous blog posts, we introduced the Hyrise…

Julian Menzler in Hyrise

Oct 18, 2019

Parallelization efforts using VTune

Up to this point, we focused a lot on query plan optimization based on individual long-running…

Sven Lehmann in Hyrise

Sep 26, 2017

Taming SQL for Query Optimization

How we added a Query Optimizer to Hyrise

This is the final post in a blog series about the progress of writing a query optimizer for Hyrise, a main-memory column-oriented research database.
So far, we have written…

Pascal Führlich in Hyrise

Oct 19, 2019

Query Plan Optimization: Join Predicate Ordering

Toni Stachewicz in Hyrise

Jul 19, 2018

Having a closer look under the hood

Instrumenting code on demand via USDT

In our first blog post, we introduced the instrumentation profiling technique which is used by some code profilers, for example callgrind or gprof. Since instrumentation…