Performance Aspect of the In-Memory Databases Accessed via JDBC

被引：1

作者：

Kostrzewa, Daniel ^{[1
]}

Bach, Malgorzata ^{[1
]}

Brzeski, Robert ^{[1
]}

Werner, Aleksandra ^{[1
]}

机构：

[1] Silesian Tech Univ, Inst Informat, Gliwice, Poland

来源：

BEYOND DATABASES, ARCHITECTURES AND STRUCTURES, BDAS 2016 | 2016年 / 613卷

关键词：

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

D O I：

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

中图分类号：

TP18 [人工智能理论];

学科分类号：

081104 ; 0812 ; 0835 ; 1405 ;

摘要：

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.

引用

页码：236 / 252

页数：17

共 50 条

[21] The Impact of Columnar In-Memory Databases on Enterprise Systems
Plattner, Hasso
PROCEEDINGS OF THE VLDB ENDOWMENT, 2014, 7 (13): : 1722 - 1729
[22] Life Cycle of Transactional Data in In-memory Databases
Pathak, Amit
Gurajada, Aditya
Khadilkar, Pushkar
2018 IEEE 34TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING WORKSHOPS (ICDEW), 2018, : 122 - 133
[23] Comments on “In-Memory Databases in Business Information Systems”
Peter Loos
Stefan Strohmeier
Gunther Piller
Reinhard Schütte
Business & Information Systems Engineering, 2012, 4 : 213 - 223
[24] Comments on "In-Memory Databases in Business Information Systems"
Loos, Peter
Strohmeier, Stefan
Piller, Gunther
Schuette, Reinhard
BUSINESS & INFORMATION SYSTEMS ENGINEERING, 2012, 4 (04) : 213 - 217
[25] Assessing the suitability of in-memory databases in an enterprise context
Meyer, Robert
Banova, Vassilena
Danciu, Alexandru
Prutscher, Demian
Krcmar, Helmut
2015 INTERNATIONAL CONFERENCE ON ENTERPRISE SYSTEMS (ES), 2015, : 78 - 89
[26] Path Prefetching: Accelerating Index Searches for In-Memory Databases
Li, Shuo
Chen, Zhiguang
Xiao, Nong
Sun, Guangyu
2018 IEEE 36TH INTERNATIONAL CONFERENCE ON COMPUTER DESIGN (ICCD), 2018, : 274 - 277
[27] Validity Tracking Based Log Management for In-Memory Databases
Lee, Kwangjin
Kim, Hwajung
Yeom, Heon Y.
IEEE ACCESS, 2021, 9 : 111493 - 111504
[28] An Analysis of Concurrency Control Protocols for In-Memory Databases with CCBench
Tanabe, Takayuki
Hoshino, Takashi
Kawashima, Hideyuki
Tatebe, Osamu
PROCEEDINGS OF THE VLDB ENDOWMENT, 2020, 13 (13): : 3531 - 3544
[29] In-Memory Graph Databases for Web-Scale Data
Castellana, Vito Giovanni
Morari, Alessandro
Weaver, Jesse
Tumeo, Antonino
Haglin, David
Villa, Oreste
Feo, John
COMPUTER, 2015, 48 (03) : 24 - 35
[30] Comparative Study of Different In-Memory (No/New) SQL Databases
Srinivasa, Krishnarajanagar G.
Hiriyannaiah, Srinidhi
DEEP DIVE INTO NOSQL DATABASES: THE USE CASES AND APPLICATIONS, 2018, 109 : 133 - 156

← 1 2 3 4 5 →