Performance aspect of the in-memory databases accessed via JDBC

Daniel Kostrzewa; Małgorzata Bach; Robert Brzeski; Aleksandra Werner

doi:10.1007/978-3-319-34099-9_18

Performance aspect of the in-memory databases accessed via JDBC

Department of Applied Informatics (RAU/RAU7)

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

2 Citations (Scopus)

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 Benchmark^TM H (TPC-H) was applied. In our research we focused on the open source systems such as Altibase, H2, HyperSQL, MariaDB, MySQL Memory.

Original language	English
Title of host publication	Beyond Databases, Architectures and Structures
Subtitle of host publication	Advanced Technologies for Data Mining and Knowledge Discovery - 12th International Conference, BDAS 2016, Proceedings
Editors	Stanislaw Kozielski, Dariusz Mrozek, Pawel Kasprowski, Bozena Malysiak-Mrozek, Daniel Kostrzewa
Publisher	Springer Verlag
Pages	236-252
Number of pages	17
ISBN (Print)	9783319340982
DOIs	https://doi.org/10.1007/978-3-319-34099-9_18
Publication status	Published - 2016
Event	12th International Conference on Beyond Databases, Architectures and Structures, BDAS 2016 - Ustron, Poland Duration: 31 May 2016 → 3 Jun 2016

Publication series

Name	Communications in Computer and Information Science
Volume	613
ISSN (Print)	1865-0929

Conference

Conference	12th International Conference on Beyond Databases, Architectures and Structures, BDAS 2016
Country/Territory	Poland
City	Ustron
Period	31/05/16 → 3/06/16

Keywords

Altibase
Benchmark
H2
HyperSQL
In-memory databases
MariaDB
MySQL memory
TPC-H

ASJC Scopus subject areas

General Computer Science
General Mathematics

Access to Document

10.1007/978-3-319-34099-9_18

Cite this

Kostrzewa, D., Bach, M., Brzeski, R., & Werner, A. (2016). Performance aspect of the in-memory databases accessed via JDBC. In S. Kozielski, D. Mrozek, P. Kasprowski, B. Malysiak-Mrozek, & D. Kostrzewa (Eds.), Beyond Databases, Architectures and Structures: Advanced Technologies for Data Mining and Knowledge Discovery - 12th International Conference, BDAS 2016, Proceedings (pp. 236-252). (Communications in Computer and Information Science; Vol. 613). Springer Verlag. https://doi.org/10.1007/978-3-319-34099-9_18

Kostrzewa, Daniel ; Bach, Małgorzata ; Brzeski, Robert et al. / Performance aspect of the in-memory databases accessed via JDBC. Beyond Databases, Architectures and Structures: Advanced Technologies for Data Mining and Knowledge Discovery - 12th International Conference, BDAS 2016, Proceedings. editor / Stanislaw Kozielski ; Dariusz Mrozek ; Pawel Kasprowski ; Bozena Malysiak-Mrozek ; Daniel Kostrzewa. Springer Verlag, 2016. pp. 236-252 (Communications in Computer and Information Science).

@inproceedings{2b0fcebc7084427d9d04a55516000513,

title = "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.",

keywords = "Altibase, Benchmark, H2, HyperSQL, In-memory databases, MariaDB, MySQL memory, TPC-H",

author = "Daniel Kostrzewa and Ma{\l}gorzata Bach and Robert Brzeski and Aleksandra Werner",

note = "Publisher Copyright: {\textcopyright} Springer International Publishing Switzerland 2016.; 12th International Conference on Beyond Databases, Architectures and Structures, BDAS 2016 ; Conference date: 31-05-2016 Through 03-06-2016",

year = "2016",

doi = "10.1007/978-3-319-34099-9\_18",

language = "English",

isbn = "9783319340982",

series = "Communications in Computer and Information Science",

publisher = "Springer Verlag",

pages = "236--252",

editor = "Stanislaw Kozielski and Dariusz Mrozek and Pawel Kasprowski and Bozena Malysiak-Mrozek and Daniel Kostrzewa",

booktitle = "Beyond Databases, Architectures and Structures",

address = "Germany",

}

Kostrzewa, D , Bach, M , Brzeski, R & Werner, A 2016, Performance aspect of the in-memory databases accessed via JDBC. in S Kozielski, D Mrozek, P Kasprowski, B Malysiak-Mrozek & D Kostrzewa (eds), Beyond Databases, Architectures and Structures: Advanced Technologies for Data Mining and Knowledge Discovery - 12th International Conference, BDAS 2016, Proceedings. Communications in Computer and Information Science, vol. 613, Springer Verlag, pp. 236-252, 12th International Conference on Beyond Databases, Architectures and Structures, BDAS 2016, Ustron, Poland, 31/05/16. https://doi.org/10.1007/978-3-319-34099-9_18

Performance aspect of the in-memory databases accessed via JDBC. / Kostrzewa, Daniel ; Bach, Małgorzata ; Brzeski, Robert et al.
Beyond Databases, Architectures and Structures: Advanced Technologies for Data Mining and Knowledge Discovery - 12th International Conference, BDAS 2016, Proceedings. ed. / Stanislaw Kozielski; Dariusz Mrozek; Pawel Kasprowski; Bozena Malysiak-Mrozek; Daniel Kostrzewa. Springer Verlag, 2016. p. 236-252 (Communications in Computer and Information Science; Vol. 613).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - Performance aspect of the in-memory databases accessed via JDBC

AU - Kostrzewa, Daniel

AU - Bach, Małgorzata

AU - Brzeski, Robert

AU - Werner, Aleksandra

N1 - Publisher Copyright: © Springer International Publishing Switzerland 2016.

PY - 2016

Y1 - 2016

N2 - 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.

AB - 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.

KW - Altibase

KW - Benchmark

KW - H2

KW - HyperSQL

KW - In-memory databases

KW - MariaDB

KW - MySQL memory

KW - TPC-H

UR - https://www.scopus.com/pages/publications/84964766312

U2 - 10.1007/978-3-319-34099-9_18

DO - 10.1007/978-3-319-34099-9_18

M3 - Conference contribution

AN - SCOPUS:84964766312

SN - 9783319340982

T3 - Communications in Computer and Information Science

SP - 236

EP - 252

BT - Beyond Databases, Architectures and Structures

A2 - Kozielski, Stanislaw

A2 - Mrozek, Dariusz

A2 - Kasprowski, Pawel

A2 - Malysiak-Mrozek, Bozena

A2 - Kostrzewa, Daniel

PB - Springer Verlag

T2 - 12th International Conference on Beyond Databases, Architectures and Structures, BDAS 2016

Y2 - 31 May 2016 through 3 June 2016

ER -

Kostrzewa D , Bach M , Brzeski R , Werner A. Performance aspect of the in-memory databases accessed via JDBC. In Kozielski S, Mrozek D, Kasprowski P, Malysiak-Mrozek B, Kostrzewa D, editors, Beyond Databases, Architectures and Structures: Advanced Technologies for Data Mining and Knowledge Discovery - 12th International Conference, BDAS 2016, Proceedings. Springer Verlag. 2016. p. 236-252. (Communications in Computer and Information Science). doi: 10.1007/978-3-319-34099-9_18

Performance aspect of the in-memory databases accessed via JDBC

Abstract

Publication series

Conference

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this