Query Optimization and Database Tuning In Free and Open Source Software Databases and Proprietary Databases
Loading...
Date
2006-10
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Kampala International University, school of computer science
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 ot 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 o Postgraduate studies in partial fulfillment of the requirements for the award of the degree of masters of Computer science Of Kampala International University
Keywords
Query Optimization and Database Tuning, Open Source Software Databases and Proprietary Databases