header
Image from OpenLibrary

Contributions to query optimization using searching methodologies inspired from nature / Hany Abdelnaby Hanafy Ahmed ; Supervised Hesham Ahmed Hefny , Ahmed Gadallah

By: Contributor(s): Material type: TextTextLanguage: English Publication details: Cairo : Hany Abdelnaby Hanafy Ahmed , 2019Description: 110 Leaves ; 30cmOther title:
  • إسهامات فى تحسين الاستعلام باستخدام أساليب بحث مستوحاة من الطبيعة [Added title page title]
Subject(s): Available additional physical forms:
  • Issued also as CD
Dissertation note: Thesis (Ph.D.) - Cairo University - Faculty of Graduate Studies for Statistical Research - Department of Computer and Information Science Summary: 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
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Home library Call number Copy number Status Barcode
Thesis Thesis قاعة الرسائل الجامعية - الدور الاول المكتبة المركزبة الجديدة - جامعة القاهرة Cai01.18.02.Ph.D.2019.Ha.C (Browse shelf(Opens below)) Not for loan 01010110079592000
CD - Rom CD - Rom مخـــزن الرســائل الجـــامعية - البدروم المكتبة المركزبة الجديدة - جامعة القاهرة Cai01.18.02.Ph.D.2019.Ha.C (Browse shelf(Opens below)) 79592.CD Not for loan 01020110079592000

Thesis (Ph.D.) - Cairo University - Faculty of Graduate Studies for Statistical Research - Department of Computer and Information Science

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

Issued also as CD

There are no comments on this title.

to post a comment.