A Novel Approach of Query Optimization for Genetic Population
In relational database large information is maintained and organized so that user can get the desired information in predictable and reliable fashion through the query processing. Retrieving these results in timely manner is Query Optimization. Optimization is a process of choosing most efficient way to execute a SQL query. This is important step in processing of any data manipulation language because in RDBMS, as in large and complicated system performance is key issue. Its an issue that you need to deal with on an ongoing basis so performance must be built in. This paper will provide the reader general concepts of query optimization in relational database system. I will define the implementation plan using join ordering to broaden the potential of database engine through the use of Genetic algorithm in the field of database area in the context of query optimization [12].
Keywords: Query Optimization, relational database, Query processing, Query Algorithms.
Download Full-Text
ABOUT THE AUTHORS
Ishtiaq Ahmed
Ishtiaq Ahmed obtained his MCA degree in 2005 from Sahara Arts & Management Academy, Lucknow, Uttar Pradesh, India. He is currently student of M.Tech (CSE) from Integral University, Lucknow .His main research interest is in the field of Advance Database Management System and Data Structure.
M. Rizwan Beg
Prof. Dr. M. Rizwan Beg is M. Tech & Ph.D in Computer Sc. & Engg. Presently he is working as Professor & Head Deptt. Of Computer Sc. & Engg. And Information Technology of Integral University Lucknow, Uttar Pradesh, India. He is having more than 16 years of experience which includes around 14 years of teaching experience. His area of expertise is Software Engg., Requirement Engineering, Software Quality, and Software Project Management. He has published more than 40 Research papers in International Journals & Conferences. Presently 8 research scholars are pursuing their Ph.D in his supervision. Dr. Beg is Associate Editor in Chief of Advancement in Computing Technology & is also member of editorial board for various other International & National Journals. He is member of large member of International professional societies & also member of Advisory Board for various institutions in India. He chaired a no. of workshops, seminars & National Conference.
Kapil Kumar Gupta
Kapil Kumar Gupta obtained his B. Tech (IT) degree in 2009 from JSS academy of technical education, Noida, Uttar Pradesh, India. He is Astt. Professor in Department of Information Technology, Goel Institute of technology and management, Lucknow. Uttar Pradesh, India. His main research interest is in the field of Image Processing, Design and analysis of algorithms, etc.. He is a Member of CSTA.
Mohd.Isha Mansoori
Mohd. Isha Mansoori obtained his MCA degree in 2005 from Sahara Arts & Management Academy, Lucknow, Uttar Pradesh, India. He is currently working as a Lecturer in Computer Application department of Integral University, Lucknow .His main research interest is in the field of Database Management System and Data Structure.
Ishtiaq Ahmed
Ishtiaq Ahmed obtained his MCA degree in 2005 from Sahara Arts & Management Academy, Lucknow, Uttar Pradesh, India. He is currently student of M.Tech (CSE) from Integral University, Lucknow .His main research interest is in the field of Advance Database Management System and Data Structure.
M. Rizwan Beg
Prof. Dr. M. Rizwan Beg is M. Tech & Ph.D in Computer Sc. & Engg. Presently he is working as Professor & Head Deptt. Of Computer Sc. & Engg. And Information Technology of Integral University Lucknow, Uttar Pradesh, India. He is having more than 16 years of experience which includes around 14 years of teaching experience. His area of expertise is Software Engg., Requirement Engineering, Software Quality, and Software Project Management. He has published more than 40 Research papers in International Journals & Conferences. Presently 8 research scholars are pursuing their Ph.D in his supervision. Dr. Beg is Associate Editor in Chief of Advancement in Computing Technology & is also member of editorial board for various other International & National Journals. He is member of large member of International professional societies & also member of Advisory Board for various institutions in India. He chaired a no. of workshops, seminars & National Conference.
Kapil Kumar Gupta
Kapil Kumar Gupta obtained his B. Tech (IT) degree in 2009 from JSS academy of technical education, Noida, Uttar Pradesh, India. He is Astt. Professor in Department of Information Technology, Goel Institute of technology and management, Lucknow. Uttar Pradesh, India. His main research interest is in the field of Image Processing, Design and analysis of algorithms, etc.. He is a Member of CSTA.
Mohd.Isha Mansoori
Mohd. Isha Mansoori obtained his MCA degree in 2005 from Sahara Arts & Management Academy, Lucknow, Uttar Pradesh, India. He is currently working as a Lecturer in Computer Application department of Integral University, Lucknow .His main research interest is in the field of Database Management System and Data Structure.
