Volume & Issue no: Volume 7, Issue 6, November - December 2018
____________________________________________________________________________________________________
Title: |
Dynamic Query Optimization in Relational Database |
Author Name: |
Mr. Omkar Singh, Dr. S. K. Singh, Mr. Ajeet Pal, Ms. Vibha Mishra |
Abstract: |
Abstract : Query optimizer is an important component in the
architecture of relational data base management system. This
component is responsible for translating user submitted query
into an efficient query evolution program which can be executed
against the database. The present query evolution existing
algorithm tries to find the best possible plan to execute a query
with a minimum amount of time using mostly semi accurate
statistical information (e.g. sizes of temporary relations,
selectivity factors, and availability of resources). It is a static
approach for generating optimal or close to optimal execution
plan. Which in turn increases the execution cost of the query to
reduce the execution cost of the query; I propose a new dynamic
query optimization algorithm which is based on greedy dynamic
programming algorithm uses randomized strategies and reduces
the execution cost of the queries and system resources and also
it works efficiently with distributed and centralized databases.
Keywords- Query optimizer, relational database, static
query optimization, dynamic query optimization. |
Cite this article: |
Mr. Omkar Singh, Dr. S. K. Singh, Mr. Ajeet Pal, Ms. Vibha Mishra , "
Dynamic Query Optimization in Relational Database" , International Journal of Emerging Trends & Technology in Computer Science (IJETTCS) ,
Volume 7, Issue 6, November - December 2018 , pp.
001-004 , ISSN 2278-6856.
|
| Full Text [PDF] Back to Current Issue | |
NOTE: Authors note that paper cannot be withdrawn at any condition once it is accepted. The Team of IJETTCS advise you, do not submit same article to the multiple journals simultaneously. This may create a problem for you. Please wait for review report which will take maximum 01 to 02 week.