Please use this identifier to cite or link to this item:
https://ptsldigital.ukm.my/jspui/handle/123456789/476627Full metadata record
| DC Field | Value | Language |
|---|---|---|
| dc.contributor.advisor | Kamsuriah Ahmad, Dr. | |
| dc.contributor.author | Nofri Alhadi (P56089) | |
| dc.date.accessioned | 2023-10-06T09:22:42Z | - |
| dc.date.available | 2023-10-06T09:22:42Z | - |
| dc.date.issued | 2012-08-07 | |
| dc.identifier.other | ukmvital:122173 | |
| dc.identifier.uri | https://ptsldigital.ukm.my/jspui/handle/123456789/476627 | - |
| dc.description | Oracle Database is well suited to use for the management and exchange of corporate data, especially for companies that have a large-scale databases. Most companies prefer to use Oracle Database because its grid computing architecture that can create database with real-time responsive to dynamic workloads. Oracle Database can be customized and tuned to improve its performance. This study uses Oracle Database 10g version 10.2.0.1.0 as thesis experimental case study. Even though Oracle Database 10g can perform well, however, there are some conditions where Oracle Database 10g is running slowly and consuming more time to perform the transaction. This is when the query tuning process is needed. This process will solve the problems of Oracle Database’s low performance and high execution time when accessing the database. Even though various previous studies had developed some improvements in the area of query tuning, there are still areas of improvements in term of query performance. Therefore this study is aimed to formulate a query tuning process to reduce the query’s execution time when accessing the database. The queries can be discovered by reviewing the Form, List of Value (LOV) and View on the current system. To enhance the queries, the existing queries scripts needed to be modified to fit the tuning process. The process of query tuning was done manually for simple query or automatically for complex query by using Toad Tuning Advisor for Oracle version 9.1.0.62. Before the tuning process, a system takes 156 milliseconds to execute the query, and now, the execution time decreases to less than one millisecond. This method had already managed to shorten the execution time. The contribution of study outlines a hybrid method of query tuning process that consisted of three stages (Query Tuning Pre-Processing, Query Tuning Processing and Query Tuning PostProcessing). For future improvement, it is expected that all the stages of database needs to be tuned and not only limited in area of query tuning.,Master of Information Technology,Certification of Master's / Doctoral Thesis" is not available" | |
| dc.language.iso | eng | |
| dc.publisher | UKM, Bangi | |
| dc.relation | Faculty of Information Science and Technology / Fakulti Teknologi dan Sains Maklumat | |
| dc.rights | UKM | |
| dc.subject | Query languages (Computer science) | |
| dc.subject | Database management | |
| dc.subject | Oracle (Computer file) | |
| dc.subject | Universiti Kebangsaan Malaysia -- Dissertations | |
| dc.subject | Dissertations, Academic -- Malaysia | |
| dc.title | Query enhancement using hybrid query tuning approach in Oracle database 10g | |
| dc.type | theses | |
| dc.format.pages | 92 | |
| dc.identifier.callno | QA76.9.D3N636 2012 3 tesis | |
| dc.identifier.barcode | 005563(2021)(PL2) | |
| Appears in Collections: | Faculty of Information Science and Technology / Fakulti Teknologi dan Sains Maklumat | |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| ukmvital_122173+SOURCE1+SOURCE1.0.PDF Restricted Access | 10.97 MB | Adobe PDF |  View/Open |
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.