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 条

[1] In-memory databases
Jenkins, C.
Computer Bulletin (London, 1986), 2001, 3 (05):
[2] A Performance Evaluation of DRAM Access for In-Memory Databases
Qian, Zhang
Wei, Jianhao
Xiang, Yiwen
Xiao, Chuqiao
IEEE ACCESS, 2021, 9 : 146454 - 146470
[3] Performance Issues of in-Memory Databases in OLTP systems
Szpisjak, Patrik
Radai, Levente
2016 IEEE 11TH INTERNATIONAL SYMPOSIUM ON APPLIED COMPUTATIONAL INTELLIGENCE AND INFORMATICS (SACI), 2016, : 479 - 482
[4] A study for Performance Comparison of Different In-Memory Databases
Oguducu, Sule Gunduz
Gayberi, Mehmetcan
Akpinar, Erhan
Kutluay, Hakan
2013 7TH INTERNATIONAL CONFERENCE ON APPLICATION OF INFORMATION AND COMMUNICATION TECHNOLOGIES (AICT), 2013, : 91 - 95
[5] In-memory Representations of Databases via Succinct Data Structures
Raman, Rajeev
PODS'18: PROCEEDINGS OF THE 37TH ACM SIGMOD-SIGACT-SIGAI SYMPOSIUM ON PRINCIPLES OF DATABASE SYSTEMS, 2018, : 323 - 324
[6] Performance Engineering for In-Memory Databases: Models, Experiments and Optimization
Casale, Giuliano
ICPE'16 COMPANION: PROCEEDINGS OF THE 2016 COMPANION PUBLICATION FOR THE ACM/SPEC INTERNATIONAL CONFERENCE ON PERFORMANCE ENGINEERING, 2016, : 13 - 13
[7] Integrating databases with WWW via JDBC
Pan, Jinming
Zheng, Jijiao
Cao, Shihe
Hangkong Dongli Xuebao/Journal of Aerospace Power, 13 (01): : 3 - 5
[8] In-memory Databases - Challenges and Opportunities
Tan, Kian-Lee
Cai, Qingchao
Ooi, Beng Chin
Wong, Weng-Fai
Yao, Chang
Zhang, Hao
SIGMOD RECORD, 2015, 44 (02) : 35 - 40
[9] A Performance Evaluation of In-Memory Databases Operations in Session Initiation Protocol
Al-Allawee, Ali
Lorenz, Pascal
Abouaissa, Abdelhafid
Abualhaj, Mosleh
NETWORK, 2023, 3 (01): : 1 - 14
[10] Memory-Aware Sizing for In-Memory Databases
Molka, Karsten
Casale, Giuliano
Molka, Thomas
Moore, Laura
2014 IEEE NETWORK OPERATIONS AND MANAGEMENT SYMPOSIUM (NOMS), 2014,

← 1 2 3 4 5 →