Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : Indonesian Journal of Electrical Engineering and Computer Science

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.
Query Optimization Using Fuzzy Logic in Integrated Database Susana Susana; Suharjito Suharjito
Indonesian Journal of Electrical Engineering and Computer Science Vol 4, No 3: December 2016
Publisher : Institute of Advanced Engineering and Science

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.11591/ijeecs.v4.i3.pp637-642

Abstract

Query optimization in integrated database can’t be separated from data processing method.  In order to have faster query response time, a method to optimize queries is required.  One of many methods that can be used for query optimization is using fuzzy logic with Tsukamoto inference system.  Value set on each variable is defined membership functions and Tsukamoto inference system used in determining these rules or the terms of query results, then apply it into query method or query line structure.  The application of fuzzy logic inference systems with Tsukamoto can accelerate query response time, and will have more significant difference when the amount of selected data is greater.