Query Optimization and Database Tuning in Free and Open Source Software Database and Proprietary Databases:

Thumbnail Image
Journal Title
Journal ISSN
Volume Title
Kampala International University, School of Computing and Information Technology
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.
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
Software Database, Open Source