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).
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-2024. International Journal of Engineering and Technology. All rights reserved.
E-mail: ijet_Editor@126.com