Dynamic Query Optimization in Relational Database
Journal: International Journal of Emerging Trends & Technology in Computer Science (IJETTCS) (Vol.7, No. 6)Publication Date: 2019-01-08
Authors : Omkar Singh S. K. Singh Ajeet Pal Vibha Mishra;
Page : 001-004
Keywords : ;
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.
Other Latest Articles
- Screening of CYP1B1 Arg368His as predominant mutation in North Indian primary open angle glaucoma and juvenile onset glaucoma patients
- Turbulence Scales in a Compressible Subsonic Boundary Layer at Moderate Reynolds Number
- Association study between DNA methylation and genetic variation of APOE gene with the risk of coronary artery disease
- Cloning and characterization of MAP2191 gene, a mammalian cell entry antigen of Mycobacterium avium subspecies paratuberculosis
- Cloning and molecular characterization of TaERF6, a gene encoding a bread wheat ethylene response factor
Last modified: 2019-01-08 17:17:45