Performance issues of In-Memory Databases in OLTP systems
Patrik Szpisjak, Levente Rádai · 2016
Nowadays, new in-memory-based Enterprise Resource Planning solutions are available for the companies. One of the main purposes of these solutions are the availability of real-time analytics. In a previous paper [1], we discussed, how Oracle In-Memory Database solutions can support faster on-line analytical processing queries and measured and discussed the limitations of the Oracle in-memory extension related to the complexity of the query and size of the tables, which showed a downturn in in-memory performance gain as the number of tables to be joined raises. [3] In present paper, the question is, how this in-memory performance gain does look like in case of on-line transaction processing functionality. During the examination, we try to go forward into the direction of comparison this performance issue at different type of in-memory database types.