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 条

[41] JUMPRUN: A Hybrid Mechanism to Accelerate Item Scanning for In-Memory Databases
Lim, Hongyeol
Park, Giho
2017 IEEE INTERNATIONAL CONFERENCE ON BIG DATA AND SMART COMPUTING (BIGCOMP), 2017, : 231 - 238
[42] Workload-Aware Aggregate Maintenance in Columnar In-Memory Databases
Mueller, Stephan
Butzmann, Lars
Klauck, Stefan
Plattner, Hasso
2013 IEEE INTERNATIONAL CONFERENCE ON BIG DATA, 2013,
[43] Multi-dimensional Data Statistics for Columnar In-Memory Databases
Kroetsch, Curtis
SIGMOD'14: PROCEEDINGS OF THE 2014 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2014, : 1605 - 1606
[44] RC-NVM: Enabling Symmetric Row and Column Memory Accesses for In-Memory Databases
Wang, Peng
Li, Shuo
Sun, Guangyu
Wang, Xiaoyang
Chen, Yiran
Li, Hai
Cong, Jason
Xiao, Nong
Zhang, Tao
2018 24TH IEEE INTERNATIONAL SYMPOSIUM ON HIGH PERFORMANCE COMPUTER ARCHITECTURE (HPCA), 2018, : 518 - 530
[45] In-Memory Business Intelligence: Concepts and Performance
Rantung, V. P.
Kembuan, O.
Rompas, P. T. D.
Mewengkang, A.
Liando, O. E. S.
Sumayku, J.
2ND INTERNATIONAL CONFERENCE ON INNOVATION IN ENGINEERING AND VOCATIONAL EDUCATION, 2018, 306
[46] Adaptive Logging: Optimizing Logging and Recovery Costs in Distributed In-memory Databases
Yao, Chang
Agrawal, Divyakant
Chen, Gang
Ooi, Beng Chin
Wu, Sai
SIGMOD'16: PROCEEDINGS OF THE 2016 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2016, : 1119 - 1134
[47] COMPASS: Online Sketch-based Query Optimization for In-Memory Databases
Izenov, Yesdaulet
Datta, Asoke
Rusu, Florin
Shin, Jun Hyung
SIGMOD '21: PROCEEDINGS OF THE 2021 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2021, : 804 - 816
[48] Alignment of High-Throughput Sequencing Data Inside In-Memory Databases
Firnkorn, Daniel
Knaup-Gregori, Petra
Bermejo, Justo Lorenzo
Ganzinger, Matthias
E-HEALTH - FOR CONTINUITY OF CARE, 2014, 205 : 476 - 480
[49] An Adaptive Eviction Framework for Anti-caching Based In-Memory Databases
Huang, Kaixin
Zheng, Shengan
Shen, Yanyan
Zhu, Yanmin
Huang, Linpeng
DATABASE SYSTEMS FOR ADVANCED APPLICATIONS (DASFAA 2018), PT II, 2018, 10828 : 247 - 263
[50] Access-aware In-memory Data Cache Middleware for Relational Databases
Ma, Kun
Yang, Bo
2015 IEEE 17TH INTERNATIONAL CONFERENCE ON HIGH PERFORMANCE COMPUTING AND COMMUNICATIONS, 2015 IEEE 7TH INTERNATIONAL SYMPOSIUM ON CYBERSPACE SAFETY AND SECURITY, AND 2015 IEEE 12TH INTERNATIONAL CONFERENCE ON EMBEDDED SOFTWARE AND SYSTEMS (ICESS), 2015, : 1506 - 1511

← 1 2 3 4 5 →