Database

Parallelization efforts using VTune

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

A Summary of TPC-DS

The state-of-the-art decision support benchmark.

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…

Shifting to the next gear

A line of code that causes 13 % performance loss

In the last blog post, we described different profilers, their usage, advantages and disadvantages. In this article, we provide an example of finding a performance bottleneck with the help of such code…

Need for Speed: Hyrise

Tools to improve C++ code performance

We (Adrian, Marcel and Toni) constitute the master’s project “C++ Low-Level Performance Engineering” at the Hasso Plattner Institute. The previous master’s project “Query Plan Optimizations” shared…

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…

The gentle Art of referring to Columns

Why we abandoned column names in Hyrise. Or did we really?

What has happened so far?

A Matter of Self-Expression

Making Sense of SQL Expressions for Query Optimization

What has happened so far?

This post is part of a blog series about the progress of writing a query optimizer for Hyrise…

How Much Is The Fish?

Maintaining and Exploiting Database Statistics in Hyrise

What has happened so far?

This post is part of a blog series about the progress of writing a query optimizer for Hyrise, a…