Zarina, Ismail (2001) Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia. Masters thesis, Universiti Utara Malaysia.
Zarina_binti_Ismail,_2001.pdf - Submitted Version
Restricted to Registered users only
Performance of a database application is dependent on many variables including network infrastructure, server hardware, client side hardware, database configuration, database design, database connectivity tools, efficiency of application coding, use of indexes and size of the database. Therefore when application performance issues arise it is often difficult to determine which aspect is the primary performance bottleneck. One of the main factor that contribute to poor database performance is due to poorly optimized queries which fails to maintain good performance as the data volumes increases. This project is to study and fine tune the performance of student database with a case study on Graduate Application System of Universiti Utara Malaysia. Since applications are the users' gateway to the database, poor database performance can have a huge impact on system performance. The approach used in this project for tunning the system performance is by optimizing unefficient queries. The effeciency of the query is based on the response time to output data and the cost of input/output of the query. The result of the study shows that optimized queries have a fast response time to return the data and therefore tuning query statements provide one of the most important mechanism for improving system performance.
|Item Type:||Thesis (Masters)|
|Uncontrolled Keywords:||Database Performance, Case Study, Graduate Application System, Universiti Utara Malaysia|
|Subjects:||Q Science > QA Mathematics > QA76 Computer software|
|Divisions:||Faculty and School System > Sekolah Siswazah|
|Depositing User:||Mrs Hafiza Mohd Akhir|
|Date Deposited:||19 Oct 2009 02:31|
|Last Modified:||24 Jul 2013 12:07|
Actions (login required)