• May 03, 2016 News! Vol.7, No.5 has been indexed by EI(Inspec)!   [Click]
  • May 03, 2016 News! Vol.7, No.4 has been indexed by EI(Inspec)!   [Click]
  • Feb 08, 2017 News!Welcome Dr. Lei Chen from China to join the Editorial board of IJET.   [Click]
General Information
Editor-in-chief
Prof. T. Hikmet Karakoc
Anadolu University, Faculty of Aeronautics and Astronautics, Turkey

IJET 2011 Vol.3(2): 179-182 ISSN: 1793-8236
DOI: 10.7763/IJET.2011.V3.220

Evaluation of Cost of Plans in Multiple Dependent Queries Execution Using G.A. Techniques

Sambit Kumar Mishra and Srikanta Pattnaik

Abstract—Multiple processors are employed to improve the performance of database systems and the parallelism can be exploited at three levels in query processing: intra-operation, inter-operation, and inter-query parallelism. Intra-operation and inter-operation parallelism are also called intra-query parallelism which has been studied extensively recently. In contrast, inter-query parallelism has received little attention particularly for multiple dependent queries. As the cost of a given query execution plan is function of many parameters including database structures , the estimated cost of all possible execution plans will be evaluated and also average association degree coefficient between plans will be calculated.

Index Terms—Query optimizer, inter query parallelism, plan, gene, chromosome, degree coefficient, fitness value.

Associate Professor is with the  Department of Computer Sc.&Engg., Ajay Binay Institute of Technology, Cuttack, Orissa, India (e_mail :sambit_pr@rediffmail.com ). Ex-Professor , U. C. E., Burla, Director, Inter Science Institute of Management & Technology, Bhubaneswar, Orissa , India (e_mail :srikantapatnaik@hotmail.com).

[PDF]

Cite: Sambit Kumar Mishra and Srikanta Pattnaik, "Evaluation of Cost of Plans in Multiple Dependent Queries Execution Using G.A. Techniques," International Journal of Engineering and Technology vol. 3, no. 2, pp. 179-182, 2011.

Copyright © 2008-2015. International Journal of Engineering and Technology. All rights reserved. 
E-mail: ijet@vip.163.com