1. UKM Learning and Research Repository
2. Master Thesis / Tesis Master
3. Faculty of Information Science and Technology / Fakulti Teknologi dan Sains Maklumat

Title:	Query enhancement using hybrid query tuning approach in Oracle database 10g
Authors:	Nofri Alhadi (P56089)
Supervisor:	Kamsuriah Ahmad, Dr.
Keywords:	Query languages (Computer science) Database management Oracle (Computer file) Universiti Kebangsaan Malaysia -- Dissertations Dissertations, Academic -- Malaysia
Issue Date:	7-Aug-2012
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"
Pages:	92
Call Number:	QA76.9.D3N636 2012 3 tesis
Publisher:	UKM, Bangi
Appears in Collections:	Faculty of Information Science and Technology / Fakulti Teknologi dan Sains Maklumat

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.