Performance comparison of in-memory and disk-based databases using transaction processing performance council (TPC) benchmarking
Authors:
- M. B. AyubMAM. B. Ayub
- N. AliNAN. Ali
Open Access
- 31 August 2018
- journal article
- Published by Academic Journals in Journal of Internet and Information Systems
- Vol. 8 (1) , 1-8
Abstract
Database performance throughput is one of the main measurements of the application effectiveness or a system, in terms of speed and delivery. Higher application efficiency is always a goal for any organization; therefore, finding the way to improve the database performance has priority. There are two main factors that can contribute to performance gain or slowness. Firstly, how well designed the database structure is in terms of data types, referential integrity, and indexes. Secondly, the underlying hardware infrastructure that consists of a server, storage, and network. During the application design lifecycle, the database schema is one area that continuously evolves. There are numerous configurational parameters that need to be adjusted according to database schema design and underlying infrastructure, in which in-memory is an important feature. In-memory database stores all data in physical memory, because of keeping entire data and changes of data in physical memory, the in-memory database provides very short response time and transactional throughput as compared to the disk-based database. This study provides comparison between in-memory and disk-based performance with impact analysis of concurrent users and parallelism using TPC-C benchmarking. A comprehensive benchmark guideline benefits for specific database environment was provided in order to track performance changes while migrating to in-memory from disk-based database. These benchmarking statistics provided comparative standpoint that can be verified during performance bottleneck. This study shows that transitioning from disk-based database to in-memory database decreased the response time and reduced the lock contention, however, requires detailed review for index design changes. Key words: Microsoft Structured Query Language (SQL) Server, in-memory, disk-based, transaction processing performance council (TPC-C), benchmarking, database performance, performance comparison, response time, parallelism, concurrent users.Keywords
This publication has 9 references indexed in Scilit:
- A performance evaluation of in-memory databasesJournal of King Saud University Computer and Information Sciences, 2017
- Assessing the Suitability of In-Memory Databases in an Enterprise Context2015
- Rethinking serializable multiversion concurrency controlProceedings of the VLDB Endowment, 2015
- Comparative Performance Analysis of MySQL and SQL Server Relational Database Management Systems in Windows EnvironmentIJARCCE, 2015
- Performance Analysis of Concurrency Control Mechanisms for OLTP DatabasesInternational Journal of Information and Education Technology, 2014
- Hekaton2013
- System Performance Analysis2012
- Data structures for mixed workloads in in-memory databases2010
- Automatically classifying database workloads2002