Earticle

초록

영어

Without multi query optimization, Relational Database Management System for online and analytical decision support systems would have been inefficient and hence unpractical. It is an expensive process because it relies at a great extent on evaluating the different plans (access paths) and choosing an optimal one among them. In Multi Query Optimization, queries are executed in batches and there were many different algorithms acted in such way that, in case some queries have a common sub-expression such a sub- expression is executed once and the output shared. We studied the basic multi query optimization algorithms including Basic Volcano, Volcano-SH and Volcano RU, identified their strengths and weaknesses and recommend strategies for developing new improved multi query optimization algorithm so as to reduce weaknesses and integrate strengths of the different basic multi query algorithms into one efficient algorithm.

목차

Abstract
 1. Introduction
 2. Multi-Query Optimization (MQO)
 3. Multi Query Optimization Algorithms
  3.1 Basic Volcano Algorithm
  3.2 Volcano SH Algorithm
  3.3 Volcano-RU Algorithm
 4. Future Work
 5. Conclusion
 References

키워드

저자

• Muhammad, L. J. [ Dept. of Maths & Comp. Sceince, Federal University, Kashere ]
• Yahaya Bala Zakariyau [ Dept. of Maths & Comp. Sceince, Federal University, Kashere ]
• Abdullahi Garba Ali [ Computer Science Department, Bayero University, Kano ]
• Abba Garba [ Dept. of Comp. Science & Info Systems, Kampala International University ]

참고문헌

발행기관

간행물

표지보기 관심저널 등록

• 간행물명

  International Journal of Database Theory and Application

• 간기

  격월간

• pISSN

  2005-4270

• 수록기간

  2008~2016

• 십진분류

  KDC 505 DDC 605