• Sep 30, 2024 News!Vol.16, No. 3 has been published with online version.   [Click]
  • Jun 13, 2024 News!Vol.16, No. 2 has been published with online version.   [Click]
  • Mar 26, 2024 News!Vol.16, No. 1 has been published with online version.   [Click]
General Information
    • ISSN: 1793-8236 (Online)
    • Abbreviated Title Int. J. Eng. Technol.
    • Frequency:  Quarterly 
    • DOI: 10.7763/IJET
    • APC: 500 USD
    • Managing Editor: Ms. Shira. Lu 
    • Abstracting/ Indexing: Inspec (IET), CNKI Google Scholar, EBSCO, ProQuest, Crossref, Ulrich Periodicals Directory, Chemical Abstracts Services (CAS), etc.
    • E-mail: ijet_Editor@126.com
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-2024. International Journal of Engineering and Technology. All rights reserved. 
E-mail: ijet_Editor@126.com