Query Optimization and Database Tuning in Free and Open Source Software Database and Proprietary Databases:
Loading...
Date
2006-10
Authors
Journal Title
Journal ISSN
Volume Title
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
Keywords
Software Database, Open Source