Article Per Year (5 Year)
p-Index From 2021 - 2026
0.562
P-Index
This Author published in this journals
All Journal Indonesian Journal of Electrical Engineering and Computer Science jurnal syntax admiration Mutiara: Multidiciplinary Scientifict Journal
Ferdy Nirwansyah
Bina Nusantara University
Aerospace Engineering Arts Automotive Engineering Biochemistry, Genetics & Molecular Biology Chemical Engineering, Chemistry & Bioengineering Computer Science & IT Education Electrical & Electronics Engineering Engineering Industrial & Manufacturing Engineering Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Materials Science & Nanotechnology Mathematics Mechanical Engineering Social Sciences

Published : 4 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 4 Documents
Search

 1 
Hybrid Disk Drive Configuration on Database Server Virtualization Ferdy Nirwansyah; Suharjito Suharjito
Indonesian Journal of Electrical Engineering and Computer Science Vol 2, No 3: June 2016
Publisher : Institute of Advanced Engineering and Science

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.11591/ijeecs.v2.i3.pp720-728

Abstract

SSD is a revolutionary new storage technologies. Enterprise storage system using full SSD is still very expensive, while HDD is still widely used. This study discusses hybrid configuration storage in virtualized server database with benchmark against four hybrid storage configuration for four databases, ORACLE, SQL Server, MySQL and PostgreSQL on Windows Server virtualization. Benchmark using TPC-C and TPC-H to get the best performance of four configurations were tested. The results of this study indicate HDD storage configurations as visual disk drive OS and SSD as visual disk drives database get better performance as OLTP and OLAP database server compared with SSD as visual disk drive OS and HDD as a visual disk drive database. Based on the data research TPC-C, OLTP get best performance at HDD storage configurations as visual disk drive OS and SSD as a visual disk drives database and temporary files.
Comparison Performance Analysis of HDD, SSD and NVME for OLTP Database Server Ferdy Nirwansyah
Jurnal Syntax Admiration Vol. 5 No. 10 (2024): Jurnal Syntax Admiration
Publisher : Syntax Corporation Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.46799/jsa.v5i10.1730

Abstract

Databases are an essential component of life in modern society. The database has become an online Transaction Processing (OLTP) operational support company. This study discusses the storage configuration in a virtual server database for OLTP Database with a benchmark against three storage configurations for four databases: SQL Server, MySQL, PostgreSQL, and MariaDB for Windows Server virtualization. Benchmarks using TPC-C to get the best performance from all three configurations have been tested. The results of this study show that the storage configuration of HDD as a virtual disk drive OS and NVME as a virtual disk drive database get better performance as online transaction processing (OLTP) compared to HDD as a virtual disk drive OS and HDD or SSD as a virtual disk drive database. Using the TPC-C benchmark, the study tested the performance of four databases (SQL Server, MySQL, PostgreSQL, and MariaDB) in various virtual storage configurations. The results of 36 experiments involving different numbers of virtual users (10, 50, and 100) showed that a hybrid configuration that used HDDs for the operating system and NVME for database storage provided the best performance. On SQL Server, SSD configurations show better results for smaller user loads. The results suggest that the combination of HDD and NVME is the optimal configuration for most databases in OLTP tasks, and it provides useful guidance in efficient storage investment decision-making. Further research is expected to be able to conduct tests.
Performance Comparison of Hybrid Storage on OLAP Database Server Virtualization Nirwansyah, Ferdy
Mutiara: Multidiciplinary Scientifict Journal Vol. 2 No. 11 (2024): Multidiciplinary Scientifict Journal
Publisher : Al Makki Publisher

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.57185/mutiara.v2i11.285

Abstract

In today's digital era, efficient database management is important for companies to support analysis and decision-making processes. The use of On Line Analytical Processing (OLAP) in databases requires optimal storage configuration, especially in virtualization environments. This study aims to evaluate the performance of OLAP databases using hybrid storage configurations, combining Solid State Drives (SSD) and Hard Disk Drives (HDD), and identify the best configuration to improve database performance. The research method was carried out using the TPC-H benchmark on four database systems: Oracle, SQL Server, MySQL, and PostgreSQL. Four storage configurations were tested by allocating SSD for database storage and HDD for the operating system and temporary files, measured with 10 and 100 virtual users. The results showed that SQL Server provided the best performance in all configurations, with faster query execution times than other databases. The configuration with SSD for database storage and HDD for the operating system and temporary files proved to be the most efficient in reducing query latency. The conclusion of this study emphasizes the importance of using hybrid storage configurations in improving OLAP database performance in virtualization environments. Configuring with SSD as database storage and HDD for operating system and temporary files is the best choice to achieve high query performance.
Performance Comparison of Hybrid Storage on OLAP Database Server Virtualization Nirwansyah, Ferdy
Mutiara: Multidiciplinary Scientifict Journal Vol. 2 No. 11 (2024): Mutiara: Multidiciplinary Scientifict Journal
Publisher : Al Makki Publisher

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.57185/mutiara.v2i11.285

Abstract

In today's digital era, efficient database management is important for companies to support analysis and decision-making processes. The use of On Line Analytical Processing (OLAP) in databases requires optimal storage configuration, especially in virtualization environments. This study aims to evaluate the performance of OLAP databases using hybrid storage configurations, combining Solid State Drives (SSD) and Hard Disk Drives (HDD), and identify the best configuration to improve database performance. The research method was carried out using the TPC-H benchmark on four database systems: Oracle, SQL Server, MySQL, and PostgreSQL. Four storage configurations were tested by allocating SSD for database storage and HDD for the operating system and temporary files, measured with 10 and 100 virtual users. The results showed that SQL Server provided the best performance in all configurations, with faster query execution times than other databases. The configuration with SSD for database storage and HDD for the operating system and temporary files proved to be the most efficient in reducing query latency. The conclusion of this study emphasizes the importance of using hybrid storage configurations in improving OLAP database performance in virtualization environments. Configuring with SSD as database storage and HDD for operating system and temporary files is the best choice to achieve high query performance.
Co-Authors Suharjito Suharjito