Percepatan Perhitungan Hasil Tes Sistem Online menggunakan Kompresi Database

Authors

  • Surya Sujarwo Bina Nusantara University

DOI:

https://doi.org/10.21512/comtech.v4i2.2658

Keywords:

database compression, processing time, online test result

Abstract

The article explores the influence of database compression on processing time in generating online test results through experimental study. The study uses three level compressions consists of none, row and page in table used by online test system. The experiment shows that using page compression results in faster processing time and less space compared to none and row compression, and the optimal row for compression is between 1001 and 2000 rows. In summary, to reduce space usage and processing time, it is better to use page compression in user answer table of online test system and to group the participant in schedule so that users’ answer will be between 1001 and 2000 rows.

Dimensions

Plum Analytics

Author Biography

Surya Sujarwo, Bina Nusantara University

Computer Science Department, School of Computer Science

References

Bhuiyan, M. M., & Hoque, A. S. (2009). High performance SQL queries on compressed relational database. Journal of Computers, 4, 1263-1274.

Dodig-Crnkovic, G. (2002). Scientific methods in computer science. Conference for the Promotion of Research in IT at New Universities and at University Colleges in Sweden (pp. 6-7). Sweden: Mälardalen University.

Freitas, R. (2009). Scientific Research Methods and Computer Science. Diakses dari http://www.map.edu.pt/mapi/2008/map-i-research-methods-workshop-2009

Lerman, J. (2010). Programming Entity Framework. Sebastopol: O'Reilly Media.

McGehee, B. (2008). Brad's Sure Guide to SQL Server 2008. Cambridge: Red Gate Books.

Shepherd, G. (2010). Microsoft ASP.NET 4 Step by Step. Redmond: Microsoft Press.

Downloads

Published

2013-12-31

Issue

Section

Articles
Abstract 208  .
PDF downloaded 198  .