Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia
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 wh...
Saved in:
| Main Author: | |
|---|---|
| Format: | Thesis |
| Language: | en en |
| Published: |
2001
|
| Subjects: | |
| Online Access: | https://etd.uum.edu.my/462/1/Zarina_binti_Ismail%2C_2001.pdf https://etd.uum.edu.my/462/2/1.Zarina_binti_Ismail%2C_2001.pdf https://etd.uum.edu.my/462/ |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1833435407886319616 |
|---|---|
| author | Zarina, Ismail |
| author_facet | Zarina, Ismail |
| author_sort | Zarina, Ismail |
| building | UUM Library |
| collection | Institutional Repository |
| content_provider | Universiti Utara Malaysia |
| content_source | UUM Electronic Theses |
| continent | Asia |
| country | Malaysia |
| description | 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. |
| format | Thesis |
| id | my.uum.etd-462 |
| institution | Universiti Utara Malaysia |
| language | en en |
| publishDate | 2001 |
| record_format | eprints |
| spelling | my.uum.etd-4622013-07-24T12:07:23Z https://etd.uum.edu.my/462/ Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia Zarina, Ismail QA76 Computer software 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. 2001 Thesis NonPeerReviewed application/pdf en https://etd.uum.edu.my/462/1/Zarina_binti_Ismail%2C_2001.pdf application/pdf en https://etd.uum.edu.my/462/2/1.Zarina_binti_Ismail%2C_2001.pdf Zarina, Ismail (2001) Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia. Masters thesis, Universiti Utara Malaysia. |
| spellingShingle | QA76 Computer software Zarina, Ismail Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia |
| title | Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia
|
| title_full | Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia
|
| title_fullStr | Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia
|
| title_full_unstemmed | Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia
|
| title_short | Prestasi Pangkalan Data : Satu Kajian Kes Terhadap Sistem Aplikasi Siswazah, Universiti Utara Malaysia
|
| title_sort | prestasi pangkalan data : satu kajian kes terhadap sistem aplikasi siswazah, universiti utara malaysia |
| topic | QA76 Computer software |
| url | https://etd.uum.edu.my/462/1/Zarina_binti_Ismail%2C_2001.pdf https://etd.uum.edu.my/462/2/1.Zarina_binti_Ismail%2C_2001.pdf https://etd.uum.edu.my/462/ |
| url_provider | http://etd.uum.edu.my/ |