Improvement of the POLISAS e-request transcript system using query optimization
This paper is about the improvement of the ERequest Transcript system used by POLISAS to be a systematic and effective system. The improvement is implemented to solve the current problem, whereby, students need to access the E-Request Transcript system according to the graduation session in individu...
Saved in:
Main Authors: | , , |
---|---|
Format: | Conference or Workshop Item |
Language: | English English |
Published: |
IOP Publishing
2020
|
Subjects: | |
Online Access: | http://umpir.ump.edu.my/id/eprint/27740/1/79.%20Improvement%20of%20the%20POLISAS%20e-request%20transcript%20system.pdf http://umpir.ump.edu.my/id/eprint/27740/2/79.1%20Improvement%20of%20the%20POLISAS%20e-request%20transcript%20system.pdf http://umpir.ump.edu.my/id/eprint/27740/ https://doi.org/10.1088/1757-899X/769/1/012010 |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.ump.umpir.27740 |
---|---|
record_format |
eprints |
spelling |
my.ump.umpir.277402020-12-17T04:04:30Z http://umpir.ump.edu.my/id/eprint/27740/ Improvement of the POLISAS e-request transcript system using query optimization Mohd Hariz, Ibrahim Suryanti, Awang Kohbalan, Moorthy QA76 Computer software This paper is about the improvement of the ERequest Transcript system used by POLISAS to be a systematic and effective system. The improvement is implemented to solve the current problem, whereby, students need to access the E-Request Transcript system according to the graduation session in individual file. This situation makes it difficult for the administrators to access more than one E-request transcript system if the application is from different sessions. It is because of the data-access issues to generate reports. To achieve the system improvement, an integrated database using the query optimization technique is implemented. Next, the query statement is analyzed to produce an optimum performance. Research results show that the technique is able to improve the query time processing, thus resolving the issues discussed. A user acceptance test for this system consists of a black box test and a beta test has been deployed. A black box test was conducted to test the main menu functions in the E-Request transcript and is found to be able to succeed. Furthermore, the beta test is carried out using a survey form distributed to all students who have graduated. Survey questionnaire showed that 57% of respondents were satisfied using this system and 14% were very satisfied with this system. All respondents have provided a good scaling rate for all items assessed. For overall system assessment, the mean score obtained is 3.78 which is interpreted as a good rate based on the scale of interpretation used. In conclusion, this system has met the needs of consumers as well as simplifying their business based on surveys conducted. IOP Publishing 2020-06 Conference or Workshop Item PeerReviewed pdf en http://umpir.ump.edu.my/id/eprint/27740/1/79.%20Improvement%20of%20the%20POLISAS%20e-request%20transcript%20system.pdf pdf en http://umpir.ump.edu.my/id/eprint/27740/2/79.1%20Improvement%20of%20the%20POLISAS%20e-request%20transcript%20system.pdf Mohd Hariz, Ibrahim and Suryanti, Awang and Kohbalan, Moorthy (2020) Improvement of the POLISAS e-request transcript system using query optimization. In: 6th International Conference on Software Engineering and Computer Systems, ICSECS 2019, 25 - 27 September 2019 , Vistana Kuantan City Center, Kuantan, Pahang. pp. 1-8., 769 (1). ISSN 1757-8981 https://doi.org/10.1088/1757-899X/769/1/012010 |
institution |
Universiti Malaysia Pahang |
building |
UMP Library |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Malaysia Pahang |
content_source |
UMP Institutional Repository |
url_provider |
http://umpir.ump.edu.my/ |
language |
English English |
topic |
QA76 Computer software |
spellingShingle |
QA76 Computer software Mohd Hariz, Ibrahim Suryanti, Awang Kohbalan, Moorthy Improvement of the POLISAS e-request transcript system using query optimization |
description |
This paper is about the improvement of the ERequest Transcript system used by POLISAS to be a systematic and effective system. The improvement is implemented to solve the current problem, whereby, students need to access the E-Request Transcript system according to the graduation session in individual file. This situation makes it difficult for the administrators to access more than one E-request transcript system if the application is from different sessions. It is because of the data-access issues to generate reports. To achieve the system improvement, an integrated database using the query optimization technique is implemented. Next, the query statement is analyzed to produce an optimum performance. Research results show that the technique is able to improve the query time processing, thus resolving the issues discussed. A user acceptance test for this system consists of a black box test and a beta test has been deployed. A black box test was conducted to test the main menu functions in the E-Request transcript and is found to be able to succeed. Furthermore, the beta test is carried out using a survey form distributed to all students who have graduated. Survey questionnaire showed that 57% of respondents were satisfied using this system and 14% were very satisfied with this system. All respondents have provided a good scaling rate for all items assessed. For overall system assessment, the mean score obtained is 3.78 which is interpreted as a good rate based on the scale of interpretation used. In conclusion, this system has met the needs of consumers as well as simplifying their business based on surveys conducted. |
format |
Conference or Workshop Item |
author |
Mohd Hariz, Ibrahim Suryanti, Awang Kohbalan, Moorthy |
author_facet |
Mohd Hariz, Ibrahim Suryanti, Awang Kohbalan, Moorthy |
author_sort |
Mohd Hariz, Ibrahim |
title |
Improvement of the POLISAS e-request transcript system using query optimization |
title_short |
Improvement of the POLISAS e-request transcript system using query optimization |
title_full |
Improvement of the POLISAS e-request transcript system using query optimization |
title_fullStr |
Improvement of the POLISAS e-request transcript system using query optimization |
title_full_unstemmed |
Improvement of the POLISAS e-request transcript system using query optimization |
title_sort |
improvement of the polisas e-request transcript system using query optimization |
publisher |
IOP Publishing |
publishDate |
2020 |
url |
http://umpir.ump.edu.my/id/eprint/27740/1/79.%20Improvement%20of%20the%20POLISAS%20e-request%20transcript%20system.pdf http://umpir.ump.edu.my/id/eprint/27740/2/79.1%20Improvement%20of%20the%20POLISAS%20e-request%20transcript%20system.pdf http://umpir.ump.edu.my/id/eprint/27740/ https://doi.org/10.1088/1757-899X/769/1/012010 |
_version_ |
1687393778926616576 |
score |
13.18916 |