Details

Autor(en) / Beteiligte

• Kostrzewa, Daniel
• Bach, Małgorzata
• Brzeski, Robert
• Werner, Aleksandra

Titel

Performance Aspect of the In-Memory Databases Accessed via JDBC

Ist Teil von

• Beyond Databases, Architectures and Structures. Advanced Technologies for Data Mining and Knowledge Discovery, p.236-252

Ort / Verlag

Cham: Springer International Publishing

Link zum Volltext

Quelle

Alma/SFX Local Collection

Beschreibungen/Notizen

• 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 Benchmark\documentclass[12pt]{minimal} \usepackage{amsmath} \usepackage{wasysym} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{amsbsy} \usepackage{mathrsfs} \usepackage{upgreek} \setlength{\oddsidemargin}{-69pt} \begin{document}$$^{\mathrm {TM}}$$\end{document} H (TPC-H) was applied. In our research we focused on the open source systems such as Altibase, H2, HyperSQL, MariaDB, MySQL Memory.