Improvement of the POLISAS e-request transcript system using query optimization

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

	Pdf 79. Improvement of the POLISAS e-request transcript system.pdf Restricted to Repository staff only Download (564kB) | Request a copy
Preview	Pdf 79.1 Improvement of the POLISAS e-request transcript system.pdf Download (90kB) | Preview

Abstract

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.

Item Type:	Conference or Workshop Item (Lecture)
Additional Information:	Indexed Scopus
Uncontrolled Keywords:	Integrated; Transcript; Optimization technique; Query optimization
Subjects:	Q Science > QA Mathematics > QA76 Computer software
Faculty/Division:	Faculty of Computing
Depositing User:	Pn. Hazlinda Abd Rahman
Date Deposited:	17 Dec 2020 04:04
Last Modified:	05 Jan 2024 07:51
URI:	http://umpir.ump.edu.my/id/eprint/27740
Download Statistic:	View Download Statistics

Actions (login required)

View Item