الفهرس | Only 14 pages are availabe for public view |
Abstract Many approaches have been proposed aiming to reduce the cost of join operations. Such join operations represent the key factor of the inquiry process to retrieve related information from different data tables in large relational databases. Yet, there is still a need for more intelligent query optimizing approaches to reduce the response time of query execution. This work proposes an approach for reaching optimal query access plans for complex relational database queries including a set of join operations. The proposed approach is based on ant colony optimization technique to benefit from its ability of parallel search over several constructive computational threads which aims to reach an optimal query access plan. A comparative study shows the added value of the proposed approach. The proposed approach is applied on many different cases to check its performance against SQL Server 2014 query optimizer. A comparative study has been presented between the results of the proposed approach and SQL SERVER 2014. The results shows a reduction by 17% in average in the processing cost of the obtained optimal query access plan of the proposed approach compared with the obtained one by SQL Server 2014 query optimizer |