Optimal Query Operator Materialization Strategy for Hybrid Databases
Recent research shows that main memory database system provides many different advantages over traditional disk based systems. Furthermore it is shown that the way how data is persisted in such a system is very important. Modern systems provide a hybrid row- and column-oriented storage layer that proves to be optimal for certain workloads. To further optimize the query execution it becomes to crucial to select the best possible query operators. However, not only the implementation of the operator is very important but as well the way how intermediate results are handled. In HYRISE, the authors implemented different possibilities of query operator materialization and show in this paper when to choose which kind of output.