Browsing by Author "Suleiman Kedir, Nebi"
Now showing 1 - 1 of 1
Results Per Page
Sort Options
- ItemQuery Optimization and Database Tuning In Free and Open Source Software Databases and Proprietary Databases(Kampala International University, school of computer science, 2006-10) Suleiman Kedir, NebiThere 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.