Please use this identifier to cite or link to this item:
Title: Query Optimization and Database Tuning in Free and Open Source Software Database and Proprietary Databases:
Authors: Suleiman, Kedir Nebi
Keywords: Software Database
Open Source
Issue Date: Oct-2006
Publisher: Kampala International University, School of Computing and Information Technology
Abstract: There are many factors that affect the performance of databases and database throughput. However, more often than not these factors are not critically analyzed and assessed by the Database Administrator or by any person charged with the responsibility to overseeing the day-to-day running of the database. Critical and complex Queries are needed frequently to be executed. Most of the times these queries are not tuned effectively to get maximum out put, so it is needed to tune them according to the environment in which they are used. There is therefore a need to determine the performance indicators for the database when it comes to query optimization and database tuning. These indicators are also influenced by the platform on which the database is to be run- proprietary or open source. This research therefore tries to carry out a comparative study and analysis of the query optimization and database tuning on the two platforms windows and Linux. The major findings of this research Is that MySQL Unux database runs faster than MySQL windows and Oracle windows when creating tables whereas the execution time is faster in oracle on windows when a query contains a join. This is found to be based on the Cost-base Optimization (CBO) execution plan and path taken by the query optimizer which is found to be more complex in Oracle than in other databases.
Description: A Dissertation Presented to the School of Post Graduate studies In Partial Fulfillment of the Requirements for the Award of the Degree of Masters of Computer Science of Kampala in international University
Appears in Collections:Master of Science in Computer Science

Files in This Item:
File Description SizeFormat 
Suleiman Kedir Nebi.pdffull text50.71 MBAdobe PDFView/Open

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