Percepatan Perhitungan Hasil Tes Sistem Online menggunakan Kompresi Database
DOI:
https://doi.org/10.21512/comtech.v4i2.2658Keywords:
database compression, processing time, online test resultAbstract
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.
Plum Analytics
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
Issue
Section
License
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
USER RIGHTS
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows:
