Optimal Query Operator Materialization Strategy for Hybrid Databases

摘要

Recent research shows that main memory database system provide 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, we implemented different possibilities of query operator materialization and show in this paper when to chose which kind of output. The results of our experiments can be directly used during plan creation by a cost-based query executor.