• Mar 01, 2017 News! Vol.8, No.2 has been indexed by EI(Inspec)!   [Click]
  • Mar 01, 2017 News! Vol.8, No.1 has been indexed by EI(Inspec)!   [Click]
  • Mar 01, 2017 News! Vol.7, No.6 has been indexed by EI(Inspec)!   [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-2017. International Journal of Engineering and Technology. All rights reserved. 
E-mail: ijet@vip.163.com