Performance aspect of the in-memory databases accessed via JDBC

Abstract

The conception of storing and managing data directly in RAM appeared some time ago but in spite of very good efficiency, it was impossible to massive implementation because of hardware limitations. Currently, it is possible to store whole databases in memory as well as there are some mechanisms to organize pieces of data as in-memory databases. It has been the interesting issue how this type of databases behaves when accessing via JDBC. Hence we decided to test their performance in terms/sense of the time of SQL query execution. For this purpose TPC BenchmarkTM H (TPC-H) was applied. In our research we focused on the open source systems such as Altibase, H2, HyperSQL, MariaDB, MySQL Memory.