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
关键词
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,