doi: 10.7763/IJET.2011.V3.220
Evaluation of Cost of Plans in Multiple Dependent Queries Execution Using G.A. Techniques
- Department of Computer Sc.&Engg., Ajay Binay Institute of Technology, Cuttack, Orissa, India . Ex-Professor , U. C. E., Burla, Director, Inter Science Institute of Management & Technology, Bhubaneswar, Orissa , India
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.
Keywords
- Query optimizer
- inter query parallelism
- plan
- gene
- chromosome
- degree coefficient
- fitness value
How to 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. https://doi.org/ 10.7763/IJET.2011.V3.220
Copyright & License
Copyright © 2011 by the authors. This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited (CC BY 4.0).