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 条
  • [31] Experiments or Simulation? A Characterization of Evaluation Methods for In-Memory Databases
    Molka, Karsten
    Casale, Giuliano
    2015 11TH INTERNATIONAL CONFERENCE ON NETWORK AND SERVICE MANAGEMENT (CNSM), 2015, : 201 - 209
  • [32] Efficient Reboot-Based Recovery of In-Memory Databases
    Jumonji, Yuto
    Yamada, Hiroshi
    IEICE TRANSACTIONS ON INFORMATION AND SYSTEMS, 2021, E104D (12) : 2164 - 2172
  • [33] Non-Invasive Progressive Optimization for In-Memory Databases
    Zeuch, Steffen
    Pirk, Holger
    Freytag, Johann-Christoph
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2016, 9 (14): : 1659 - 1670
  • [34] Concurrent Execution of Mixed Enterprise Workloads on In-Memory Databases
    Wust, Johannes
    Grund, Martin
    Hoewelmeyer, Kai
    Schwalb, David
    Plattner, Hasso
    DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, DASFAA 2014, PT I, 2014, 8421 : 126 - 140
  • [35] Experimental Study on Concurrency Control Algorithms in In-Memory Databases
    Zhao H.-Y.
    Zhao Z.-H.
    Yang W.-Q.
    Lu W.
    Li H.-X.
    Du X.-Y.
    Ruan Jian Xue Bao/Journal of Software, 2022, 33 (03): : 867 - 890
  • [36] In-Memory Performance for Big Data
    Graefe, Goetz
    Volos, Haris
    Kimura, Hideaki
    Kuno, Harumi
    Tucek, Joseph
    Lillibridge, Mark
    Veitch, Alistair
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2014, 8 (01): : 37 - 48
  • [37] Improving Java']JavaScript Performance via Efficient In-memory Bytecode Caching
    Heo, Jun
    Woo, Seungjin
    Jang, Hakbeom
    Yang, Kyungyeon
    Lee, Jae W.
    2016 IEEE INTERNATIONAL CONFERENCE ON CONSUMER ELECTRONICS-ASIA (ICCE-ASIA), 2016,
  • [38] Separated Allocator Metadata in Disaggregated In-Memory Databases: Friend or Foe?
    Weisgut, Marcel
    Ritter, Daniel
    Boissier, Martin
    Perscheid, Michael
    2022 IEEE 36TH INTERNATIONAL PARALLEL AND DISTRIBUTED PROCESSING SYMPOSIUM WORKSHOPS (IPDPSW 2022), 2022, : 1202 - 1208
  • [39] Generating Application-Specific Data Layouts for In-memory Databases
    Yan, Cong
    Cheung, Alvin
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2019, 12 (11): : 1513 - 1525
  • [40] To Copy or Not to Copy: Making In-Memory Databases Fast on Modern NICs
    Kesavan, Aniraj
    Ricci, Robert
    Stutsman, Ryan
    DATA MANAGEMENT ON NEW HARDWARE, 2017, 10195 : 79 - 94